topic Re: error libref not assigned when remotely connecting to wrds in SAS Programming

error libref not assigned when remotely connecting to wrds

Noga — Thu, 10 Jun 2021 07:21:31 GMT

I am trying to remotely connect to wrds libraries with sas.
The code I'm using is:

%let wrds = wrds-cloud.wharton.upenn.edu 4016;
options comamid=TCP
remote=WRDS; signon username=_prompt_;

rsubmit;
libname crspa '/wrds/crsp/sasdata/a_stock';
libname temp '/scratch/tau/noga';
libname link '/wrds/crsp/sasdata/a_ccm';
libname index '/wrds/crsp/sasdata/a_indexes';
libname cc '/wrds/crsp/sasdata/a_ccm';

I am able to sign in, however I recieve in the log the warning: One or more libraries specified in the concatenated library WRDSSEC do not exist. These libraries were removed from the concatenation.

when I run the rest of the code:

data compcrsp; set cc.CCMXPF_LINKTABLE;
permno=lpermno;
keep gvkey permno linkdt linkenddt;
proc sort; by permno;
run;

I receive the following error message:

error: libref cc is not assigned.

the log is attached to this message.

It is important to mention that I have run this program many times in the past, and there was no problem. I also checked the directories in wrds, and they have not changed.

I don't understand why this error message appears now. please help me.

thanks

Re: error libref not assigned when remotely connecting to wrds

Tom — Thu, 10 Jun 2021 12:00:05 GMT

You have not shown any code that is attempting to define a libref of WRDSSEC.

Where is that code?

Is it part of your autoexec.sas on that server?

Re: error libref not assigned when remotely connecting to wrds

Cynthia_sas — Thu, 10 Jun 2021 12:53:49 GMT

Hi:
Since you are issuing LIBNAME statements that point to data locations on the WRDS server it is possible that those locations have been changed since the last time you ran your program. It will be hard to provide help for this because SAS does not control the placement of data on UPenn/Wharton's WRDS system and we do not use WRDS data in any of our free classes. However, UPenn/Wharton does maintain a support site. Assuming you have a login, you should be able to at least find out the correct path for your WRDS data by contacting them here: https://wrds-web.wharton.upenn.edu/wrds/support/index.cfm .
Cynthia