Date:         Tue, 19 Jun 2007 08:23:51 -0700
Reply-To:     "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Subject:      Re: proc report
Comments: To: kevin20142000@YAHOO.COM
In-Reply-To:  A<1182264784.407885.302160@c77g2000hse.googlegroups.com>
Content-Type: text/plain; charset="US-ASCII"

Hi Kevin,

Not intentionally trying to take the easy road here,
but thought it was at least worth a quick check.

If, the line between gender and age is not optically
a requirement, then could adding age to the BY group
be a possible quick solution?

e.g.

proc report nowd data=class headline;
  by gender age;
  title '#byval1';
  columns ("__" name (height weight));
  *define age   / order ;
  define name / display;
  *break after age/ skip page;
run;




Hope this is helpful.


Mark Terjeson
Senior Programmer Analyst, IM&R
Russell Investments


Russell Investments
Global Leaders in Multi-Manager Investing






-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
kevin20142000@YAHOO.COM
Sent: Tuesday, June 19, 2007 7:53 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: proc report

I was using the following program to generate a report.

*******
proc sort data=sashelp.class out=class;
 by sex age;
run;
proc format;
  value $test 'M'='Male' 'F'='Female';
data class;
 set class;
 gender=put(sex,$test.);
run;
options nobyline nodate nonumber ls=130; proc report nowd data=class
headline;
  by gender;
  title '#byval1
';
  columns ("__" name age ("age" "__" height weight));
  define age   / order ;
  define name / display;
break after age/ skip page;
run;

********
I would like to move age variable in top of "height weight" and also
break by age group(each age group per page). Please see attached sas
output file for details( I would like to generate target output in the
attached file).


*****************
Target output:

Female
_________________________
                   age=11
               _________________

Name     Height    Weight
__________________________
Joyce    51.3      50.5

(Note: This should show on page1. )


Female
__________________________
                   age=12
                 _________________

Name     Height    Weight
__________________________
Jane          59.8       84.5
Louise      56.3         77

(Note: This should show on page2. )


*********************

Thanks,