Why won't my macro variable resolve?

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.%');