proc sql; group by; case statement

[blakezen]

Thanks PG! So, as applied to my queries above, the where being in parenthesis following the from dataset statement is used as a dataset option?

you're saying use:
from dataset
where var1=1 and var2 is not missing
group by var3
order by var4
;
run;

[PGStats]

Right!

[blakezen]

Thanks so much!