topic Re: libname error when using WRDS address in SAS Programming

libname error when using WRDS address

Leon_Seungmin — Mon, 24 Oct 2016 13:37:46 GMT

Dear all,

I am sorry to ask you so many basic questions. I did google search and review of multiple guides for quite some time but I could not find the answer.

Currently, I am trying to calculate CAR around event days. Using the following code, I logged into WRDS.

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

Then, to access CRSP, I used the following code.

libname crsp '/wrds/crspq/sasdata/ix';

When this code is excuted, I receive the following error message.

212 libname crsp '/wrds/crspq/sasdata/ix';
NOTE: Library CRSP does not exist.

I am running SAS on windows.

Thank you very much for your help.

Re: libname error when using WRDS address

Kurt_Bremser — Mon, 24 Oct 2016 14:06:04 GMT

To use a dataset present on the remote server, you need to use the remote engine:

libname crsp remote '/wrds/crspq/sasdata/ix' server=wrds;

Re: libname error when using WRDS address

Leon_Seungmin — Mon, 24 Oct 2016 14:09:02 GMT

Thank you for the response. I just tried remote, but I still get the same error message. This is the log.

227 libname crsp remote '/wrds/crspq/sasdata/ix' server=wrds;
NOTE: Library CRSP does not exist

Re: libname error when using WRDS address

Kurt_Bremser — Mon, 24 Oct 2016 14:23:58 GMT

Then I suggest you log on to the server and make sure that /wrds/crspq/sasdata/ix actually exists. The NOTE message is typical for a path that does not exist.

Re: libname error when using WRDS address

Leon_Seungmin — Mon, 24 Oct 2016 14:53:30 GMT

Thank you very much! That was indeed the case. I checked the directory(https://wrds-web.wharton.upenn.edu/wrds/tools/variable.cfm?library_id=20) and found that they are using a different directory name now.