export csv from sas to shared drive

[Alex91]

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

[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.

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)

[Alex91]

@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.

[jhealthpolicy]

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;

[SASKiwi]

@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.