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-..., 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
@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-..., 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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.