Maybe this:
data have;
format studyid z5.;
input studyid drug1-drug3;
datalines;
00001 1 0 0
00001 0 0 1
00002 0 1 0
;
run;
data want;
set have;
by studyid;
if first.studyid then
rx_total=0;
rx_total+sum(of drug:);
if last.studyid and rx_total=1 then
output;
drop rx_total;
run;
assumes only one drug can be 1 for any given observation.
... View more