proc 转置具有重复的 ID 值 [英] proc transpose with duplicate ID values

问题描述

我需要有关 SAS 中 proc 转置过程的帮助.我的代码最初是:

I need help with proc transpose procedure in SAS. My code initially was:

proc transpose data=temp out=temp1; 
by patid;
var text;
Id datanumber;
run;

这给了我错误ID 值"在同一个 BY 组中出现两次".我将代码修改为:

This gave me error "The ID value " " occurs twice in the same BY group". I modified the code to this:

proc sort data = temp; 
by patid text datanumber; 
run;

data temp; 
set temp by patid text datanumber; 
if first.datanunmber then n = 0; 
n+1; 
run;

proc sort data = temp; 
by patid text datanumber n; 
run;

proc transpose out=temp1 (drop=n) let;
by patid;
var text;
id datanumber;
run;

这给了我错误:无法识别变量 n.添加 let 选项会出现很多错误在同一个 BY 组中出现两次".我想保留所有 id 值.

This is giving me error: variable n is not recognized. Adding a let option is giving a lot of error "occurs twice in the same BY group". I want to keep all id values.

请帮我解决这个问题.

数据示例:朴实的文字

推荐答案

当您收到该错误时，它告诉您您尝试创建的一个或多个变量有多个数据点.如果在 proc 转置行中添加let"，SAS 可以强制转置并删除额外的数据点.

When you get that error it is telling you that you have multiple data points for one or more variables that you are trying to create. SAS can force the transpose and delete the extra datapoints if you add "let" to the proc transpose line.

这篇关于proc 转置具有重复的 ID 值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！