Title

sicff -- Create Fama French Industry from Standard Industrial Classification (SIC) Code

Syntax

sicff varname , industry(#) [generate(newvar) longlabels]

Main
industry(#) choose which Fama French industry to create — 5, 10, 12, 17, 30, 38, 48, or 49

generate(newvar) create variable named newvar; default name for newvar is ff_#

longlabels use long labels for the industries; default is short labels

Description

sicff takes a 4-digit numeric SIC code (varname) and creates a new variable that contains the specified Fama and French industry. By default, a short label is applied to the new variable. See Ken French's website for more details on the industry classifications: http://mba.tuck.dartmouth.edu/pages/faculty/ken.french/data_library.html

The "Other" category

SIC codes fall between 0100 and 9999. Any erroneous values outside this range will result in missing values for the new industry variable.

Some of the industries — 17, 30, 48, 49 — classify the "Other" category as explicit SIC code ranges. For these industries, SIC codes that fall outside any defined range will result in missing values for the new industry variable.

The remaining industries — 5, 10, 12, 38 — classify the "Other" category as a catch-all for the remaining SIC codes that are not explicitly defined. For these industries, SIC codes that fall outside any defined range will be classified as "Other." It is the user's responsibility to ensure that the SIC codes are valid.

Examples

. sicff sic, ind(48)

. sicff sic, ind(12) gen(ff12industry)

. sicff sic, ind(49) l

Author

Tyson Van Alfen
Email: tyson.vanalfen@pm.me
Website: https://tysonvanalfen.com