Date:         Wed, 10 Feb 2010 07:21:57 -0800
Reply-To:     atulrill <atulrill@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         atulrill <atulrill@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Help Regarding Coding
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi,
        I have a query related to SAS enterprise guide ,i need a sql
code to find out average as mentioned in below table. there are 2
variables Time Flag demand, so i need average of demand when
timeflag
=0-9 then when time flag = 10-18 then average of demand , when time
flag = 19-22 then average of demand and  when time flag = 22-24 then
average of demand as shown in table below.so i need a code using CASE
in filter or code in Sql or data set.I need it urgently so please
help

Sample Data set

TIme Flag  Demand  Average
0              18.0       13.1
1              20.0
2             11.0
3             15.0
4             16.0
5             17.0
6             5.0
7             4.0
8             8.0
9             17.0       24.9
10           16.0
11          19.0
12          20.0
13          21.0
14          22.0
15         30.0
16         31.0
17         32.0
18         33.0      20.5
19          34.0
20         35.0
21         36.0
22         37.0       23.0
23         38.0
24        3 9.0


Thanks
Atul