topic Export table only when it contains data in SAS Programming

Export table only when it contains data

GonetteSmith — Thu, 08 Sep 2016 12:19:21 GMT

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

Re: Export table only when it contains data

Reeza — Thu, 08 Sep 2016 12:23:48 GMT

https://communities.sas.com/t5/SAS-Enterprise-Guide/export-data-set-to-excel-only-when-data-set-contains-data/m-p/238686/highlight/true#M17184

Re: Export table only when it contains data

Ksharp — Thu, 08 Sep 2016 12:36:04 GMT

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)