Date:         Wed, 31 Mar 2010 08:55:32 -0700
Reply-To:     Al <ali6058@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Al <ali6058@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Data structure
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

All:

I Have the data in the following format ..i need to create a variable
avg .. .. The vital are systolic and diastolic ..more than one reading
for systolic and diastolic were taken  at each visit .. i need to find
the average of all the readings taken at each visit per each vital
sign

Any suggestions

Thanks
Al

patno lbread  test vis res  avg
11    sys1    sys      1  120  125
11    sys2    sys      1  130  125
11    sys1    sys      2   150  123.3
11    sys2    sys      2  100  123.3
11    sys3    sys      2  120  123.3
22    Dia1    Dia      1  100  100
22    Dia1    Dia      1  100  100