Macro variable in filename statement

[EinarRoed]

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?

[Kurt_Bremser · Accepted solution]

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