Date:         Fri, 27 Sep 2002 15:51:43 -0600
Reply-To:     Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject:      Re: Proc report split my column
Comments: To: diskin.dennis@KENDLE.COM
Content-Type: text/plain; charset=us-ascii

There is an option to in PROC REPORT which attemots to keep columns on
the same page.  The ID option on the DEFINE statement:

"specifies that the item that you are defining is an ID variable. An ID
variable and all columns to its left appear at the left of every page of
a report. ID ensures that you can identify each row of the report when
the report contains more columns than will fit on one page."

It's buggy in version 8 - it doesn't work correctly for some ODS output
destinations.

It also doesn't do exactly what the original poster wanted.  What's
desired, I think, is a way to keep a set of columns, not necessarily all
at the left side of the page, together.



--
JackHamilton@FirstHealth.com
Manager, Technical Development
METRICS Department, First Health
West Sacramento, California USA


>>> <diskin.dennis@KENDLE.COM> 09/27/2002 7:29 AM >>>
Hi Xavier,

Unless it's new, Proc Report does not have an option to keep columns on
the
same page, even when they in an ACROSS.
My recommendation would be to play with the LINESIZE option until it
looks
good. You could also reduce the  width for the percents to 6.

HTH,
Dennis Diskin




From:  Xavier Autret <xav_x@NOOS.FR>@LISTSERV.UGA.EDU> on 09/27/2002
09:58
       AM

Please respond to Xavier Autret <xav_x@NOOS.FR>

Sent by:    "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>


To:    SAS-L@LISTSERV.UGA.EDU
cc:

Subject:    Proc report split my column


Hello list,

I ve got a little problem with proc report.

ISSUE : The columns COUNT and PERCENT are separated for the last
column.
I.e. the count is on a page and the percent on the following.

Any idea?

Xavier

Here s the code:
options ls=149;

data zz1;
input _col $16. @21 lab1c $20. @46 count @56 percent;
cards;
Subjects with AE    PBO!(N=12)               12        -1
Subjects with AE    UH45!(N=12)              12        -1
Subjects with AE    UH90!(N=12)              12        -1
Subjects with AE    UH180!(N=12)             12        -1
Subjects with AE    1.999 pooled!(N=12)      12        -1
Subjects with AE    V90!(N=12)               12        -1
Subjects with AE    V180!(N=12)              12        -1
Subjects with AE    ALL!(N=12)               12        -1
AAAAA               PBO!(N=12)               12        -1
AAAAA               UH45!(N=12)              12        -1
AAAAA               UH90!(N=12)              12        -1
AAAAA               UH180!(N=12)             12        -1
AAAAA               1.999 pooled!(N=12)      12        -1
AAAAA               V90!(N=12)               12        -1
AAAAA               V180!(N=12)              12        -1
AAAAA               ALL!(N=12)               12        -1
aaaaa               PBO!(N=12)               12        -1
aaaaa               UH45!(N=12)              12        -1
aaaaa               UH90!(N=12)              12        -1
aaaaa               UH180!(N=12)             12        -1
aaaaa               1.999 pooled!(N=12)      12        -1
aaaaa               V90!(N=12)               12        -1
aaaaa               V180!(N=12)              12        -1
aaaaa               ALL!(N=12)               12        -1
;
run;

proc report data=zz1 nowindows headline split='!' missing SPACING=1;
   column  _col lab1c , (count percent);
   DEFINE  _col     / id      width= 34 group flow left;
   DEFINE  lab1c    / across order=data 'Number (%) of subjects' '--'
;
   DEFINE  count    / sum     width=5 ' ' format=best5. ;
   DEFINE  percent  / sum     width=8 ' ' format=percent8.1;
run;