Date:         Wed, 6 Aug 2008 11:44:16 -0400
Reply-To:     Samson Gebreab <samygeb@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Samson Gebreab <samygeb@GMAIL.COM>
Subject:      Arrays

I am wrestlin with this problem, I am sure some body could help me. I am
posting the question again. I have a 24 hours blood pressure data with
measurments taken every 20 minutes. The data looks some thing like this: I
have more than 1000 subjects.

ID   SystBp   Time
01        140        8:30 (starting time)
01        135        8:50
01        136        9:10
.   .  .
.   .  .
.   .  .
01   135      8:30 (ending time- the next day)

02        137        9:30 (starting time)
02        125        9:50
.   .  .
.   .  .
.   .  .
02   135      9:30 (ending time- the next day)

03        122        14:50 (start time)
03        130        15:10
03        134        15:30
.   .  .
.   .  .
.   .  .
03   137      15:50 (ending time- the next day)

I want to derive variables 24 hour mean systbp, mean systbp every 3 hours
and mean daytime systbp and nighttime bp in such away that the newly
derived dataset is one observation pre subject.

The desired output

Id  24hmean  systbp3 systbp6 systbp9... systbp24 daytimebp nighttimebp
01  127.5    130.5
  I tried to use arrays to solve the problem but I have no lucks so far