Before using resources for one-to-one mapping, please ensure that you are certain that a one-to-one mapping is most suitable for your purposes. Further discussion can be found on my LFS SIC Mapping page.

1. Office for National Statistics (ONS) one-to-one mapping between SIC 1992/SIC 2003 and SIC 2007

The ONS realised that a proportional mapping based on the IDBR weighted correspondence between SIC 1992 (2003) and SIC 2007 (discussed here) would not be suitable for many purposes using LFS data, where those purposes required a mapping at individual level that was consistent over time. The ONS LFS team therefore devised a modified direct, one-to-one, mapping. It is this direct mapping that is used to generate the ongoing industry information based on SIC 1992 after the changeover to SIC 2007 in 2009 Q1. The QLFS data from 2009 Q1 use a SIC07-SIC92 mapping from SIC 2007 Classes (4-digit level) to SIC 1992 Divisions, Sections and Sectors (2- and 1-digit levels).

The reverse SIC92-SIC07 would be useful for time series analysis if SIC 2007 classification is wanted throughout. Sean Milburn of the LFS Research team at the ONS Social Survey Divison has very kindly made available his coding to map SIC 1992 Classes to SIC 2007 Divisions or Sections.

2. Jennifer Smith's one-to-one mapping between SIC 1980 and SIC 1992

Using two alternative methods, I have created direct mappings between SIC 1980 and SIC 1992.

The first method is based on overlapping information provided in the LFS Autumn 1993 dataset on SIC80 Activity and SIC 1992 Section.

The second method is based on individuals remaining in the same job (stayers) between Autumn 1993 and Winter 1993/94. Autumn 1993 data give SIC 1980 Activities and Winter 1993/94 data give SIC 1992 Divisions and SIC 1992 Sections.

This STATA do-file implements both versions of the 1-to-1 map and effectively explains how the Excel spreadsheets and recodes are derived.

3. Jennifer Smith's one-to-one mapping between SIC 1968 and SIC 1980

With the aid of invaluable advice from Sean Milburn at the ONS, and the spreadsheet of correspondences available from the LSE RLAB, I have created a direct mapping between SIC 1968 and SIC 1980.

I have mapped 3-digit SIC 1968 to 2-digit and 1-digit SIC 1980. Specifically - using the original nomenclature for each SIC aggregation level, nomenclatures that confusingly differ from those used in later SIC classifications - I have mapped each 3-digit "Minimum List Heading" (the lowest level of aggregation available for SIC68, corresponding to Group level in later SIC classifications) to a single SIC 1980 2-digit "Class" or SIC 1980 1-digit "Division" (where in terms of aggregation SIC80 "Classes" correspond to Divisions of later classifications, and SIC80 "Divisions" to later classifications' Sections or Sectors).