Export table only when it contains data

[GonetteSmith]

Good Afternoon!

I have the below exporting query, but I only want the table to export if it contains observations. 

PROC EXPORT DATA=results.ClosingStockWave1 DBMS=csv
OUTFILE="\\athena\Projects\Tanzania PMI RA\Data Management\SAS Setup\Field Queries\NewSKUs.csv" REPLACE;
RUN;

Can anyone assist me?

Kind Regards

[Reeza · Accepted solution]

https://communities.sas.com/t5/SAS-Enterprise-Guide/export-data-set-to-excel-only-when-data-set-cont...

[Ksharp]

Make a macro:



%macro export(dsn=);
%let dsid=%sysfunc(open(&dsn));
%let nobs=%sysfunc(attrn(&dsid,nlobs));
%let dsid=%sysfunc(close(&dsid));

%if &nobs ne 0 %then %do;
 %put Put your EXPORT here;
%end;
%mend;


%export(dsn=sashelp.class)