Hi, I am trying to merge two data sets using two variables as the unique ID across both to join the observations. Using different merge functions and inserting the matching variable names is creating an extensive list of observations (over a million, as opposed to approx. 2500). One includes annual observations and the other is additional variables to add to annual observations. Any tips on merging two data sets?
Related Posts with merging two data sets
Heteroskedasticity and MulticollinearityWhen I use the command (estat hettest) after doing the panel regression with re and fe then hausman …
Plotting the cumulative incidence function in the presence of competing risksHi, I am analysing a small trial where the primary outcome is time to event (recovery). All individ…
Is using fixed effects and clustering acceptable for my dataset? if so: which command to use?Hi everybody, while looking for advice regarding my modeling/stata problem, I came across this forum…
Ratio of frequency of two variablesHello I have a dataset like this: Code: * Example generated by -dataex-. To install: ssc install da…
How to construct the second best response to a shock?Hi, I am using a household survey wherein I have been given money raised from top 5 sources in time…
Subscribe to:
Post Comments (Atom)
0 Response to merging two data sets
Post a Comment