topic unquoting macro var in stored process in SAS Programming

unquoting macro var in stored process

DataShare — Fri, 05 Aug 2011 05:50:00 GMT

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);　

data_null__ — Fri, 05 Aug 2011 11:24:30 GMT

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;