Date:         Fri, 7 Aug 1998 15:30:52 -0700
Reply-To:     "Berryhill, Timothy" <TWB2@PGE.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Berryhill, Timothy" <TWB2@PGE.COM>
Subject:      Re: Summarize by 2 digit SIC
Comments: To: "Boylan, Dave" <dboylan@UTILICORP.COM>
Content-Type: text/plain

Dave, If you did not work for the competition I would suggest you store
SIC's in character variables.  That makes it easy to either truncate or
assign a short format and PROC FREQ.
 
Tim Berryhill - Contract Programmer and General Wizard
TWB2@PGE.COM or http://www.aartwolf.com/twb.html
Frequently at Pacific Gas & Electric Co., San Francisco
The correlation coefficient between their views and
my postings is slightly less than 0
> ----------
> From:         Boylan, Dave[SMTP:dboylan@UTILICORP.COM]
> Reply To:     Boylan, Dave
> Sent:         Friday, August 07, 1998 2:02 PM
> To:   SAS-L@UGA.CC.UGA.EDU
> Subject:      Summarize by 2 digit SIC
>
> 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
> --------------------------------------
>