Hi all, User named ksharp had replied to my post in base sas programming group,I got the required output. Below is the syntax. data have;
set ds;
by idno;
if first.idno or lab='red1' then group+1;
run;
proc sql;
select *
from have
group by group
having n(value) ne 0;
quit;
... View more
