When using DBMS=XLSX to import or export Microsoft Excel files in UNIX or Linux environments, an error that contains two slashes in the DATAFILE or OUTFILE path might be generated. The XLSX engine adds the extra slash in an attempt to correct the error that it detects in the path or filename. However, the double slash might cause confusion.

Here are some example errors containing the double slash:

Possible causes for these types of errors include the following:

• A misspelled path or filename
• A correctly spelled path in which the case does not match exactly between the path and filename
• Permissions issues that prevent the file from being written to the directory and file specified in the OUTFILE portion of the EXPORT procedure code

To circumvent these types of errors, you must use the correct spelling and case of the path and filenames, and the server permissions must allow the SAS user to write to the directory specified in the OUTFILE=.

Operating System and Release Information