Hello,
When I use the following commands to work remotely on wrds server can I also use data that are not included in wrds for my procedures?
%let wrds = wrds.wharton.upenn.edu 4016;
options comamid=TCP remote=WRDS;
signon username=_prompt_;
rsubmit...
Lets say for example to merge a dataset that I have obtained with data from crsp and use them together in the analysis that follows.
Thank you.
There are several possibilities. If your remote data are not too large, you can allocate the remote library as a server library on your own PC, and run your joint analysis locally:
rsubmit;
libname xx <definition>;
endrsubmit;
libname xx server=wrds slibref=xx;
data want;
merge xx.inputdata mydata.crsp;
Alternatively, you can download the data from the server and run locally:
rsubmit;
proc download data=xx.inputdata out=Work.inputdata;run;
endrsubmit;
data want;
merge inputdata mydata.crsp;
Or you can upload your data to the remote server and run the analysis there:
rsubmit;
proc upload data=mydata.crsp out=Work.crsp;run;
data want;
merge xx.inputdata crsp;
/* more SAS code here */
endrsubmit;
There are several possibilities. If your remote data are not too large, you can allocate the remote library as a server library on your own PC, and run your joint analysis locally:
rsubmit;
libname xx <definition>;
endrsubmit;
libname xx server=wrds slibref=xx;
data want;
merge xx.inputdata mydata.crsp;
Alternatively, you can download the data from the server and run locally:
rsubmit;
proc download data=xx.inputdata out=Work.inputdata;run;
endrsubmit;
data want;
merge inputdata mydata.crsp;
Or you can upload your data to the remote server and run the analysis there:
rsubmit;
proc upload data=mydata.crsp out=Work.crsp;run;
data want;
merge xx.inputdata crsp;
/* more SAS code here */
endrsubmit;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.