BookmarkSubscribeRSS Feed
Alex91
Fluorite | Level 6

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

4 REPLIES 4
jhealthpolicy
Fluorite | Level 6

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
Fluorite | Level 6

@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
Fluorite | Level 6

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
PROC Star

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

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1497 views
  • 0 likes
  • 3 in conversation