Riskmetrics Databases - formatting issues
Posted: 22 January 2012 08:11 PM   [ Ignore ]
Newbie
Rank
Total Posts:  7
Joined  2012-01-20

Hello:

This may be a rather trivial question, but maybe someone experienced the same problem:

When I download the Riskmetrics Directors database (legacy) in Stata format, the formatting is totally messed up, meaning that the data view shows most numerical values in scientific notation. For instance, year is shown as “2.0e+03.” When I download the same file in csv format, the formatting is fine (however, I’d rather download in Stata format to get the variable lables etc.).

Thanks!

Profile
 
 
Posted: 22 January 2012 08:57 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi,

Maybe the data is correct, and it is a formatting issue, as explained here: http://www.ats.ucla.edu/stat/stata/faq/longid.htm

best,

Joost

 Signature 

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

Profile
 
 
Posted: 22 January 2012 09:02 PM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  7
Joined  2012-01-20

Thanks for the reply. Yes, the data is correct and the formatting is the issue. However, the formatting is messed up for almost all variables. Now, I could of course do the footwork and change the format for all affected variables but I was wondering if someone experienced the same issue but came up with a more efficient method. Thanks!

Profile
 
 
Posted: 22 January 2012 10:04 PM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

Maybe it is an idea to switch to SAS for data collection? With remote submit you can bypass the web interface. I have worked with both SAS and Stata and SAS is stronger on matching datasets. Stata is ‘friendlier’ when it comes to working with a ‘final’ sample (regressions etc).

Stata transfer can be used to convert SAS datasets to Stata. Although the version that I have (version 9.5) does not work with the 64-bit version of SAS.

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
 
 
Posted: 23 January 2012 01:34 AM   [ Ignore ]   [ # 4 ]
Newbie
Rank
Total Posts:  7
Joined  2012-01-20

Unfortunately i don’t have access to SAS or Stata transfer. Thanks for the idea though! Maybe I’m gonna write WRDS and see what they have to say about this issue. Thanks!~

Profile
 
 
Posted: 23 January 2012 09:39 AM   [ Ignore ]   [ # 5 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

ok.
One other way that may work is to run SAS code remotely on the WRDS server. (You can also export datasets from SAS in csv format, that you can import in Stata).
That could pay off if you are an ‘intense’ user of their data (so skip all the manual stuff with web-interface, etc.).
To solve this problem with dates, it may be easier to format the variables in Stata..

best,

Joost

 Signature 

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

Profile
 
 
Posted: 29 September 2012 04:06 PM   [ Ignore ]   [ # 6 ]
Newbie
Rank
Total Posts:  10
Joined  2012-03-03

Hi,
I need Riskmetrics Directors database but I do not have the account. Could anyone please help me? I would be so grateful :( I need it for my research but the school does not have the account :(

Profile
 
 
Posted: 30 September 2012 01:00 PM   [ Ignore ]   [ # 7 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19
SamLe - 29 September 2012 04:06 PM

Hi,
I need Riskmetrics Directors database but I do not have the account. Could anyone please help me? I would be so grateful :( I need it for my research but the school does not have the account :(

hi SamLe,

The way to go is to find a co-author from a school that has subscribed to the dataset.

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