Copy data from WRDS server to my computer using rsubmit

[nazmul]

Hello everyone,

I am working on WRDS server using rsubmit. I want to directly download data from WRDS server to my computer hard drive. But I am getting the following error. Could you please help to sort out the problem? I would appreciate your help.

To include my hard drive in rsubmit, I am running the following code:

libname US 'F:\Full Paper\Dissertations\US';
rsubmit;
libname US 'F:\Full Paper\Dissertations\US';
endrsubmit;

But I am getting the following error,

name US 'F:\Full Paper\Dissertations\US';
NOTE: Libref US was successfully assigned as follows:
Engine: V9
Physical Name: F:\Full Paper\Dissertations\US
91 rsubmit;
NOTE: Remote submit to WRDS commencing.
97 libname US 'F:\Full Paper\Dissertations\US';
NOTE: Library US does not exist.
NOTE: Remote submit to WRDS complete.

My main objective is to run the following SQL function;

rsubmit;
proc sql; create table US.b1999
as select a.*, b.*
from bdx.F1 as a
inner join b1999 as b
on a.a=b.b and a.c<=b.yr1; run;
endrsubmit;

Here. US is my hard drive folder and bdx is a WRDS server.

[Tom]

Why not just use PROC DOWNLOAD to move the data from the remote to local?

libname local 'F:\.....';
rsubmit;
proc sql ;
create table WORK.xxx as
.....
quit;
proc download data=xxx out=local.xxx;
run;
endrsubmit;

[nazmul]

Thank you for your reply. The file is very large in size and i have very
low download speed. Therefore, i want to directly send the file to my hard
drive.

[Patrick]

---

@nazmul wrote:
Thank you for your reply. The file is very large in size and i have very
low download speed. Therefore, i want to directly send the file to my hard
drive.

---

If you want to move data from the server to your local environment then you need to transfer the data at one time over the network. 

You could use remote library services (RLS) for the code you have in mind but I strongly doubt that this would give you better performance. https://go.documentation.sas.com/?docsetId=connref&docsetTarget=n1oda0s1uwd6nqn1ofyq60lgfp9z.htm&doc... 

Having Windows on both sides you could also consider to first create the table on the server side, then zip it, download the zip file and then unzip it again on the client side. 

[LinusH]

Remote Library Services is probably the slowest way to download data (unless they have boosted the performance in the latest releases).

One thing that could be faster is if your server can map your desired location as a shared drive (like accessing it using a UNC).

If this is one time job, why bother?

[Tom]

---

@nazmul wrote:
Thank you for your reply. The file is very large in size and i have very
low download speed. Therefore, i want to directly send the file to my hard
drive.

---

I don't see how that will help.