Re: [CTPP] NAICS to generalized employment types TOE

David: I haven't found the need to do what you're asking for, but there are SIC-to-NAICS and NAICS-to-SIC equivalency files on the Census Bureau's web site, at: http://www.census.gov/epcd/www/naicstab.htm General info on NAICS is available at: http://www.census.gov/epcd/www/naics.html In terms of SAS, I would download one of the CSV equivalency files on the Bureau's web site, then edit that CSV file in EXCEl, then import that CSV file into SAS: proc import data='nameofBureausfile.csv' outfile=temp1 replace; proc sort data=temp1; by naicscode; proc sort data=mydatafile; by naicscode; data temp2; merge temp1 mydatafile; by naicscode; proc summary data=temp2; class generaleconomycode; etc..... As with SIC, the first digits of the NAICS codes are generalized industry codes, so it may be a better idea to download the fixed format ASCII NAICS equivalency to use in designing a process to squeeze your data files to general industry categories. Chuck P. Does anyone know where I can get a piece of SAS code that recodes the NAICS categories to general employment categories like wholesale, retail, mining, services, etc? David Kruse Alamo Area Council of Governments _______________________________________________ ctpp-news mailing list ctpp-news(a)chrispy.net http://www.chrispy.net/mailman/listinfo/ctpp-news