| 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> |
|
| From: | "Ravikumar. J" <ravi_pune@YAHOO.COM> |
| Subject: | Re: Proc Report |
|
| 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/
|