No Observation

SAS Day 48:

Challenge： How to create a label for “No Observation” when there is no observation?

Approach: We know SQL is the best tool for Counting and macro for generating all 0 counts 

Monfocus / Pixabay

SAS code:

*Count observations;
proc sql noprint;
select count(enrid) into: obs
from a where (cond) ;
quit;

*macro for no obs;
%macro no_obs();
%if &obs=0 %then %do;
data all;
label="No events were reported";
run;
%end;
%mend;

%no_obs();

Output:

Happy SAS coding!