Data Download Query
Posted: 03 July 2012 07:15 PM   [ Ignore ]
Newbie
Rank
Total Posts:  7
Joined  2011-10-18

When I attempt to restrict the download from the daily stock return table to specific days the resulting file contains no observations.  I make sure to use parentheses and maintain the same structure for the date (i.e. 20090901).  Is there something else that I should be sure to do?

Profile
 
 
Posted: 03 July 2012 09:38 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi WciConte,

Date is not a string; try something like this, see http://www.lexjansen.com/pharmasug/2005/tutorials/tu01.pdf:

proc sql;
 
create table z as select from crsp.dsf where date '28jul2004'd;
quit

best regards,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile