s******1
发帖数: 178 | 1 I have a data set1
var1 var2 var3
1 . .
2 . .
. 3 .
. 4 .
. . 5
. . 6
and want to get data set2
var1 var2 var3
1 3 5
2 4 6
what kind of sas code I can use?
Thank you very much! |
k*******a
发帖数: 772 | 2 这个看你怎么定义合并的方法了， 可以试试下面的看看
data test1;
merge test(keep=var1 where=(var1 ne .))
test(keep=var2 where=(var2 ne .))
test(keep=var3 where=(var3 ne .))
;
run; |
s******1
发帖数: 178 | 3 Thank you very much!
I will try!
But if I have 30 variables like this way, how should I do? |
k*******a
发帖数: 772 | 4 看你定义怎么合并了 （每个删掉前两个，还是删掉所有missing,或者....)，肯定有更
好的办法。
30个也不是问题，用macro就可以了
【在 s******1 的大作中提到】
: Thank you very much!
: I will try!
: But if I have 30 variables like this way, how should I do?
|
s******1
发帖数: 178 | |
