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