Combine flags across within group

SAShole — Sun, 07 Mar 2021 20:06:49 GMT

I have a long dataset like shown below and would like to report out just the unique ID's and combine their flags like this:

Data Have;
infile datalines delimiter = "," dsd;
input ID flagA $ FlagB $ FlagC $;
cards;
1,F,,
2,F,,
2,,,F
3,F,,
3,,F,
3,,,F
4,,,F
5,,F,

;
run;

data want;
infile datalines delimiter = "," dsd;
input ID flagA $ FlagB $ FlagC $;
cards;
1,F,,
2,F,,F
3,F,F,F
4,,,F
5,,F,
;
run;
proc print data=want;

Re: Combine flags across within group

FreelanceReinh — Sun, 07 Mar 2021 20:25:03 GMT

Hello @SAShole,

Try this:

data want;
update have(obs=0) have;
by id;
run;

topic Re: Combine flags across within group in SAS Programming

Combine flags across within group

Re: Combine flags across within group