topic Re: ODS HTML -- Is it possible to control how much output appears on a page? in ODS and Base Reporting

ODS HTML -- Is it possible to control how much output appears on a page?

PaigeMiller — Fri, 18 Aug 2017 20:01:52 GMT

I am using PROC REPORT to generate tables, and sending the output to an HTML file via ODS HTML. Everything works great, I get the exact tables that I want, except I want two tables on a page, and there are more than 2 BY groups. So, I want the first two BY groups on page 1, the next two BY groups on page 2, and so on and so forth. For completeness, here is my code (although I think the problem isn't this code, it's somewhere in ODS that I don't know). How can I do this?

ods html file="report.html" path="&myfolder" style=htmlblue;
proc report nowindows data=stats1;
	by fico;
	column ias ltv,ever60pct ltv,bankinterestrate ltv,nloans;
	define ias/group 'IAS' order=data;
	define ltv/across "LTV" order=internal;
	define ever60pct/analysis sum format=nlpctn12.2 'Ever 60 %';
	define nloans/analysis sum format=comma6.0 'N Loans';
	define bankinterestrate/analysis sum format=6.2 'Interest Rate';
run;
ods html close;

Re: ODS HTML -- Is it possible to control how much output appears on a page?

Reeza — Fri, 18 Aug 2017 22:06:43 GMT

HTML doesn't have a concept of pages - that's likely the biggest issue.

Re: ODS HTML -- Is it possible to control how much output appears on a page?

ballardw — Fri, 18 Aug 2017 22:14:38 GMT

Can you provide some example data. I'm not going to try to fudge something up with that many variables.

Re: ODS HTML -- Is it possible to control how much output appears on a page?

Ksharp — Sat, 19 Aug 2017 11:53:53 GMT

How about this one ?




ods html options(page_break='no');
proc report data=sashelp.class(where=(sex='F')) nowd;
run;
ods text='
';

proc report data=sashelp.class(where=(sex='M')) nowd;
run;
ods text='
';

proc report data=sashelp.class nowd;
run;
ods html close;

Re: ODS HTML -- Is it possible to control how much output appears on a page?

Ksharp — Sat, 19 Aug 2017 12:12:03 GMT

ods html options(page_break='no'); proc report data=sashelp.class(where=(sex='F')) nowd; run; ods text='
'; proc report data=sashelp.class(where=(sex='M')) nowd; run; ods text='
'; proc report data=sashelp.class nowd; run; ods html close;

Re: ODS HTML -- Is it possible to control how much output appears on a page?

Ksharp — Sat, 19 Aug 2017 12:16:03 GMT

The forum keep eating my code. ods text=' < b r > < / b r > ' ;

Re: ODS HTML -- Is it possible to control how much output appears on a page?

PaigeMiller — Sat, 19 Aug 2017 13:15:31 GMT

Thanks, @Ksharp. I will give this a try on Monday.

Re: ODS HTML -- Is it possible to control how much output appears on a page?

PaigeMiller — Sat, 19 Aug 2017 15:20:01 GMT

This raises the question, if ODS HTML is not a good choice here (as pointed out by @Reeza), what would be a better ODS destination where I can force a new page after two by groups, and another new page after another two by groups, and so on?

Re: ODS HTML -- Is it possible to control how much output appears on a page?

Reeza — Sat, 19 Aug 2017 16:41:31 GMT

PDF or RTF and use STARTPAGE option to control page breaks?

Re: ODS HTML -- Is it possible to control how much output appears on a page?

PaigeMiller — Sat, 19 Aug 2017 19:51:52 GMT

@Reeza wrote:

PDF or RTF and use STARTPAGE option to control page breaks?

I will certainly give this a try on Monday when I am back in the office. It appears that I am going to have to write some sort of macro loop to output two by-groups at a time to a single page (which, by the way, is not the problem, I can write macro loops in my sleep). Do you agree? Or am I missing something here?

Re: ODS HTML -- Is it possible to control how much output appears on a page?

ballardw — Mon, 21 Aug 2017 15:53:37 GMT

@PaigeMiller wrote:

@Reeza wrote:

PDF or RTF and use STARTPAGE option to control page breaks?

I will certainly give this a try on Monday when I am back in the office. It appears that I am going to have to write some sort of macro loop to output two by-groups at a time to a single page (which, by the way, is not the problem, I can write macro loops in my sleep). Do you agree? Or am I missing something here?

Proc Report does have a role for a variable to do "page" so if an additional variable to indicate the page as the first column and set to noprint might work.