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
Date values are differentHello, I have values for the dates given in LB21B. I used the code egen LB21B_12=convertCMC(LB21B) w…
Testing dominance between Lorenz curvesHello Stata Experts, I will request information on the Stata code to test for dominance between two…
Using mca or pca to generate a single variableDear colleagues I know I can use principle component analysis (PCA) on categorical variables by firs…
Conducting multinomial regression on multiply imputed variables for subset dataHi Is there a way to conduct multinomial regression for a weighted subsample datasets? For e.g. I us…
ipdmetan - estimation_commandI would like to use ipdmetan to do an IPD meta-analysis for studies with treatment response yes/no a…
Subscribe to:
Post Comments (Atom)
0 Response to Joinby function for Ticker and Year
Post a Comment