cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Yayoi_Kurikyu
‎03-10-2019
  • 3 Posts
  • 0 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: Querying WRDS Data in SAS: Error Libname is not assigned.

by Fluorite | Level 6 in SAS Studio
‎03-10-2019 01:30 PM
‎03-10-2019 01:30 PM
I have found the missing code for autoexec:   * The library name definitions below are used by SAS; * Assign default libref for WRDS (Wharton Research Data Services); %include '/wrds/lib/utility/wrdslib.sas' ; options sasautos=('/wrds/wrdsmacros/', SASAUTOS) MAUTOSOURCE;   Thank you for help. ... View more

Re: Querying WRDS Data in SAS: Error Libname is not assigned.

by Fluorite | Level 6 in SAS Studio
‎03-07-2019 04:11 PM
‎03-07-2019 04:11 PM
Hello Tom.   Thank you for replying. However, the problem is that when I first time get access to SAS Studio, it has all access to the libraries on the WRDS and I do not have to type into the command such as libname crsp ''/wrds/crsp/sasdata/m_ccm'';   And I have another problem when I tried to create the CRSP library. When I try to run    libname crsp '/wrds/crsp/sasdata/m_ccm'; data permnolist; set crsp.msf; keep permno; if year(date)>1969; run;   it says ERROR: User does not have appropriate authorization level for file CRSP.MSF.DATA.   But I am pretty sure my university has subscribed the CRSP and I just used it a few days ago before I restore my libraries.   Thank you very much.   Yayoi ... View more

Querying WRDS Data in SAS: Error Libname is not assigned.

by Fluorite | Level 6 in SAS Studio
‎03-05-2019 10:53 PM
‎03-05-2019 10:53 PM
Hello,   I am a beginner of SAS studio and I tried to get access to CRSP database which is supposed to be in 'Libraries'.    https://wrds-www.wharton.upenn.edu/pages/support/programming-wrds/programming-sas/querying-wrds-data-sas/   According to this page, these datasets should take place automatically. However, I think because I wrongly reset SAS session, I cannot find any WRDS datasets now and have no idea how to make it back.   Now my local library looks like this.           And when I try to import data from dataset such as compustat, it shows:    data compustat; set comp.funda; ERROR: Libref COMP is not assigned. if indfmt='INDL' and datafmt='STD' and popsrc='D' and consol='C'; keep gvkeyn fyear fyr datadate act lt pstkc conm sich; run;   I am sorry to bother you with this basic question. And I am really thankful for all your help.   Best, Yayoi     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-10-2019 05:14 PM
Quick links