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 --------------------------------------