Date:         Thu, 13 May 2004 23:30:04 +0100
Reply-To:     "Ravikumar. J" <ravi_pune@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Comments:     To: Crystal Vierhout <vierhout@UNITY.NCSU.EDU>
From:         "Ravikumar. J" <ravi_pune@YAHOO.COM>
Subject:      Re: Proc Report
Comments: To: SAS-L@LISTSERV.VT.EDU
In-Reply-To:  <000a01c43936$584a7b70$99250198@CNV>
Content-Type: text/plain; charset=iso-8859-1

Hi Crystal,

Use MEAN !  Simplest example below ..



DATA TEST;
INPUT ID SALARY;
INFILE DATALINES;
DATALINES;
12 1234
23 2345
34 4567
45 5678
;
RUN;

PROC REPORT DATA=TEST;
COLUMN ID SALARY;
DEFINE  ID / GROUP;
DEFINE  SALARY / MEAN ;
RBREAK AFTER / SUMMARIZE DOL;
RUN;

Cheers
Ravi




 --- Crystal Vierhout <vierhout@UNITY.NCSU.EDU> wrote: > Hello,
>
> How do I get a average of the column at the bottom of a column
> instead of the sum of the column  with proc report?
>
> Crystal

________________________________________________________________________
Yahoo! India Matrimony: Find your partner online. http://yahoo.shaadi.com/india-matrimony/