Usage Note 60745: Errors contain a double slash in the path when using DBMS=XLSX
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:
ERROR: Physical file does not exist, /tmp//Class.xlsx.
ERROR: Temporary file for XLSX file can not be created -> /saswork/reference/redhat/9.4/install/SASFoundation/9.4/tmp/xxx//class.$$1.
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
SAS System | SAS/ACCESS Interface to PC Files | AIX | | |
ABI+ for Intel Architecture | | |
64-bit Enabled Solaris | | |
64-bit Enabled HP-UX | | |
64-bit Enabled AIX | | |
HP-UX | | |
HP-UX IPF | | |
IRIX | | |
Linux | | |
Linux for x64 | | |
Linux on Itanium | | |
OpenVMS Alpha | | |
Solaris | | |
Solaris for x64 | | |
Tru64 UNIX | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Date Modified: | 2017-07-21 10:07:28 |
Date Created: | 2017-07-10 14:33:13 |