Hi I have this peace of code which i want to use to look up a file created 6 days ago, e.g. 20180816. The file name should be G20180816.txt.
%let kurs_datum = %eval(%sysfunc(today())-6);
data format_date;
format kurs_datum yymmddn8.;
run;
%let infil="C:\G&kurs_datum..txt";
When i run this code i got this error message. It looks like that it is still using SAS's date format.
ERROR: Physical file does not exist, C:\G21412.txt.
How do I solve this?
handle date calculations in the data step and use CALL SYMPUT logic to create macro variables.
data _null_;
dt=today()-6;
path=cats("'C:\G", put(dt, yymmddn8.), ".txt'");
call symputx('path', path);
run;
%put &path.;
handle date calculations in the data step and use CALL SYMPUT logic to create macro variables.
data _null_;
dt=today()-6;
path=cats("'C:\G", put(dt, yymmddn8.), ".txt'");
call symputx('path', path);
run;
%put &path.;
Anytime, glad to help 🙂
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.