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!

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Social media & sharing icons powered by UltimatelySocial
%d bloggers like this: