topic file saving with sas date format in SAS Programming

file saving with sas date format

tparvaiz — Wed, 24 May 2017 19:41:36 GMT

Hi,

I am saving an excel file with a date variable as part of the file name. my problem is that the file is saved using SAS date format rather than a calander date

here is a sample code that I am using

data _null_;
format week comma10.0;
format date MONYY.;

week = 1;

date = intnx('month',today(),0);

call symputx('week',week);
call symputx('date',date);

run;

%let label = &date. week &week.;
%put &label.;

data _null_;
file cmds;
put "[save.as(%bquote("C:\Report &label..xlsx"))]";

put '[CLOSE()]';
run;

file is saving like this

Report 20940 week 1.xlsx

I want file to save as Report May2017 week 1.xlsx

by somehow converting sas date format to monthyear date format

Thanks

Re: file saving with sas date format

Astounding — Wed, 24 May 2017 19:58:03 GMT

You can do this by changing the value assigned to &LABEL. I'm going to show you something a little different than what you asked for:

%let label = %sysfunc(putn(&date., yymmn6.)) week &week.;

This will give you 201705 instead of May2017. That way, all your file names will alphabetize in chronological order.

Re: file saving with sas date format

tparvaiz — Wed, 24 May 2017 20:55:48 GMT

Thanks for your assistance