data have;
input Paitent_ID: Proc1: Proc2: Proc3: ;
cards;
12 2344 1233 894
12 1902 . .
12 111 2344 9001
12 234 . .
13 232 3934 3434
13 1444 . .
;
data want;
do until(last.Paitent_ID);
set have;
by Paitent_ID;;
count=sum(count,n(of pro:));
end;
run;
... View more
