Macro variable in filename statement

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 89
Accepted Solution

Macro variable in filename statement

[ Edited ]

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?


Accepted Solutions
Solution
‎03-23-2017 07:51 AM
Super User
Posts: 6,936

Re: Macro variable in filename statement

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎03-23-2017 07:51 AM
Super User
Posts: 6,936

Re: Macro variable in filename statement

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 729 views
  • 1 like
  • 2 in conversation