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
Help debugging error message in user generated Stata codeHello friends, I am working int Stata/SE 15.1 to replicate a user-contributed command published in …
test post for code entry Code: *====================================================================* *WIERSEMA & BOWEN…
P-interactionHow to obtain p-interaction from the model? For example, I would like to see whether age has an inte…
Suggestion: more ML optimizers, inc. LM-BFGSI would like to suggest that StataCorp implement more ML optimizers, if they are not already conside…
sensitivity analysis following multiple imputation.Hi all, I'm working with a dataset with a fair bit of missing data that I have addressed using MI. …
Subscribe to:
Post Comments (Atom)
0 Response to Joinby function for Ticker and Year
Post a Comment