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
Time Fixed Effects EsttabDear all, I would like to add a line with the word "Yes" if time fixed effect is used. Unfortunatel…
Check if two exposure varibales are independent of each otherHi, Apologies if this is very obvious, I've managed to get confused about it. If i want to check if…
Invalid syntax error when combining foreach and logout ttable2Hi, I am trying to output the ttable2 results of different groups. The code I am writing is as foll…
Count distinct digits of observationsDear statalists, I would like to count the number of digits an observation has as follows: Numbe…
many dummies and interaction variables in PPML estimationHello! I am trying to estimate the impact of the Eurasian economic union (EAEU) on bilateral trade f…
Subscribe to:
Post Comments (Atom)
0 Response to Joinby function for Ticker and Year
Post a Comment