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
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)
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.