Macro variable in filename statement

EinarRoed — Thu, 23 Mar 2017 11:04:53 GMT

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?

Re: Macro variable in filename statement

Kurt_Bremser — Thu, 23 Mar 2017 11:21:30 GMT

Use double quotes. Single quotes prevent the resolution of macro triggers (% and &).

topic Re: Macro variable in filename statement in SAS Programming

Macro variable in filename statement

Re: Macro variable in filename statement