Date:         Thu, 16 Jun 2005 15:25:27 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: SAS help on data analysis
Comments: To: del101679@YAHOO.COM
In-Reply-To:  <200506161501.j5GF1OM2016476@listserv.cc.uga.edu>
Content-Type: text/plain; format=flowed

Mike,

data one ;
do i = 1 to 100 ;
output ;
end ;
run ;

data two ;
set one ;
if Mark < _n_ then mark + 5 ;
run ;

proc sql ;
select I , avg(i) as avg
  from two
   group by mark
    order by i ;
quit ;



Toby Dunn




From: Mike Smith <del101679@YAHOO.COM>
Reply-To: Mike Smith <del101679@YAHOO.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: SAS help on data analysis
Date: Thu, 16 Jun 2005 11:01:06 -0400

Hi. I wanted to compute the average of every five numbers in my data set in
SAS. How do I do it? Thanks.