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 &).
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.