Hi all,
In a bit of a quandary.
I have an individual-zip-code-level dataset. Each zip-code has a longitude/latitude associated with it. I want to create variables that hold the value of each first longitude/latitude, second longitude/latitude etc. The maximum number of longitude/latitudes associated with a given person is 220. So ideally, I would have 220 variables, with values missing in cases where the person doesn't have 220 different longitude/latitudes.
Can someone offer advice on the best way to do so?
Thanks!
EDIT: In essence, I want to transpose only the variable containing the longitude/latitude values
In a bit of a quandary.
I have an individual-zip-code-level dataset. Each zip-code has a longitude/latitude associated with it. I want to create variables that hold the value of each first longitude/latitude, second longitude/latitude etc. The maximum number of longitude/latitudes associated with a given person is 220. So ideally, I would have 220 variables, with values missing in cases where the person doesn't have 220 different longitude/latitudes.
Can someone offer advice on the best way to do so?
Thanks!
EDIT: In essence, I want to transpose only the variable containing the longitude/latitude values
Comment