convert Census Industry Codes (CIC) to SIC code

[hussein bataineh]

Hi

please i need to convert Census Industry Codes (CIC) to SIC code

anyone can suggest a way to do this please?

Thanks

[George Ford]

how many digits?

[George Ford]

https://www.census.gov/programs-surveys/aces/information/iccl.html

clear
input str4 cic str217 description str17 naics1 str6(naic2 naics3) str4 naic3 str3(naics4 naic4)
"1110" "Crop and Animal Production" "111" "112" "" "" "" ""
"1130" "Forestry, Logging, Fishing, Hunting, Trapping and Agricultural Support Activities" "113" "114" "115" "" "" ""
"2110" "Oil and Gas Extraction" "2111" "" "" "" "" ""
"2121" "Coal Mining" "2121" "" "" "" "" ""
"2122" "Metal Ore Mining" "2122" "" "" "" "" ""
"2123" "Nonmetallic Mineral Mining and Quarrying" "2123" "" "" "" "" ""
"2130" "Support Activities for Oil and Gas Operations" "213111" "213112" "" "" "" ""
"2131" "Support Activities for Solid Mineral Operations" "213113" "213114" "213115" "" "" ""
"2211" "Electric Power Generation, Transmission and Distribution" "2211" "" "" "" "" ""
"2212" "Natural Gas Distribution" "2212" "" "" "" "" ""
"2213" "Water, Sewage and Other Systems" "2213" "" "" "" "" ""
"2360" "Construction of Buildings" "236" "" "" "" "" ""
"2370" "Heavy and Civil Engineering Construction" "237" "" "" "" "" ""
"2380" "Specialty Trade Contractors" "238" "" "" "" "" ""
"3110" "Food Manufacturing" "311" "" "" "" "" ""
"3121" "Beverage Manufacturing" "3121" "" "" "" "" ""
"3122" "Tobacco Manufacturing" "3122" "" "" "" "" ""
"3130" "Textile Mills and Textile Product Mills" "313" "314" "" "" "" ""
"3150" "Apparel Manufacturing" "315" "" "" "" "" ""
"3160" "Leather and Allied Product Manufacturing" "316" "" "" "" "" ""
"3210" "Wood Product Manufacturing" "321" "" "" "" "" ""
"3220" "Paper Manufacturing" "322" "" "" "" "" ""
"3230" "Printing and Related Support Activities" "323" "" "" "" "" ""
"3240" "Petroleum and Coal Products Manufacturing" "324" "" "" "" "" ""
"3251" "Basic Chemical, Resin, Synthetic Rubber and Fiber Manufactuing" "3251" "3252" "" "" "" ""
"3253" "Pesticide, Fertilizer and Other Agricultural Chemical Manufacturing" "3253" "" "" "" "" ""
"3254" "Pharmaceutical and Medicine Manufacturing" "3254" "" "" "" "" ""
"3259" "Paint, Adhesive, Soap and Other Chemical Manufacturing" "3255" "3256" "3259" "" "" ""
"3260" "Plastics and Rubber Products Manufacturing (except inflatable boats)" "326" "" "" "" "" ""
"3271" "Clay and Glass Products Manufacturing" "3271" "3272" "" "" "" ""
"3279" "Cement, Concrete, Lime, Gypsum and Other Nonmetallic Mineral Product Manufacturing" "3273" "3274" "3279" "" "" ""
"3311" "Iron and Steel Mills, Ferroalloy Manufacturing and Steel Product Manufacturing from Purchased Steel" "3311" "3312" "" "" "" ""
"3313" "Nonferrous Metals Production and Processing" "3313" "3314" "" "" "" ""
"3315" "Ferrous and Nonferrous Foundries" "3315" "" "" "" "" ""
"3320" "Fabricated Metal Product Manufacturing" "332" "" "" "" "" ""
"3331" "Agriculture, Construction and Mining Machinery Manufacturing" "3331" "" "" "" "" ""
"3332" "Industrial, Metalworking and General Purpose Machinery Manufacturing (Including Laboratory Apparatus)" "3332" "3335" "3339" "" "" ""
"3333" "Commercial, Service Industry, Temperature Control and Air-Flow Control Machinery Manufacturing" "3333" "3334" "" "" "" ""
"3336" "Engine, Turbine and Power Transmission Equipment Manufacturing" "3336" "" "" "" "" ""
"3341" "Computer and Peripheral Equipment Manufacturing" "3341" "" "" "" "" ""
"3342" "Communications, Audio and Video Equipment Manufacturing" "3342" "3343" "" "" "" ""
"3344" "Semiconductor and Other Electronic Component Manufacturing" "3344" "" "" "" "" ""
"3345" "Nav/Electromedical/Control Instruments Manufacturing, Radio/TV/Wireless Communications Equipment Manufacturing, Communications Signal Testing/Eval Equipment" "3345" "" "" "" "" ""
"3346" "Manufacturing and Reproducing Magnetic and Optical Media" "3346" "" "" "" "" ""
"3350" "Electrical Equipment, Appliance and Component Manufacturing" "335" "" "" "" "" ""
"3361" "Motor Vehicle, Body, Trailer and Parts Manufacturing" "3361" "3362" "3363" "" "" ""
"3364" "Aerospace Product and Parts Manufacturing" "3364" "" "" "" "" ""
"3369" "Other Transportation Equipment Manufacturing (Including inflatable boats)" "3365" "3366" "3369" "" "" ""
"3370" "Furniture and Related Product Manufacturing (Including Laboratory Furniture)" "337" "" "" "" "" ""
"3391" "Medical Equipment and Supplies Manufacturing" "3391" "" "" "" "" ""
"3399" "Other Miscellaneous Manufacturing" "3399" "" "" "" "" ""
"4230" "Merchant Wholesalers, Durable Goods" "423" "" "" "" "" ""
"4240" "Merchant Wholesalers, Nondurable Goods" "424" "" "" "" "" ""
"4250" "Wholesale Electronic Markets and Agents and Brokers" "425" "" "" "" "" ""
"4410" "Motor Vehicles and Parts Dealers" "441" "" "" "" "" ""
"4430" "Electronics and Appliance Stores" "443" "" "" "" "" ""
"4450" "Food and Beverage Stores" "445" "" "" "" "" ""
"4480" "Clothing and Clothing Accessories Stores" "448" "" "" "" "" ""
"4520" "General Merchandise Stores" "452" "" "" "" "" ""
"4540" "Nonstore Retailers" "454" "" "" "" "" ""
"4599" "Other Retail Trade Stores, including Gasoline Stations" "442" "444" "446" "447" "451" "453"
"4810" "Air Transportation" "481" "" "" "" "" ""
"4820" "Rail Transportation" "482" "" "" "" "" ""
"4830" "Water Transportation" "483" "" "" "" "" ""
"4840" "Truck Transportation" "484" "" "" "" "" ""
"4850" "Transit and Ground Passenger Transportation" "485" "" "" "" "" ""
"4861" "Pipeline Transportation of Crude Oil, Refined Petroleum and Miscellaneous Products, except Natural Gas" "4861" "4869" "" "" "" ""
"4862" "Pipeline Transportation of Natural Gas" "4862" "" "" "" "" ""
"4870" "Scenic and Sightseeing Transportation" "487" "" "" "" "" ""
"4880" "Support Activities for Transportation" "488" "" "" "" "" ""
"4920" "Couriers and Messengers" "492" "" "" "" "" ""
"4930" "Warehousing and Storage" "493" "" "" "" "" ""
"5111" "Newspaper, Periodical, Book and Directory Publishers (except Internet)" "5111" "" "" "" "" ""
"5112" "Software Publishers (except Internet)" "5112" "" "" "" "" ""
"5120" "Motion Picture and Sound Recording Industries (except Internet)" "512" "" "" "" "" ""
"5151" "Radio and Television Broadcasting (except Internet)" "5151" "" "" "" "" ""
"5152" "Cable and Other Subscription Programming (except Internet)" "5152" "" "" "" "" ""
"5171" "Wired Telecommunications Carriers, Cable and Other Program Distribution, Broadband Internet Service Providers (e.g., cable, DSL)" "5171" "" "" "" "" ""
"5172" "Wireless Telecommunications Carriers (except Satellite)" "5172" "" "" "" "" ""
"5179" "Telecommunications Resellers, Satellite and Other Telecommunications(Including Internet Service Providers providing services via client supplied telecommunication connection)" "5174" "5179" "" "" "" ""
"5182" "Data Processing, Hosting and Related Services" "5182" "" "" "" "" ""
"5190" "Other Information Services" "519" "" "" "" "" ""
"5210" "Monetary Authorities-Central Bank" "521" "" "" "" "" ""
"5221" "Depository Credit Intermediation" "5221" "" "" "" "" ""
"5222" "Nondepository Credit Intermediation" "5222" "" "" "" "" ""
"5223" "Activities Related to Credit Intermediation" "5223" "" "" "" "" ""
"5230" "Securities, Commodity Contracts and Other Financial Investments and Related Activities" "523" "" "" "" "" ""
"5241" "Insurance Carriers" "5241" "" "" "" "" ""
"5242" "Agencies, Brokerages and Other Insurance Related Activities" "5242" "" "" "" "" ""
"5251" "Funds, Trusts and Other Financial Vehicles (including Mortgage REITS)" "525" "" "" "" "" ""
"5310" "Real Estate (including Equity REITS)" "531" "" "" "" "" ""
"5321" "Automotive Equipment Rental and Leasing" "5321" "" "" "" "" ""
"5322" "Consumer Goods and General Rental Centers" "5322" "5323" "" "" "" ""
"5324" "Commercial and Industrial Machinery and Equipment Rental and Leasing" "5324" "" "" "" "" ""
"5330" "Lessors of Nonfinancial Intangible Assets" "533" "" "" "" "" ""
"5411" "Legal Services" "5411" "" "" "" "" ""
"5412" "Accounting, Tax Preparation, Bookkeeping and Payroll Services" "5412" "" "" "" "" ""
"5413" "Architectural, Engineering and Related Services" "5413" "" "" "" "" ""
"5414" "Specialized Design Services" "5414" "" "" "" "" ""
"5415" "Computer Systems Design and Related Service" "5415" "" "" "" "" ""
end
[/CODE]

[hussein bataineh]

Thanks professor.

please i need to to convert from from Census Industry Codes (CIC) to SIC code,

actualy i got to the website you provide but i did not understand something they provide three codes

Industry Code NAICS Code(S) Industry Code

im not sure what is the different between first column ( Industry Code ) and the last ( Industry Code )

[George Ford]

oops.

https://www2.census.gov/programs-surveys/cps/methodology/Industry%20Codes.pdf

can copy and paste into excel from the pdf and organize as you wish.

[hussein bataineh]

actually professor this file allow us to convert from Census Industry Codes (CIC) to NAICS code

in my dataset i have only SIC code so i need to convert Census Industry Codes to SIC code OR converted from NAICS code to Sic code also can be worked

Can you guide me on how we can do this please

[hussein bataineh]

please Professor George,

Could you guide me on how to find a list that helps map Census Industry Codes (CIC) to SIC codes?

I have tried my best but, unfortunately, I haven't been able to find what I need.

Thanks!

[George Ford]

post a portion of the data with CIC and industry description

[George Ford]

what year?

[George Ford]

https://www2.census.gov/programs-surveys/demo/guidance/industry-occupation/2017-industry-code-list-with-crosswalk.xlsx

Sheet: "2007 - 2017 Industry Crosswalk"