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 🙂
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: