Date:         Fri, 9 Jan 2009 04:16:25 -0500
Reply-To:     "SUBSCRIBE SAS-L Joe H. Smith" <peesari.mahesh@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "SUBSCRIBE SAS-L Joe H. Smith" <peesari.mahesh@GMAIL.COM>
Subject:      Proc sql ...

hi all,

 i have dataset like this with 20000 observations.

  A    B    C
 asd  5    Aug2004
 asd  6    Aug2004
 jgh  5    sep2004
 jgh  8    oct2004
 lod  9    dec2004

 Now i am writing proc sql code to sum B accordingly with A & C,

 proc sql;
 select distinct(A) as demand,sum(B) as total,C from dataset
  group by A,C;
 quit;

when i run the above code some corresponidng values of A are not geeting
clubbed as SUM,can you please correct me where i am going wrong.