Using IP ADDRESS in PROC EXPORT in SAS

Question

I'm using PROC EXPORT of SAS to export information in xlsx format into a shared folder in my network. When I use the servername in the path of the output file, everything works well. When I change for the IP ADDRESS of the server, I get the following error:

ERROR: Connect: The Microsoft Access database engine cannot open or write to the file '\\123.12.12.12\PUBLIC\TEST1.xlsx'. It is already opened exclusively by another user, or you need permission to view and write its data.

Here it's my code:

proc export 
data=WORK.TABLE1
DBMS=EXCEL
outfile="\\123.12.12.12\PUBLIC\TEST1.xlsx"
REPLACE;
SHEET='A';
run;

Do you know if the IP ADDRESS format is supported by PROC EXPORT? If not, it exists other method to export in SAS by using IP ADDRESS in the path of the output file? I have to use a way with IP ADDRESS as the servername is changed from time to time and I a have a bunch of scheduled SAS projets.

Thank you, Dan

You could use nbstat or nslookup host command to retrieve the name-for-addr, and use the retrieved name in your outfile. I would think changing the host name of a fixed address is more damaging than changing the address of a fixed name. — Richard

DomPazz DomPazz · Accepted Answer · 2018-05-23T15:34:57

That error is coming from the file system. SAS is using the file system to get to whatever path you specify, so in Windows, what you have should work.

Possible Problems:

Someone else has the file open.
Another process has locked the file.
You (the user SAS runs as) do not have write permissions to the file or directory.

Test #3 by

data _null_;
file "\\123.12.12.12\PUBLIC\TEST1.txt";
put "Hi";
run;

This will confirm you have write permissions in the directory. If SAS is running on the server, do this in the same way you call your other program.

If that is successful, then try deleting the XLSX file from Windows. If that fails, you don't have permission or someone has the file opened. You will need to debug that.

If it succeeds, then rerun your program. Hopefully it will create the file.

Using IP ADDRESS in PROC EXPORT in SAS

1 Answers