Thanks for all the suggestions. I have made some progress. The code thus far is: data want; infile input dsd; length dummy $ 1; input dummy dummy dummy dummy R4H dummy dummy INT; keep R4H INT ; run; proc sql; create table MSU1 as select Max(R4H) as r4hmax, Avg(R4H) as r4havg, R4H > 40 as r4hgt40, R4H > 45 as r4hgt45, R4H > 48 as r4hgt48, R4H > 50 as r4hgt50, R4H > 52 as r4hgt52, R4H > 55 as r4hgt55, R4H > 57 as r4hgt57, R4H > 60 as r4hgt60, Avg(INT) as intavg, Max(INT) as intmax, INT > .75*57 as intgt75%, INT > .80*57 as intgt80% from want where R4H ; quit; proc freq data=MSU1 ; tables R4Havg r4hmax r4hgt40 r4hgt45 r4hgt48 r4hgt50 r4hgt52 r4hgt55 r4hgt57 r4hgt60 intavg intmax intgt75% intgt80%; run; Not completed yet but a start.
... View more