Date: Fri, 7 Aug 1998 16:02:25 -0500
Reply-To: "Boylan, Dave" <dboylan@UTILICORP.COM>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: "Boylan, Dave" <dboylan@UTILICORP.COM>
Subject: Summarize by 2 digit SIC
Content-Type: text/plain
I have a data set with a with a SIC field. The SIC codes are of the 4 digit
variety. I would like to summarize my data set by a 2 digit level sic code
(Truncate the last 2 digits of the 4 digit SIC). I guess the brute force
method would be to create a new variable "SIC2" as INT(SIC/100) and then
summarize by SIC2. Is there a simpler (and faster) way to do this without
creating an additional variable (e.g., format the SIC so it looks like it is
2 digits)?
Thanks in advance.
--------------------------------------
David Boylan
Corporate Forecasting
UtiliCorp United, Inc.
816.467.3062
--------------------------------------
| 
