topic Displaying Macro variable in Title from Loop in SAS Programming

Displaying Macro variable in Title from Loop

Jack_Sabbath — Fri, 26 Apr 2019 16:59:48 GMT

Hi,

I trying to include the label from a do loop in a title, though the macro is not displayed in the title. Does anyone have any suggestions as to how to rectify this issue. This is an example of my code:

%macro histogram_plot(sample_data=,vars=, year_l=,year_u=);

%do y = &year_l. %to &year_u.;

proc univariate data=&sample_data. noprint;

title 'Amount Funded &y';

histogram &vars. / normal(mu=est sigma=est color=red w=2.5);

run;

title;

%end;

%mend;

Thank you,

Re: Displaying Macro variable in Title from Loop

ErikLund_Jensen — Fri, 26 Apr 2019 17:23:58 GMT

Hi @Jack_Sabbath

Just an idea - try to change single quotes around title to double quotes, because the macro variable won't resolve within single quotes.

Re: Displaying Macro variable in Title from Loop

Tom — Fri, 26 Apr 2019 17:25:11 GMT

The macro processor ignores values inside of quoted strings using single quote characters on the outside. Just switch to using double quote character to enclose your string instead.

title "Amount Funded &y";

I think there are other issues with the code you posted, but that should fix the TITLE issue.

Re: Displaying Macro variable in Title from Loop

PaigeMiller — Fri, 26 Apr 2019 17:32:39 GMT

Forget macros and loops in this case.

proc univariate data=have;
    by year;
    title "Amount Funded #byval1";
    /* Your variable names go on the next line, I used x1 x2 x4 because I don't know your variable names */
    histogram x1 x2 x4/ normal(mu=est sigma=est color=red w=2.5);
run;