10-21-2015 08:30 AM
You can write a macro that only executes more code if the number of observations is > 0, and it stops executing if the number of observations is = 0.
%macro example; proc sql noprint; select count(variablename) into :nobs from datasetname; quit; %if &nobs>0 %then %do; .... whatever SAS code you want .... %end; %mend;
10-21-2015 09:16 AM
There are various ways to check the obs, the previous comment contains one. To exit a sas script the abort statement is probably an option for you.
10-21-2015 10:21 AM
To me, that sounds like a bad idea. Personally, if your code doesn't create anything then there should be some defensive coding which creates and outpu stating there is no results. Any abort/abend in code I use is pulled out as a problem, code should flow through without any errors, warnings, abnormal exits, and the final output should be qc'able even if only to confirm zero observations.