topic Re: proc report- how break pages with two proc reports in SAS Programming

proc report- how break pages with two proc reports

HitmonTran — Sat, 16 Jan 2021 18:51:49 GMT

Hi,

I need to create one rtf output using proc report. There are two proc reports (part 1 and part 2) and I need to page break the two parts. Please help, thank you.

 ods listing close;
ods rtf file = "test .rtf" ; 

title1='part 1';
proc report data = part1;
	  columns ordx1 aebodsys total1  ;
	  define ordx1     / descending order     order=internal noprint;
	  define aebodsys  / order order=internal noprint;
	  define total1  / descending order  order=internal noprint;
run;

title1='part 2';
proc report data = part2  ;
	  columns ordx1 aebodsys total1  ;
	  define ordx1     / descending order     order=internal noprint;
	  define aebodsys  / order order=internal noprint;
	  define total1  / descending order  order=internal noprint;
run;


ods rtf close;
ods listing;

Re: proc report- how break pages with two proc reports

ballardw — Sun, 17 Jan 2021 04:15:43 GMT

You need to clearly define what you mean by "page break the two parts". As in show an example of what the result looks like. You can make that manually with example columns and dummy data.

There are about a half-dozen ways I might interpret that phrase and almost certainly most if not all would not be what you want.

If at all practical it is a good idea to include data. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box opened using the </> icon or attached as text to show exactly what you have and that we can test code against.

Re: proc report- how break pages with two proc reports

blueskyxyz — Sun, 17 Jan 2021 05:58:57 GMT

ods listing close;ods rtf file = "C:\Users\My\Documents\test.rtf" ; 
title1='part 1';
proc report data = sashelp.class;
	  where sex='M';
	  columns name sex height  ;	  
run;

/*start in a new page;*/
ods startpage=yes;
title2='part 2';
proc report data = sashelp.class;
	  where sex='F';
	  columns name sex height  ;	  
run;
ods rtf close;ods listing;

Re: proc report- how break pages with two proc reports

Cynthia_sas — Sun, 17 Jan 2021 16:48:53 GMT

Hi:
By default, every procedure should start a newpage. I am confused though because your first PROC REPORT has all the variables listed as NOPRINT and it appears that your second PROC REPORT uses NOPRINT for all variables too. I would be very curious about what your intention is with the code you've posted. Why are you using NOPRINT for EVERY variable? What output are you getting?
Cynthia.