I have an ETL-job that runs each day. It creates a csv-file that needs to be deleted at the end of the job.
I can delete a specific file using this code:
data _null_;
filename delfile 'c:\temp\file_2017_03_23.csv';
rc = fdelete('delfile');
run;
However I don't want to indicate one specific file, because the filename will vary each day.
I'd like to be able to do something like this:
data _null_;
filename delfile 'c:\temp\file_&datestamp..csv';
rc = fdelete('delfile');
run;
/*the &datestamp would always refer to the current day*/
However, the filename statement doesn't accept macro variables.
Do you have any advice on how I can resolve this?
Use double quotes. Single quotes prevent the resolution of macro triggers (% and &).
Use double quotes. Single quotes prevent the resolution of macro triggers (% and &).
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.