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
Specifying both crossed and nested random effects in "mixed"I have a hierarchical design where politicians where each asked 9 randomly chosen questions from a p…
Using a loop with local and extended macros to generate new recoded variables, variable labels, and value labelsI am generating a series of new variables that represent recoded versions of existing variables. At …
xtmixed: stopping iteration when non-convergence is encounteredI'm running a simulation using -mixed- command. My simulation contains both random intercept and ran…
How to handle the missing values generated by tssmooth exponential in unbalanced panel dataDear all, I have an unbalanced panel dataset. Panel variable is firm_id and time variable is year. …
Origin Dest Airline DataDear stata users, per year quarter I've information on origin and destination for the airlines in th…
Subscribe to:
Post Comments (Atom)
0 Response to merging two data sets
Post a Comment