Skip to content

Instantly share code, notes, and snippets.

@AndrewTheTM
Created April 19, 2013 18:14
Show Gist options
  • Save AndrewTheTM/5422132 to your computer and use it in GitHub Desktop.
Save AndrewTheTM/5422132 to your computer and use it in GitHub Desktop.
OKI/MVRPC Model NAICS 2-digit to Employment Type IDs
IF [NAICS2]=11 THEN
Output="Agr"
ELSEIF [NAICS2]>11 AND [NAICS2]<31 THEN
Output="Min"
ELSEIF [NAICS2]>=31 AND [NAICS2]<33 THEN
Output="Man1"
ELSEIF [NAICS2]=33 THEN
Output="Man2"
ELSEIF [NAICS2]=42 THEN
Output="Who"
ELSEIF [NAICS2]>42 AND [NAICS2]<=45 THEN
Output="Ret"
ELSEIF [NAICS2]>45 AND [NAICS2]<=49 THEN
Output="Tra"
ELSEIF [NAICS2]>=51 AND [NAICS2]<=56 THEN
Output="FIRE"
ELSEIF [NAICS2]=61 THEN
Output="Edu"
ELSEIF [NAICS2]=62 THEN
Output="Soc"
ELSEIF [NAICS2]=71 OR [NAICS2]=72 THEN
Output="Art"
ELSEIF [NAICS2]=81 THEN
Output="FIRE"
ELSEIF [NAICS2]=92 THEN
Output="Pub"
ELSE
Output="Unc"
END IF
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment