topic Re: Multiple titles on the same page in ODS and Base Reporting

Multiple titles on the same page

problems99 — Mon, 15 Jun 2015 08:27:33 GMT

Hello,

I would like to display more than one report on the same sheet. But only the title of the first proc print is shown on the sheet and never the others. How can I solve that?

For example:

Proc print data=normal noobs;
Title2 'HH Short Term  control  CC ST-MT';
where lcccthh = 'NO' and (NB13 ne . and NB14 ne .);
var d_report c_bic NB13 NB14 lcccthh ;
run;

Proc print data=normal noobs;
Title2 'HH Short Term  control  CC ST-LT';
where lccct2hh = 'NO' and (NB13 ne . and NB15 ne .);
var d_report c_bic NB13 NB15 lccct2hh ;
run;

Thanks.

Re: Multiple titles on the same page

Ksharp — Mon, 15 Jun 2015 12:33:26 GMT

Use ODS TEXT= instead .

Re: Multiple titles on the same page

problems99 — Mon, 15 Jun 2015 12:40:53 GMT

The problem is that the text is always displayed. By using title in a proc print, if there are no data, the title is not displayed.

Re: Multiple titles on the same page

Kurt_Bremser — Mon, 15 Jun 2015 12:59:40 GMT

Interesting. Could you please supply your complete code (as I could not replicate that behaviour).

Re: Multiple titles on the same page

problems99 — Mon, 15 Jun 2015 13:21:34 GMT

This more simple code below has the same idea.

DATA Salary; 
Input Id Salary Name $;
datalines; 
101 55000 Jack
102 75000 Edward 
103 85000 Arthur
;
RUN;
ods rtf;
ods rtf startpage=now;
Proc print data=Salary noobs;
Title 'Salary under 60000';
where Salary < 60000;
var Salary Name;
run;
ods rtf startpage=no;
Proc print data=Salary noobs;
Title 'Salary from 60000 to 70000';
where (Salary < 70000 and Salary > 60000);
var Salary Name;
run;
Proc print data=Salary noobs;
Title 'Salary from 70000 to 80000';
where (Salary < 80000 and Salary > 70000);
var Salary Name;
run;
Proc print data=Salary noobs;
Title 'Salary over 80000';
where Salary > 80000;
var Salary Name;
run;
ods rtf close;

Re: Multiple titles on the same page

Kurt_Bremser — Mon, 15 Jun 2015 13:40:28 GMT

Look at the BODYTITLE option for ODS RTF.

Re: Multiple titles on the same page

problems99 — Mon, 15 Jun 2015 13:53:05 GMT

Thanks.

Have a nice day!