Hello all,
I have two datasets: one has a column of geographic identifiers and one has a column of geographic identifiers and a column of dates.
I am trying to create a dataset that will append every date from the second dataset to the corresponding row (with a matching geographic identifier) in the first dataset. There are multiple dates in the second dataset that correspond to each geographic identifier in the first dataset. I would like to create a unique row for each geographic identifier -- date combination. The final product should look something like this:
GEOID --- DATE
1 ............. Date 1
1 ............. Date 2
1 ............. Date 3
I am not sure how to do this. Does somebody have any idea?
Thank you!
Related Posts with Merging Data
Displace full name of variableHi, When I use the list variable, display short name "chan~n_3", but it is actually "change_land_own…
Display full name of variableHi, When I use the list variable, display short name "chan~n_3", but it is actually "change_land_own…
Displace full name of variableHi, When I use the list variable, display short name "chan~n_3", but it is actually "change_land_own…
Cannot use python in Stata 16.1 in CatalinaI have tried to solve the problem, but it seems to be stubborn. What to do? I installed the new vers…
Display full name of variableHi, I want to see variable name "change_land_own_3" , instead of "chan~n_3" . How should I do it? …
Subscribe to:
Post Comments (Atom)
0 Response to Merging Data
Post a Comment