topic Re: Issue with getting date function to populate filename in SAS Viya

Issue with getting date function to populate filename

bweeks59 — Thu, 01 Apr 2021 16:00:14 GMT

I am using this code to populate the date in filename as seen below but the output is not returning the date. Filename comes out like this SAS_backup_roll_&now1..xlsx - This works fine in BASE SAS but not in VIYA Studio, using PROC Export as well to export multiple worksheets to the excel workbook. Any help will be greatly appreciated.

%let now1=%sysfunc(today(),yymmddd10.);
filename backup filesrvc folderpath= '/USCG/Aviation Logistics Division/RMB/OUTPUTS/' filename='SAS_backup_roll_&now1..xlsx';

Proc export data=work.tpcA
outfile=backup
dbms=xlsx replace;
sheet='A-TPC funds';
run;

Re: Issue with getting date function to populate filename

PaigeMiller — Thu, 01 Apr 2021 16:04:58 GMT

I'm not sure how it could ever work in any version of SAS with single quotes after filename=

It should work with double-quotes

... filename="SAS_backup_roll_&now1..xlsx";

unless there are other problems that are not obvious.

Re: Issue with getting date function to populate filename

bweeks59 — Thu, 01 Apr 2021 16:13:18 GMT

Thanks so much for catching the single quote, this worked perfectly after I made the change. I am reusing code someone else wrote and did not see this...not sure how it worked in BASE but that is she was using it before we upgraded to VIYA. Now I am curious if it really ran there but not looking back. I really appreciate the help, got into the weeds and could not see it.