Date:         Sat, 8 Aug 1998 10:28:21 +0100
Reply-To:     Peter Crawford <Peter@CRAWFORDSOFTWARE.DEMON.CO.UK>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Peter Crawford <Peter@CRAWFORDSOFTWARE.DEMON.CO.UK>
Subject:      Re: Summarize by 2 digit SIC
In-Reply-To:  <902529723.1012297.0@vm121.akh-wien.ac.at>

In article <902529723.1012297.0@vm121.akh-wien.ac.at>, Berryhill,
Timothy <TWB2@PGE.COM> writes
>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
>> --------------------------------------
>>
 
Isn't this a case for the picure format with a mult=.01 and which
*doesn't* use the (ROUND) option, then summarize your stats by the
formatted value ?
 
Do you want sample code ?
--
Peter Crawford