Why won’t my macro variable resolve?

by

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

More Related Contents:

  1. Dynamically call macro from sas data step
  2. sas MACRO ampersand
  3. How to detect how many observations in a dataset (or if it is empty), in SAS?
  4. How do I see what output options are available in my proc?
  5. Is there a way to make SAS stop upon the first warning or error?
  6. SAS: concatenate different datasets while keeping the individual data table names
  7. SAS Data organization
  8. Nested ifelse statement
  9. Large, persistent DataFrame in pandas
  10. SAS Display Manager commands

Leave a Comment