topic Re: macro variable in title in SAS Programming

macro variable in title

superbibi — Wed, 13 Mar 2019 02:23:29 GMT

Hi SAS Users,

I am using SAS University Edition and I want to add the macro variable in the title.

data a;
input group $;
datalines;
groupa
groupb
;
run;



%macro print (group);

title '&group';
proc print data = a;
where group = &group;
run;

%mend print;

%print (group);

my output title is only showing "&group" instead of "groupa" which I want to be.

How should I correct the code?

Re: macro variable in title

Reeza — Wed, 13 Mar 2019 02:28:47 GMT

Use double quotes instead of single quotes, macro variables do not resolve in single quotes.

This allows a user to have a & or % in a string and SAS will not try to resolve it, otherwise it would think it's related to a macro or macro variable.

@superbibi wrote:

Hi SAS Users,

I am using SAS University Edition and I want to add the macro variable in the title.
data a;
input group $;
datalines;
groupa
groupb
;
run;



%macro print (group);

title '&group';
proc print data = a;
where group = &group;
run;

%mend print;

%print (group);
 
my output title is only showing "&group" instead of "groupa" which I want to be.

How should I correct the code?

Re: macro variable in title

Reeza — Wed, 13 Mar 2019 02:30:11 GMT

Your code has other issues, but I'll give you a chance to debug those first by yourself. If you have other issues, post a new question.

Re: macro variable in title

superbibi — Wed, 13 Mar 2019 13:39:06 GMT

Thank you so much! After changing as a double quote it works! I correct the other issues too. Sorry for the mistakes.