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
SEM: Panel analysesDear all, I´m using data from a Panel Study and working with two main latent variables (X and Y) th…
How can I make a look to count the number of household member whose age is under 18?Hello, I am trying to generate the variable that captures the number of members whose age is under …
How to get AIC/BIC after fitting mixed lear regression on imputed dataI am wondering if any body would help me in getting AIC?BIC for multiple imputed data and analyzed u…
If else loop in StataHi, I wrote a code like if x=="x1"|x=="x2" { replace z=y replace a=b } However, it did not work. I…
How to construct a 95% confidence interval for a solved regression equation?I have solved a regression equation in order to find a CEO's salary after ten years. The equation is…
Subscribe to:
Post Comments (Atom)
0 Response to Problems with merge command
Post a Comment