有一个数据集,如下面的程序所建:
data sj;
input id A1$ A2$ A3$ B1$ B2$ B3$@@;
cards;
1 A A A B B B
2 C C C D D D
3 E E E F F F
;
run;
想将它拆成6个观测如下:
id var1 var2 var3
1 A A A
1 B B B
2 C C C
2 D D D
3 E E E
3 F F F
,
请各位帮忙指点:)
data sj;
input id A1$ A2$ A3$ B1$ B2$ B3$@@;
cards;
1 A A A B B B
2 C C C D D D
3 E E E F F F
;
run;
data crackman;
set sj(keep=id a: ) sj(rename=(b1=a1 b2=a2 b3=a3) keep=id b:);
by id;
run;