Hi, I am using the following 3 proc sql to generate 3 proc sql;
create table test3 as
select *, SUM( count ) as dur
from test2
group by id,gr
;
quit;
proc sql;
create table test4 as
select *, case
when dur=11 then 1
end as stay
from test3
;
quit;
proc sql;
create table test5 as
select *, max(stay) as staykeep
from test4
group by id
;
quit; variables from a dataset. Can you please suggest how can I do that under a single proc sql?
... View more
