topic Re: combining observations based on unique ID in SAS Programming

combining observations based on unique ID

GreggB — Tue, 11 Sep 2018 18:47:13 GMT

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

Re: combining observations based on unique ID

novinosrin — Tue, 11 Sep 2018 18:50:53 GMT

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;