Embed a parameter into Title statement

[Danglytics]

Hi,

I was wondering if its possible to embed a parameter into the title statement.

I have the parameter

%let cur_monthend = 20110731 ;

and I want to have a title statement before my proc means something similar to ,

Title ' Summary Report &cur_monthend' ;

but of course the above doesnt work, the &cur_monthend comes out as a text, I was wondering if it was possible so that it uses the parameter to output the value so the title would look something like

"Summary Report 20110731"

Thanks for your help.

[Reeza · Accepted solution]

Use double quotation marks, not single, macro variables will not resolve inside single quotation marks.

[MikeZdeb]

Hi ... use double-quotes on the title ...

* hard coded;

%let cur_monthend = 20110731 ;

title "Summary Report &cur_monthend" ;

proc print data=sashelp.class (obs=1);

run;

Summary Report 20110731

Name      Sex    Age    Height    Weight

Alfred     M      14      69       112.5

You could make the code 'dynamic' ...

* changes with the day job is run;

data _null_;

call symputx('cur_monthend', put(intnx('month',today(), 0,'e'),yymmddn.));

run;

title "Summary Report &cur_monthend";

proc print data=sashelp.class (obs=1);

run;

Summary Report 20110831

Name      Sex    Age    Height    Weight

Alfred     M      14      69       112.5

from ...

http://www.datimpact.be/tips/finding-the-last-day-of-the-month-in-sas-using-intnx.php