pobel 发表于 2013-7-10 16:08
data a;
input ID :$ N :$;
cards;
如果这些数据都是一个变量X下的，有很多个X(X1，X2，X3...),每个X都有很多ID，每个ID又有很多N的话那又该怎么办呢?
X ID N
X1 a a11
X1 a a12
X1 a a13
X1 b b11
X1 b b12
X1 b b13
X1 b b14
X1 b b15
X1 c c11
X1 c c12
X1 c c13
X2 a a21
X2 a a22
X2 a a23
X2 b b21
X2 b b22
X2 b b23
X2 b b24
X2 b b25
X2 c c21
X2 c c22
X2 c c23
...
data n1;
input id $ number $;
cards;
a a1
a a2
a a3
b b1
b b2
b b3
b b4
b b5
c c1
c c2
c c3
c c4
run;
data n2;
set n1;
by id;
if first.id=1;
run;
data n3;
set n1;
by id;
if first.id=1 then delete;
run;
data n4;
set n3;
by id;
if first.id=1 ;
run;
data n5;
set n3;
by id;
if first.id=1 then delete;
run;
data n6;
set n5;
by id;
if first.id=1 ;
run;
data n7;
set n2 n4 n6;
run;
proc sort data=n7;
by id;
run;
扫码加好友，拉您进群
全部版块
我的主页
收藏
