Dear Statalist community,
As part of my research I am trying to merge two data sets (WERS and ASHE) using firms' unique identifiers (IDBR number) in combination with their postcodes to establish a unique workplace identifier. The problem here with the UK postcodes is that they are not constructed in a completely systematic way. They can range from 5 to 7 characters. Sometimes they begin with one letter followed by one digit, sometimes followed by two digits and at other times they begin with two letters followed by two digits before a space.
Examples:
G2 5HN
B37 5TT
BS14 OTJ
EC3A 2BE
I have followed the discussion and comments on this topic (https://www.stata.com/statalist/arch.../msg00144.html). Unfortunately, deleting the space did not change anything about the character of the variable. It is still a string variable which cannot be combined with the IDBR number to generate the unique identifier. I always receive the error message that these two variables mismatch even when using: . gen identifier = IDBR + string(postcode,"%02.0f").
Any help is dearly appreciated.
Felix
Related Posts with Convert UK postcode string to combine with numerical variable
Drop command to remove rows "0 observations deleted"I have been trying to drop a number of rows in my dataset, but for some reason, they still remain ev…
Multiple hypothesis testingHello Users, I am a new user of the stata software. I am analysing the usage of maternal care serv…
comparing sample medians at three time pointsHi, I would like to compare median z scores for weight at birth versus one month of age versus one y…
Help needed: Automate extracting of dataHi all, I am using Stata 16 and I need some help in automating the process of extracting data. I am…
replacing observations within groupsHello everyone, I have a dataset where I have several text_rules belonging to text types inside dif…
Subscribe to:
Post Comments (Atom)
0 Response to Convert UK postcode string to combine with numerical variable
Post a Comment