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
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.