Problem Note 45620: The value of the SYSERR macro variable might be incorrect when you execute the IMPORT procedure in SAS batch mode
The SYSERR automatic macro variable might not be set to a nonzero value when the IMPORT procedure fails. The problem occurs under the following circumstances:
- If you are running SAS in batch mode rather than interactive mode
- If the error in the IMPORT procedure occurs when reading a nonexistent sheet
The following is an example:
proc import datafile='c:\sastest\myexcel.xls'
out=sastest
dbms=xls;
sheet='barney';
run;
Requested Sheet Name not found on Excel -> c:\sastest\myexcel.xls
Requested Input File Is Invalid
ERROR: Import unsuccessful. See SAS Log for details.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
%put &syserr;
0
In this example, the correct value of SYSERR is 1012.
A fix for this issue is planned for a future release.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for x64 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Standard Edition | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 for x64 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Microsoft Windows Server 2008 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Microsoft Windows Server 2008 for x64 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Microsoft Windows XP Professional | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Windows 7 Enterprise 32 bit | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Windows 7 Enterprise x64 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Windows 7 Home Premium 32 bit | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Windows 7 Home Premium x64 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Windows 7 Professional 32 bit | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Windows 7 Professional x64 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Windows 7 Ultimate 32 bit | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Windows 7 Ultimate x64 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Windows Vista | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Windows Vista for x64 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
*
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.
When you run SAS in batch mode, the SYSERR macro variable value remains zero when the IMPORT procedure returns an error. The problem occurs only in SAS batch mode.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2012-03-26 17:35:56 |
| Date Created: | 2012-02-09 12:19:50 |
