show occupation codes

I'm trying to link CPS/ASEC data on occupations to other data, but the MDAT doesn't seem to offer the option to get the code along with the label for each occupation. This makes it much harder to merge with other datasets. Any advice? 

thanks!

Mike

  • The ACS PUMS - SOC crosswalk codes are available in this ACS Code List document: www2.census.gov/.../2018_ACS_Code_Lists.pdf (occupation info starts on page 81). Hope this helps!
  • Hi Diana, Thanks! This does help, but copying and pasting from a pdf to my dataset is not ideal, as you can imagine. I did figure out how to export the codes from the MDAT page, but I just think it would be easier if there were a way to display the codes along with the labels for occupations, industries, etc. But in any case, I figured out a workaround. Thanks again!
    Mike
  • Would either of these IPUMS USA webpages be helpful:

    usa.ipums.org/.../occ_ind.shtml

    usa.ipums.org/.../occ_acs.shtml

    Somewhere in IPUMS there may be an Excel document named "2000-4 OCC to 2013 OCCSOC IPUMS Crosswalk.xlsx" that might be useful. I have a copy and can share it if you are interested.
  • Hi - yes! I looked at those, but for my purposes (I'm using the MDAT tool) this was the simplest (see screenshot below). When I download the table, it downloads the occupation titles, but as you can see from the screenshot, it's also possible to export, as a separate table, the titles & codes for the same table you are downloading (click on "OCCP" on the left, and then right click on the table on the right in the screenshot, to get th pop-up with the "export" option). Then, I merged the data table & the titles & codes table, by occupation title, to get a final table with occupation codes, occupation titles, and the column variables (in this case, POVPIP).
    PS: maybe the site doesn't allow the screenshot...?

    image.png

    thx,
    Mike