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

Parents Reply Children
  • 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