remotely access to wrds

[MarinaMag]

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.

[s_lassen · Accepted solution]

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;