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
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?
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!
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.
Ready to level-up your skills? Choose your own adventure.