within testit macro i want macro variables to be resolved and the outfile name to be generated as sasuser05AUG11_Test's
one way to force the resolution is to use %unquote , %unquote works if the oname does not contain the single quote
Any suggestions to make it work with oname having single quote or any other quoted character as well ?
%macro testit(outputlocation, outputname);
%let outfile=&outputlocation/&outputname;
%put &outfile;
%mend;
%let _metauser=sasuser;
%let oname=%str(&)_metauser.%str(&)SYSDATE._Test%str(%')s;
%put This is how values are passed into the stored process: &oname;
%let oloc=c:\mysas;
%testit(&oloc, &oname);
Are you coding for full job security?
BQUOTE will quote an unmatched un-escaped single quote.
I usually macro variables in %PUT.
%macrotestit (outputlocation, outputname);
%letoutfile =&outputlocation/&outputname;
%put& outfile;
%mend;
%let_ metauser=sasuser;
%letoname =% str(&)_ metauser.%str(&) SYSDATE._Test% str(%') s;
%letoname =% nrbquote(%unquote(& oname));
%put This is how values are passed into the stored process: % superQ( oname);
%letoloc=c:\mysas;
%testit(&oloc, &oname);
I would change the date format to YYYYMMDD so the filenames will sort in a more pleasing order.
%let oname=%str(&)_metauser.%sysfunc(today(),yymmddn8.)_Test%str(%')s;
Are you coding for full job security?
BQUOTE will quote an unmatched un-escaped single quote.
I usually macro variables in %PUT.
%macrotestit (outputlocation, outputname);
%letoutfile =&outputlocation/&outputname;
%put& outfile;
%mend;
%let_ metauser=sasuser;
%letoname =% str(&)_ metauser.%str(&) SYSDATE._Test% str(%') s;
%letoname =% nrbquote(%unquote(& oname));
%put This is how values are passed into the stored process: % superQ( oname);
%letoloc=c:\mysas;
%testit(&oloc, &oname);
I would change the date format to YYYYMMDD so the filenames will sort in a more pleasing order.
%let oname=%str(&)_metauser.%sysfunc(today(),yymmddn8.)_Test%str(%')s;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.