Desktop productivity for business analysts and programmers

Add data to excel filename

Reply
Contributor
Posts: 30

Add data to excel filename

ods  tagsets.ExcelXP path='P:\' file='CDRP Referral Review.xml' style=printer;

 I want to add  date to the file name when its run  

Super User
Posts: 9,560

Re: Add data to excel filename

Note that @Reeza used double quotes around the filename, so that resolution of the macro function %sysfunc works. Single quotes prevent the macro facility from resolving macro triggers within the string.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 1 reply
  • 135 views
  • 0 likes
  • 2 in conversation