I am trying to use max function within proc sql but not getting desired result. I need the max value of a lab grade post baseline. Basically, I do not want to consider certain visits (screening and baseline) for max value calculation but it seems the max function is is considering all the visit not just visit > 2 (See below). proc sql ; create table test1 as select *, case when toxgr ne '' and visit> 2 then max(toxgr) end as gr1 from tlab group by usubjid,paramcd,lbcat; quit;
... View more
