DATA Step, Macro, Functions and more

Add QTR to FileName

Accepted Solution Solved
Reply
Contributor
Posts: 51
Accepted Solution

Add QTR to FileName

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.


Accepted Solutions
Solution
Thursday
Super User
Posts: 23,688

Re: Add QTR to FileName

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.


 

View solution in original post


All Replies
Solution
Thursday
Super User
Posts: 23,688

Re: Add QTR to FileName

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.


 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 44 views
  • 0 likes
  • 2 in conversation