topic Re: export csv from sas to shared drive in SAS Programming

export csv from sas to shared drive

Alex91 — Thu, 07 May 2020 16:28:38 GMT

Hello!

I'm trying to export csv-file to shared drive and stuck with access problem.

libname DM 'E:\Temp';

proc export
data = DM.NPS_EMPLOYEE_DAY dbms = csv
outfile = "\\fs\common\4AKhripunov\emp_day.csv"
replace;
run;

ERROR: Undetermined I/O failure.

As far as i get it SAS doesn't have access to this shared drive.So the question is what's the easiest way to setup this access?

Any help would be appreciated.

OS:Windows

SAS version: 9.4.5.0

Re: export csv from sas to shared drive

jhealthpolicy — Thu, 07 May 2020 20:46:31 GMT

Can you access the shared drive through windows explorer?

ie go to windows explorer and go to \\fs\common\4AKhripunov\

If you can access it, can you create a file in that location? Try copying a small file to that location.

If you can't access that location, or you can't create a file you'll need to contact the administrator of the server(your IT department)

Re: export csv from sas to shared drive

Alex91 — Thu, 07 May 2020 21:10:07 GMT

@jhealthpolicy

Can you access the shared drive through windows explorer?

ie go to windows explorer and go to \\fs\common\4AKhripunov\

If you can access it, can you create a file in that location? Try copying a small file to that location.

yes, i can access the shared drive from my pc and can create a file there. Ofc i can manually copy csv-file from SAS server to shared drive. But the main point that it has to be the automatic scheduled process.

Re: export csv from sas to shared drive

jhealthpolicy — Thu, 07 May 2020 21:40:12 GMT

I tried your code on my shared drive and it works fine. The few times i've seen this error its been due to permissions on the shared drive. As an alternative, you could write the file out locally, and then copy it over through an x command.

data _null_;
x "copy E:\emp_day.csv \\fs\common\4AKhripunov\emp_day.csv";
run;

Re: export csv from sas to shared drive

SASKiwi — Thu, 07 May 2020 22:00:22 GMT

@Alex91 - The likely cause of your problem is your remote SAS server doesn't have the correct permissions set up to reference the shared drive. This is something your SAS administrator will need to fix. It is not something you can do from your PC.