BookmarkSubscribeRSS Feed
Noga
Calcite | Level 5

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

 

2 REPLIES 2
Tom
Super User Tom
Super User

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?

Cynthia_sas
SAS Super FREQ
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

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 904 views
  • 0 likes
  • 3 in conversation