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

[Yayoi_Kurikyu]

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...

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

[Tom]

Just re-run the LIBNAME statement you used before to create the libref COMP.

It should probably look something like:

libname comp 'some path on your SAS server';

Just figure out where you pointed the libref before and recreate it.

If you really created a dataset named FUNDA then there should be a file named 'funda.sas7bdat' in the directory.

[Yayoi_Kurikyu]

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

[Yayoi_Kurikyu · Accepted solution]

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.