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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.