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:
Datafile 2:
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.
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:
Datafile 2:
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.
Comment