我有一个关于以特定方式分离数据集中的变量的问题。当我们进行实地工作时,我们必须以如下方式收集数据:
Range Row HGT V HGT2 V2 HGT3 V3 HGT4 V4
1 2 151 15 127 22 114 16 97 12实际上,变量并不是不同类型的度量,而是从起点到不同的距离。正因为如此,我想把数据转换成这样的表单:
Range Row HGT V HGT2 V2 HGT3 V3 HGT4 V4
1 2 151 15 . . . . . .
1 2 . . 127 22 . . . .
1 2 . . . . 114 16 . .
1 2 . . . . . . 97 12通过这种方式,我可以使用一组if-然后语句为每一行数据放入真正的行,因为范围/行是我们识别所有内容的方法,并使用sql中的coalesce语句将数据压缩回两个变量。我知道用excel可以很容易地做到这一点,但是我们的实验室负责人强烈反对这一点,因为我们有犯错的风险。
发布于 2014-07-16 16:59:16
如果变量的数量是确定的,那么您可以遵循这个方法。
假设:源数据为"Range_data“
data Range_data_1(keep=Range Row HGT V);
set Range_data;
run;
data Range_data_2(keep=Range Row HGT2 V2);
set Range_data;
run;
data Range_data_3(keep=Range Row HGT3 V3);
set Range_data;
run;
data Range_data_4(keep=Range Row HGT4 V4);
set Range_data;
run;
data All_Range;
set Range_data_1 Range_data_2 Range_data_3 Range_data_4;
run;建议:
发布于 2014-07-16 16:21:27
这个有用吗?
SELECT RANGE, ROW, HGT, V, NULL AS HGT2, NULL AS V2, NULL AS HGT3, NULL AS V3, NULL AS HGT4, NULL AS V4
UNION
SELECT RANGE, ROW, NULL AS HGT, NULL AS V, HGT2, V2, NULL AS HGT3, NULL AS V3, NULL AS HGT4, NULL AS V4
UNION
SELECT RANGE, ROW, NULL AS HGT, NULL AS V, NULL AS HGT2, NULL AS V2, HGT3, V3, NULL AS HGT4, NULL AS V4
UNION
SELECT RANGE, ROW, NULL AS HGT, NULL AS V, NULL AS HGT2, NULL AS V2, NULL AS HGT3, NULL AS V3, HGT4, V4发布于 2014-07-18 23:36:10
这里是前两个索引的示例。
data newData (drop=i j Vold V2old HGTold HGT2old);
format HGT V HGT2 V2;
set oldData (rename=(V=Vold V2=V2old HGT=HGTold HGT2=HGT2old));
array arrVold[2] Vold V2old;
array arrVnew[2] V V2;
array arrHold[2] HGTold HGT2old;
array arrHnew[2] HGT HGT2;
do i=1 to dim(arrVold);
do j=1 to dim(arrVold);
arrHnew[j]=.;
arrVnew[j]=.;
end;
arrHnew[i]=arrHold[i];
arrVnew[i]=arrVold[i];
output;
end;
run;https://stackoverflow.com/questions/24785483
复制相似问题