topic Re: How to reference a macro variable in ODS RTF TEXT= ? in ODS and Base Reporting

How to reference a macro variable in ODS RTF TEXT= ?

AshP — Thu, 21 Jun 2012 20:17:46 GMT

I have a program that I need to run multiple times to produce reports for multiple school districts (using ODS PDF). I use the following to title my pages.

Before running my program,

%LET DISTNAME = Example;

Within my program,

TITLE1 "&DISTNAME.".;

This works fine for me. I would also like to add some descriptive text using ODS PDF TEXT= and mention the district name in the text. How do I do that?

ODS PDF TEXT = '^S={just=center font=("Times New Roman",14PT,Bold)} Report produced for &DISTNAME. ISD';

is not working.

Re: How to reference a macro variable in ODS RTF TEXT= ?

Alpay — Thu, 21 Jun 2012 20:46:35 GMT

Can you try enclosing in double quotes instead of single?

ODS PDF TEXT = "^S={just=center font=("Times New Roman",14PT,Bold)} Report produced for &DISTNAME. ISD";

Re: How to reference a macro variable in ODS RTF TEXT= ?

AshP — Thu, 21 Jun 2012 21:40:45 GMT

No, that didn't work either ...

Re: How to reference a macro variable in ODS RTF TEXT= ?

Alpay — Fri, 22 Jun 2012 04:30:29 GMT

I see why. Font name needs to be enclosed in single quotes when the overall text enclosed in double quotes.

Please see the example below.

%LET DISTNAME = Example;

ods escapechar='^';

TITLE1 "&DISTNAME.";

ods pdf file='d:\temp\test.pdf';

proc print data=sashelp.class;

run;

ODS PDF TEXT = "^S={just=center font=('Times New Roman',14PT,Bold)} Report produced for &DISTNAME. ISD";

%* ODS PDF TEXT = "^S={just=center font=(""Times New Roman"",14PT,Bold)} Report produced for &DISTNAME. ISD"; //* This would work, too */

ods pdf close;

Re: How to reference a macro variable in ODS RTF TEXT= ?

AshP — Fri, 22 Jun 2012 14:24:17 GMT

Alpay, that worked, thank you!