It works if I execute in Stata odbc load, exec("select permno, shrcd, date, prc, vol, ret from crsp.dsf where date between '1995-01-01' and '1995-12-31'") dsn("wrds-pgdata-64")
But I also want to get the share code which is from library "CRSP_NAMES", not "dsf". How can I tell Stata to get all the data in one batch?
Related Posts with How to in Stata get data from different WRDS library in one batch
Polytomoushow will i code A= 1, B= 2, C=3 ,D=4 in this excel sheet Q1 Q2 Q3 Q4 Q5 Q6 Q7 1 B A A B A D A 2 C B …
Two stage two stage least squares method - Help neededHi, I am preparing for an Honour Thesis right now and I need to be directed on (1) Appropriateness o…
Polytomoushow will i code A= 1, B= 2, C=3 ,D=4 in this excel sheet Q1 Q2 Q3 Q4 Q5 Q6 Q7 1 B A A B A D A 2 C B …
Bayesian iRT using bayesmhhow will i code A= 1, B= 2, C=3 ,D=4 in this excel sheet Q1 Q2 Q3 Q4 Q5 Q6 Q7 1 B A A B A D A 2 C B …
Combining two datasets which formats are different.Hello everyone, I am trying to make below two dataset merged, but don't know how to make the format…
Subscribe to:
Post Comments (Atom)
0 Response to How to in Stata get data from different WRDS library in one batch
Post a Comment