The Chaining Method for Industrial Crosswalks
Because the U.S. Census Bureau does not publish direct mappings between legacy SIC and current NAICS versions, database architects use a transitive chaining method [1]. We chain mappings step-by-step through the historical updates: 1987 SIC → 1997 NAICS → 2002 → 2007 → 2012 → 2017 → 2022 NAICS.
This allows us to maintain the relationship between legacy codes and modern standards. For example, mapping SIC 7371 (Computer Programming Services) yields NAICS 541511 (Custom Computer Programming Services) [1][2]. However, some SIC codes map to multiple NAICS codes (1-to-many relationship) because modern NAICS categories are more granular than legacy divisions.
Concordance Analysis
Our crosswalk implementation maps 2,150 transitive paths, ensuring that all 1,004 SIC codes map to active 2022 NAICS counterparts without leaving orphans [1].