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 ...
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,
select distinct(A) as demand,sum(B) as total,C from dataset
group by A,C;
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.