I have a macro variable, &myvar
, but it won\'t resolve when I try to put it in a data step variable. Why won\'t it, and what can I do to fix this?
%let myvar=Hello, world;
data _null_;
x=\'&myvar.\';
put x=;
run;
I have a macro variable, &myvar
, but it won\'t resolve when I try to put it in a data step variable. Why won\'t it, and what can I do to fix this?
%let myvar=Hello, world;
data _null_;
x=\'&myvar.\';
put x=;
run;
Macro variables in SAS won\'t resolve when they are in single quotes, \'&myvar\'
. They need to be in double quotes, \"&myvar\"
, in order to resolve properly.
If you need to have single quotes and a resolved macro variable, you have a few options, but the simplest is:
%str(%\'&myvar.%\')
The %\'
inside of %str
will place a single quote character (or apostrophe) in the text string by itself without causing it to be quoted.
data _null_;
x=\"%str(%\'&myvar.%\')\";
put x=;
run;
or
%let myvar2 = %str(%\'&myvar.%\');