topic Re: How to directly export data to local using only a script? in SAS Procedures

How to directly export data to local using only a script?

3r — Fri, 02 Nov 2018 21:43:17 GMT

Hi all,

I want to have a program to run on SAS EG 7.1 that can take data from our team's remote SAS server and download it directly onto my local machine.

I wanted to use this little program that I found in a related post;

proc export data = sashelp.class

outfile = 'c:\dokus\class.txt'

dbms = dlm replace;

delimiter = '09'x;

run;

When I create the \dokus\class.txt document in my C drive and run the program on SAS EG, I get the following error in my log;

ERROR: Physical file does not exist, c:\dokus\class.txt.

I've read all of the answers to the related post; https://communities.sas.com/t5/SAS-Procedures/Unable-to-export-data-to-local-folders-PROC-EXPORT-in-SAS-EG/td-p/159122, but I still don't know what to do.

I don't really know how to tell the SAS server to look into my local C drive since there is no connection between the SAS server and my local C drive.

And just as a little side note; using the copy files task feature, saving onto a shared folder, etc., or anything similar are really not options. Everything needs to be in a compact little piece of code that I can just run on the EG to do the entire exportation at once.

Thanks in advance!

coco

Re: How to directly export data to local using only a script?

Reeza — Fri, 02 Nov 2018 21:45:18 GMT

@3r wrote:

Hi all,

I want to have a program to run on SAS EG 7.1 that can take data from our team's remote SAS server and download it directly onto my local machine.

I wanted to use this little program that I found in a related post;
proc export data = sashelp.class

outfile = 'c:\dokus\class.txt'

dbms = dlm replace;

delimiter = '09'x;

run;
When I create the \dokus\class.txt document in my C drive and run the program on SAS EG, I get the following error in my log;

ERROR: Physical file does not exist, c:\dokus\class.txt.

I've read all of the answers to the related post; https://communities.sas.com/t5/SAS-Procedures/Unable-to-export-data-to-local-folders-PROC-EXPORT-in-SAS-EG/td-p/159122, but I still don't know what to do.

I don't really know how to tell the SAS server to look into my local C drive since there is no connection between the SAS server and my local C drive.

And just as a little side note; using the copy files task feature, saving onto a shared folder, etc., or anything similar are really not options. Everything needs to be in a compact little piece of code that I can just run on the EG to do the entire exportation at once.

Thanks in advance!

coco

If there's no connection to your drive or a common drive (network drive) then this isn't possible. I believe this is a feature since it locks data down to the server and exports are traceable.

You have to use a Task or a shared folder.

Re: How to directly export data to local using only a script?

Reeza — Fri, 02 Nov 2018 21:45:49 GMT

If you use SAS BASE instead of EG this is possible.