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.
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.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.