Add QTR to FileName

[BonnaryW]

Hello,

I need help on how to add previous QTR to the filename.  My code is below.

ods _all_ close;

%let q= (%sysfunc(intnx(qtr,%sysfunc(date()),-1)));

%put &q;

ods tagsets.excelxp file="c:\myfile_Q&q..xls"

style=sasweb;

My filename should be "c:\myfile_Q2.xls. I am getting "c:\myfile_Q&q.xls".

Thank you.

[Reeza · Accepted solution]

Macro variables are literal text replacement. I see the %PUT statement but it doesn't generate what you expect so that's where your error is. 

Your PUT statement shows:

(21275)

You're creating a SAS date but don't apply a format. For Q# format try QTR format, which can be applied directly in SYSFUNC. You also have extraneous parenthesis.

%let q= %sysfunc(intnx(qtr,%sysfunc(date()),-1), qtr.);

---

@BonnaryW wrote:

Hello,

I need help on how to add previous QTR to the filename.  My code is below.

ods _all_ close;

%let q= (%sysfunc(intnx(qtr,%sysfunc(date()),-1)));

%put &q;

ods tagsets.excelxp file="c:\myfile_Q&q..xls"

style=sasweb;

My filename should be "c:\myfile_Q2.xls. I am getting "c:\myfile_Q&q.xls".

Thank you.

---