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
making a number of variables based on values of other variablesHello, I have been receiving great help from the Stata Forum by searching - but today I have encount…
How to merge multiple data sets without id variable?Hi, I want to merge multiple cross-sectional micro data files for each year (1992-2003) to make a si…
Categorize Date VariablesIs there a way to categorize or recode date variables (say which is in %td format) in Stata? This wo…
varananewDear All, I'm looking for the varananew command or some help with it Someone could help me best f …
Bug in asreg?I believe there is a bug in the asreg function. When I run rolling window regressions on panel data …
Subscribe to:
Post Comments (Atom)
0 Response to How to in Stata get data from different WRDS library in one batch
Post a Comment