Date:         Tue, 19 Jun 2007 07:53:04 -0700
Reply-To:     kevin20142000@YAHOO.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         kevin20142000@YAHOO.COM
Organization: http://groups.google.com
Subject:      proc report
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

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,