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!