SAS 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

[caption id="attachment_2896" align="alignnone" width="600"] image

Monfocus / Pixabay[/caption]

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:

image

Happy SAS coding!