Hello, I would like to merge MSCI and Compustat data using the following code:
For MSCI data:
egen yrtic = concat (Ticker year)
For Compustat data:
egen yrtic = concat (tic fyear)
joinby yrtic using "Data_MSCI.dta"
however I get the following error: variable yrtic not found
r(111);
Can anyone explain how to make this work?
Related Posts with Joinby function for Ticker and Year
Concatenating string variables with missing values- LCA using gsem (not concave) and convergence not achieved
- Getting values from second to last loop of a -while- loop
- Finding observations that are strictly dominated: how do I eliminate multiple loops
- ereturn post a vector as a pseudovariable like e(sample)
Subscribe to:
Post Comments (Atom)
0 Response to Joinby function for Ticker and Year
Post a Comment