Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Merge Data - housing burden + Wharton Index

    Dear all,
    I am trying to merge data on the housing burden and the Wharton index. Both datasets include a geo ID that is composed of State, county and place code, as: 32(state)108(county)123445(place). I noticed my variables in the wharton dataset are not following the same units, for the place, if the place # does not have six units, they did not include zeros to keep the format.

    The data looks like this:

    Datafile 1:

    Click image for larger version

Name:	Screen Shot 2020-04-27 at 12.43.55 PM.png
Views:	2
Size:	83.3 KB
ID:	1549606


    Datafile 2:

    Click image for larger version

Name:	Screen Shot 2020-04-27 at 12.44.18 PM.png
Views:	2
Size:	44.1 KB
ID:	1549607


    I am struggling with this so I appreciate any suggestion to make both geoid a number of length 11.

    I am sorry if this is not the best way to address this question. Thank you.

  • #2
    This was subsequently reposted in the General Forum, which is a more appropriate location for a discussion of this topic, and where it has attracted a response.

    https://www.statalist.org/forums/for...-wharton-index

    Comment

    Working...
    X