topic Re: proc report into one single page in SAS Procedures

proc report into one single page

SAS_user — Mon, 25 Jan 2010 10:59:17 GMT

Hello,

I want to produce a raport.
Here's is code:

*****************************;
proc sort
data = sashelp.class
out = AAA;
by sex;
run;

proc report
data = AAA nowindows;
by sex;
columns sex age name height weight;
define sex/order noprint;
define age/group;
quit;
*****************************;

The problem is that i want one raport table, but i get two separated tables(pages). I want to get one table/page.
I'm using sas 9.1, so BYPAGENO option is not valid.

Re: proc report into one single page

deleted_user — Mon, 25 Jan 2010 12:18:54 GMT

Doesn't removing the by option work.

Re: proc report into one single page

SAS_user — Mon, 25 Jan 2010 12:51:07 GMT

Yes it works. But u don't get the point.
I want the line that indicates the sex before any of data is outputted.
I have already solved the problem, by computing temporary variable, and adding a line.

If it would be helpful for anybody here is code.

proc report
data = sashelp.class nowindows;
columns sex age name height weight;
define sex/order noprint;
define name/order;
define age/group;
define height/order;
define weight/order;
compute before sex;
text = "Sex = " ||sex;
line text $40.;
endcomp;
quit;

Re: proc report into one single page

sbb — Mon, 25 Jan 2010 16:06:16 GMT

Yes - you have addressed the pagination issue correctly, per the SAS DOC (link below). Your approach is a correct one.

Scott Barry
SBBWorks, Inc.

http://support.sas.com/resources/papers/ProcReportBasics.pdf