title: Using IP ADDRESS in PROC EXPORT in SAS
body: <p>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:</p>
  
  <p><em>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.</em> </p>
  
  <p>Here it's my code:</p>
  
  <pre><code>proc export 
  data=WORK.TABLE1
  DBMS=EXCEL
  outfile="\\123.12.12.12\PUBLIC\TEST1.xlsx"
  REPLACE;
  SHEET='A';
  run;
  </code></pre>
  
  <p>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.</p>
  
  <p>Thank you,
  Dan</p>