Hi!
I have a cross-sectional time-series dataset and would like to add some firm-specific information from another dataset.
The variables I intend to use for merging is a company identifier (ds_code) and year. Unfortunately I have no idea why I receive 0 matched observations I checked for duplicates and the format should be fitting as well?
. merge m:1 ds_code year using "C:\Users\Desktop\Stata - Analysis\All_Financials.dta"
(note: variable ds_code was str6, now str7 to accommodate using data's values)
Result # of obs.
-----------------------------------------
not matched 1,992,565
from master 3,998 (_merge==1)
from using 1,988,567 (_merge==2)
matched 0 (_merge==3)
-----------------------------------------
Can anyone give me an advice from outside what might be the cause for this problem?
Thanks a lot!
Related Posts with Problems with merge command
transforming then imputing or vice-versaHi all, I was wondering whether it is better to transform the data then impute the missing values or…
Graphing based on a condition of longitudinal dataDear Statalist User, I have a problem regarding how to graph two scatter plots and their fitted lin…
Interaction terms in mixed-effects regressionHi statalisters ... I need some help to interpret the coefficients of some mixed-effects models in m…
InterpretationDear community, I have a question regarding the interpretation of the size of a coefficient. e.g. I…
Test statistic Pesaran and SmithHello, I have been trying to check if there was already some code about the test statistic about po…
Subscribe to:
Post Comments (Atom)
0 Response to Problems with merge command
Post a Comment