Data I have:
ID ELASS MATHSS SCISS SOCSS
1 100
1 210
1 325
1 225
2 120
2 225
2 410
2 228
I want one obs per ID, like so:
ID ELASS MATHSS SCISS SOCSS
1 100 210 325 225
2 120 225 410 228
data have;
input ID ELASS MATHSS SCISS SOCSS;
cards;
1 100 . . .
1 . 210 . .
1 . . 325 .
1 . . . 225
2 120 . . .
2 . 225 . .
2 . . 410 .
2 . . . 228
;
data want;
update have(obs=0) have;
by id;
run;
data have;
input ID ELASS MATHSS SCISS SOCSS;
cards;
1 100 . . .
1 . 210 . .
1 . . 325 .
1 . . . 225
2 120 . . .
2 . 225 . .
2 . . 410 .
2 . . . 228
;
data want;
update have(obs=0) have;
by id;
run;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.