# Construct PWMETRO for 2012-onward ACS using PWPUMA00

**URL:** <https://forum.ipums.org/t/construct-pwmetro-for-2012-onward-acs-using-pwpuma00/2544>\
**Category:** USA\
**Created:** [September 7, 2018, 6:34am UTC](https://forum.ipums.org/t/construct-pwmetro-for-2012-onward-acs-using-pwpuma00/2544 "2018-09-07T06:34:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![wycatwy](https://avatars.discourse-cdn.com/v4/letter/w/ea5d25/32.png) [@wycatwy](https://forum.ipums.org/u/wycatwy)\
**Post date:** [September 7, 2018, 6:34am UTC](https://forum.ipums.org/t/construct-pwmetro-for-2012-onward-acs-using-pwpuma00/2544/1 "2018-09-07T06:34:00Z")

</div>

I wish to construct “pwmetro” variable for 2012-onward ACS samples.

I have been able to identify the relationship between new PUMAs and (2010 version) PWPUMA00 codes, but I am not sure how to construct “place of work MSAs” using PWPUMA00? How can I identify which PWPUMA00 fall into particular MSA? (any mapping files similar to MET2013 crosswalk files? [https://usa.ipums.org/usa-action/vari…](https://usa.ipums.org/usa-action/variables/MET2013#description_section))

Many thanks!

---

<div class="post-metadata">

**Author:** ![JonathanSchroeder](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/jonathanschroeder/32/70_2.png) [@JonathanSchroeder](https://forum.ipums.org/u/JonathanSchroeder)\
**Post date:** [September 7, 2018, 2:37pm UTC](https://forum.ipums.org/t/construct-pwmetro-for-2012-onward-acs-using-pwpuma00/2544/2 "2018-09-07T14:37:00Z")

</div>

As it happens, we recently completed our internal work to produce a new “PWMET13” variable that will supply 2013 metro area codes for 2000 and 2005-2016 samples. We plan to release the variable later this fall, in mid-October at the earliest.

Before then, you can make use of the attached supplementary files, which correspond (just as you suggested) with the MET2013 crosswalk files. I see that the User Forum system has truncated the file names, so that two of the files now have the same name (PWMET13\_match\_errors.xls). They both describe match errors between 2013 MSA’s and 2000 PWPUMA’s, but one uses 2000 populations (for 2000 samples) and the other uses 2010 populations (for 2005-2011 ACS samples).

Our code assignment protocol for PWMET13 will match MET2013’s: we’ll assign an MSA code to a PWPUMA if more than 50% of the PWPUMA’s population resides in the MSA \_and\_ the sum of omission and commission errors for the MSA is less than 15%.

If you have any more questions, feel free to reply to this post.

[MIGMET131\_PWMET13\_ma.xls](https://forum.ipums.org/uploads/short-url/3uwBm9olaQYFMoqLSx7qJssZvRV.xls) (88.5 KB)  
[MSA2013\_MIG-PW-PUMA2.xls](https://forum.ipums.org/uploads/short-url/ts8JX4kpIZTyinRj3YHb3Se3bJv.xls) (221 KB)  
[MSA2013\_PWPUMA2000\_c.xls](https://forum.ipums.org/uploads/short-url/ofjnTwIX6gn5IhamwLPbKbFkyNs.xls) (372 KB)  
[PWMET13\_match\_errors-1.xls](https://forum.ipums.org/uploads/short-url/xi0Tw9I3UYz2t05p7WWkabGKcdL.xls) (90 KB)  
[PWMET13\_match\_errors.xls](https://forum.ipums.org/uploads/short-url/2qkB4J9tHdmxoAjzDYo9tlD5ndh.xls) (89.5 KB)