Solved: How do I put the current date into the name of a file to export? - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Calcite | Level 5

Calcite | Level 5

How do I put the current date into the name of a file to export?

Posted 09-06-2012 04:22 PM (1340 views)

I want to export a file in the format of abc_20120906.csv. How can I implement code so I don't need to hard code the date every time I run the pgm:

OUTFILE='''/depts/abc_date variable name..csv'''

1 ACCEPTED SOLUTION

Accepted Solutions

Diamond | Level 26

Diamond | Level 26

Re: How do I put the current date into the name of a file to export?

Posted 09-06-2012 04:27 PM (1437 views) | In reply to Mike7085

You would use a MACRO variable here, see Example 1 in the %SYSFUNC statement documentation

--
Paige Miller

View solution in original post

2 REPLIES 2

Diamond | Level 26

Diamond | Level 26

Re: How do I put the current date into the name of a file to export?

Posted 09-06-2012 04:27 PM (1438 views) | In reply to Mike7085

You would use a MACRO variable here, see Example 1 in the %SYSFUNC statement documentation

--
Paige Miller

Calcite | Level 5

Calcite | Level 5

Re: How do I put the current date into the name of a file to export?

Posted 09-06-2012 05:03 PM (1284 views) | In reply to PaigeMiller

worked as advertised. Thanks for the quick response!!

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!