topic Re: proc sql to obtain individual level data in SAS Programming

proc sql to obtain individual level data

avepo — Sat, 02 Jun 2018 18:09:54 GMT

Hi,

I have a dataset that I want to generate individual level dataset. I could do this by proc sort, data (retain, first.id) but I think proc sql would be more efficient in coding (some may not agree with this). Thanks

Currently I have

ID flag1 flag2 flag3

1 1 0 1

1 0 1 0

2 1 1 0

2 0 1 0

I would want the output to look like

ID flag1 flag2 flag3

1 1 1 1

2 1 1 0

Re: proc sql to obtain individual level data

kiranv_ — Sat, 02 Jun 2018 18:16:34 GMT

something like

proc sql;

select ID , max(flag1) as flag1, max( flag2 ) as flag2, max(flag3) as flag3

from have

group by id;

Re: proc sql to obtain individual level data

novinosrin — Sat, 02 Jun 2018 18:35:37 GMT

Hi @avepo In my humble opinion, i would think you are better off using proc means/summary as you can take advantage of using variable lists and not bother typing max(var) one by one forever if you happen to have numerous flag vars.

Also it helps lazy people like me at best

data have;
input ID    flag1 flag2  flag3;
cards;
1     1       0         1
1     0       1         0
2     1       1         0
2     0        1        0
;

proc means data=have nway noprint;
class id;
var flag:;
output out=want(drop=_:) max=;
run;

Re: proc sql to obtain individual level data

avepo — Mon, 04 Jun 2018 12:22:40 GMT

Thank you both!