topic Re: Add date to file - giving JAN1960 in SAS Programming

Add date to file - giving JAN1960

c1991 — Fri, 06 Jan 2017 08:23:22 GMT

Good day,

I would like to add a date to a file, however, it should reflect the previous month. Reason is the files for December will be received and ran in January, however, the file name should then have DEC2016 in it.

My code works, however, it gives an output of JAN1960 (which is day 0).

I cannot seem to find what the issue is. My code below:

PROC EXPORT 
DATA = V_B
OUTFILE = "&path\V_B_%sysfunc(putn(%eval(%sysfunc(month(-1))),monyy7)).csv"
dbms= csv replace;
RUN;

Thank you

Re: Add date to file - giving JAN1960

Daniel-Santos — Fri, 06 Jan 2017 08:55:54 GMT

Hi.

This will sort it for you I think.

 * create macro var with desired date, migth be helpful ahead;
 %let FDATE=%sysfunc(putn(%sysfunc(intnx(MONTH,%sysfunc(date()),-1)),monyy7.));

PROC EXPORT 
     DATA = V_B
     OUTFILE = "&path\V_B_&FDATE..csv"
     dbms= csv replace;
RUN;

You need do use the DATE function to retrieve the filesystems date and the INTNX function to subtract one month from it.

More on DATE: http://support.sas.com/documentation/cdl/en/etsug/63939/HTML/default/viewer.htm#etsug_intervals_sect014.htm

More on INTNX: https://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#p10v3sa3i4kfxfn1sovhi5xzxh8n.htm

Hope it helps.

Daniel Santos @ www.cgd.pt

Re: Add date to file - giving JAN1960

Patrick — Fri, 06 Jan 2017 09:10:42 GMT

The following should work:

"&path\V_B_%sysfunc(intnx(month,%sysfunc(today()),-1,b),monyy7.).csv"

You get a date of 1960 because function month(-1) doesn't work the way you believe it does (look it up in the manual) and returns a value of 12 - which SAS interpretes as the 12th day when the count of days starts - which is 1/1/1960.

Re: Add date to file - giving JAN1960

c1991 — Fri, 06 Jan 2017 10:27:45 GMT

Thank you. Both solutions work.

I'm still fairly new at sas, so thank you for helping me 🙂