What adjustment to the following code could lead to carry out the same only under some specific condition?
ODS CSV FILE = "F:\Temp\Test.csv";
PROC PRINT data=WORK.FINALDATA;
run; quit;
ods _all_ close;
In other words, how to have the Test.csv generated only if desired, i.e. judged on the basis of the value of a variable. For example if a macro variable CSVFORM possess the value of 1 or above only then the Test.csv would be generated otherwise only the remaining code would be carried out but Test.csv would not be made.
Thanx in advance.
%macro file;
ODS CSV FILE = "F:\Temp\Test.csv";
PROC PRINT data=WORK.FINALDATA;
run; quit;
ods _all_ close;
%mend;
%macro print;
PROC PRINT data=WORK.FINALDATA;
run; quit;
%mend;
data _null_;
set WORK.FINALDATA;
if &CSVFORM>=1 then call execute('%file');
else call execute('%print');
run;
Thanks,
Jagadish
%macro file;
ODS CSV FILE = "F:\Temp\Test.csv";
PROC PRINT data=WORK.FINALDATA;
run; quit;
ods _all_ close;
%mend;
%macro print;
PROC PRINT data=WORK.FINALDATA;
run; quit;
%mend;
data _null_;
set WORK.FINALDATA;
if &CSVFORM>=1 then call execute('%file');
else call execute('%print');
run;
Thanks,
Jagadish
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.