PUMA GEO Codes to State Names

[travisweiland@gmail.com]

I have a dataset with geo codes for PUMAS (i.e. g0100100) and I know the first two digits after the g represent the state for the PUMA. What I need help with is finding a formula I could use in CODAP to create a new attribute with letter abbreviations for each state from the two digit designations in the PUMA geo codes. I am guessing I need some kind of index that maps the two with a find and replace like feature but I could use some help. Thanks!

[Bill Finzer]

Hi Travis,

1. Create a new attribute stateCode with the formula:
   subString(full geo codes, 2, 2).
   This extracts (as a number) the code for the state.
2. Import into your document a dataset that has each state and its code. Let’s say its name is states_with_codes and that it has attributes code and name.
3. Back in the original dataset create a new attribute stateName with the formula:
   lookupByKey(“states_with_codes”, “name”, “code”, stateCode)
4. You’ll probably want to Delete Formula (Keeping Values) for both of these new attributes you’ve created.

You can actually replace step 3 with a join move. Drag the code attribute from your imported dataset on top of stateCode and release. Voilá! You’ve joined the two datasets.

Hope this helps.

Bill

[travisweiland@gmail.com]

It worked! Thank you

[Author]

Posts