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
Repeated observations in panel data Dear all, I am trying to build a long database. I have data from 2004 to 2018 where, during four y…
Suppress input prompt for pauseFantastic people of Statalist, I am running a batch of do files that contain -pause- commands and w…
returnsyh command donwloads historical data for any ticker with historical data in Yahoo - ErrorHi, I am getting the following error with returnsyh command donwloads historical data for any ticke…
Maximizing Sharpe Ratio - Portfolio optimizationHi, I would like to maximize the Sharpe ratio (=Historical Return (portfolio)/Standard deviation(po…
Need help on predicting a value of dependent variableHi, I've recently started learning statistics. On stata, how can I get the predicted value of a depe…
Subscribe to:
Post Comments (Atom)
0 Response to How to in Stata get data from different WRDS library in one batch
Post a Comment