Help using Base SAS procedures

proc report into one single page

Reply
Contributor
Posts: 48

proc report into one single page

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.
N/A
Posts: 0

Re: proc report into one single page

Doesn't removing the by option work.
Contributor
Posts: 48

Re: proc report into one single page

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;
Super Contributor
Super Contributor
Posts: 3,174

Re: proc report into one single page

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
Ask a Question
Discussion stats
  • 3 replies
  • 126 views
  • 0 likes
  • 3 in conversation