hello! I am looking to merge two datasets to end with coherent district-level daily dataset from 2009-2013 with temperature, rainfall, and total rainfall variables.
- the first dataset "finalrainfall" has the following shape
Year Edate District_id State_name District_name dailymeanrainfall dailytotalrainfall
- the second dataset "finaltemp" has the following shape
Year Edate District_id State_name District_name Weightedavertemp
I initially tried using the merge command, but I got the error message given that there variables I used werent unique identifiers (merge 1:1 district_id year using "finalrainfall"
I have tried using also joinby - joinby district_id year using "finalrainfall" -
are the results given in this case by joinby equivalet to what merge would have provided?
Related Posts with merging panel data - merge or joinby?
Type mismatch issues with generating / replacingHi all,
I'm currently trying to create a dummy variable, inlaborforce, using the below code:
gen i…
Test for differences in Medians for Multiple Variables Using qregDear Stata Users:
I would like to Test for differences in Medians for Multiple Variables Using qreg …
Generate mean and median test results in StataDear Stata Users:
I am trying to generate mean and median test results in Stata. Thanks to Kain Chen…
Model selection to study individual fund attribute's impacthi,
I have daily data for large number of exchange traded funds for 10 years . I am trying to exami…
Create several nested regression tables in the same file with asdocDear all,
I want to create several nested regression tables in the same file and do it with option …
Subscribe to:
Post Comments (Atom)
0 Response to merging panel data - merge or joinby?
Post a Comment