Add QTR to FileName

BonnaryW — Thu, 12 Jul 2018 21:57:54 GMT

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.

Re: Add QTR to FileName

Reeza — Thu, 12 Jul 2018 22:08:31 GMT

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.

topic Add QTR to FileName in SAS Programming

Add QTR to FileName

Re: Add QTR to FileName