BookmarkSubscribeRSS Feed
SAS_user
Calcite | Level 5
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.
3 REPLIES 3
deleted_user
Not applicable
Doesn't removing the by option work.
SAS_user
Calcite | Level 5
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;
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 785 views
  • 0 likes
  • 3 in conversation