Date: Wed, 17 Aug 2011 21:30:27 -0400
Reply-To: Student Statistics <student.statistics@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Student Statistics <student.statistics@GMAIL.COM>
Subject: Summarizing Filtered data By Hashing
Hello,
I am trying to accomplish the following task using Hash objects:
Proc sql;create table abc as select
Cat1,
Cat2,
Cat3,
Sum(X1) As X1,
Sum(X2) As X2 from
main where Cat1 in("alpha","Beta") and Cat2 in ("olive","crunch")
group by Cat1, Cat2, Cat3;quit;
I have some ideas on merging and summarizing separately any tips on how I can
combine these both tasks into one data step?
Many Thanks,
SS.
|