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!
