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?
reference option Oaxaca decompositionHi I am interesting to use my own reference model. so, I tried to use the reference option with Oaxa…
Trying to use pvarsoc to select lag for my pvar but error ariseI'm trying to analyze panel var model and want to select appropriate lag order for my data. But pvar…
Compressing several loopsHi all, I have the 16 loops below, that I want to compress it: HTML Code: mat Y = J(21, 32, .) fo…
transposing rows to columnsHi, My data contains multiple observations for the variable Dealsubtype, whereas I want to change t…
nearest neighbor matchingDear all, I know that there are a lot of topics on this matter, but unfortunately I cant figure out…
Subscribe to:
Post Comments (Atom)
0 Response to merging panel data - merge or joinby?
Post a Comment