topic Re: proc report and titles in Graphics Programming

proc report and titles

Mgarret — Wed, 16 May 2012 20:05:15 GMT

Hi all--

I'm having some trouble writing titles into 3 proc report statements which all appear on one page. Any advice on to add the titles in would be greatly appreciated. Thanks!

title1 'Special Medical Review Total Score';

proc report

data=All_Spec_Med_Qs_TotalScore nowd headline headskip

style(column)={just=c font_size=11pt font_face= 'Arial Narrow'cellwidth=2in}

style(header)={font_size=11 pt font_face= 'Arial Narrow' FONT_WEIGHT =BOLD background=cxcccccc};

column totalAwarded Total_Possible Final_score ;

define Final_score / display

style(column)={ cellwidth=1.8in};

run;

title2 Special Medical Review Quality Score;

proc report

data=Spec_Med_Quality_Qs_TotalScore nowd headline headskip

style(column)={just=c font_size=11pt font_face= 'Arial Narrow'cellwidth=2in}

style(header)={font_size=11 pt font_face= 'Arial Narrow' FONT_WEIGHT =BOLD background=cxcccccc};

column totalAwarded Total_Possible Final_score;

define Final_score / display

style(column)={ cellwidth=1.8in};

run;

title3 Special Medical Review Compliance Score ;

proc report

data=Spec_Med_Comp_Qs_TotalScore nowd headline headskip

style(column)={just=c font_size=11pt font_face= 'Arial Narrow'cellwidth=2in}

style(header)={font_size=11 pt font_face= 'Arial Narrow' FONT_WEIGHT =BOLD background=cxcccccc};

column totalAwarded Total_Possible Final_score;

define Final_score / display

style(column)={ cellwidth=1.8in};

run

Re: proc report and titles

ballardw — Wed, 16 May 2012 20:51:04 GMT

You don't say what your problem actually is but I'm going to guess that you get two lines of title for the second report and only want one and are getting three lines for tha last one.

Title is sort of a space holder with up to 9 lines. And all currently defined lines will show. I suspect that you want to use TITLE1 for each of your PROC REPORT calls to show one main line of title.

For an alternative appearance try this:

Title1 "Special Medical Review";

Title2 "Total Score";

before the second proc report

Title2 "Quality Score";

and before the third

Title2 "Compliance Score";

Re: proc report and titles

Abud — Wed, 16 May 2012 21:37:39 GMT

Hi,

If you are using ODS PDF, you can do something like this:

ods pdf text= "Special Medical Review Total Score"; (for each one);

Re: proc report and titles

Cynthia_sas — Wed, 16 May 2012 23:40:52 GMT

Hi:

I believe this question probably should have been posted in the ODS and Reporting forum, not the ODS and Graphics forum. Unless your code has some SAS/GRAPH or ODS GRAPHICS.

You did not say what your destination of interest was -- RTF, PDF or HTML. Titles are GLOBAL in nature. You can have up to 10 titles.. What ODS statements are you using for your report? In the LISTING destination, these 3 reports would not print on 1 page. So I figure you are using either PDF, RTF or HTML.

You have received some good information about SAS title statements in general and for dealing with ODS PDF in particular. I'd suggest you investigate TITLE statements in a bit more depth and possibly post ALL of your code, including ODS statements, so we can understand the whole picture. TITLE statements can behave differently in different destinations and their behavior is also dependent on the other options you are using (such as BODYTITLE or STARTPAGE or ...)

cynthia

Re: proc report and titles

shivas — Thu, 17 May 2012 04:03:36 GMT

Hi,

If I guess correctly,you are getting the all three titles in all the reports which you want to restrict.Try this..

title 'test1';

proc print data=sashelp.class;run;

title '';

title 'test2';

proc print data=sashelp.class;run;

title '';

title 'test3';

proc print data=sashelp.class;run;

title '';

Thanks,

Shiva

Re: proc report and titles

Eva — Wed, 30 May 2012 11:59:22 GMT

Hi Mgarret,

if you want to put all report tables on one page then don't use title. Use ods pdf text=""; instead.

ods pdf text="your first title";

proc report....;

run;

ods pdf text="your second title";

proc report...;

run;

etc.

Best wishes

Eva