Usage Note 32619: Using the MIXED=YES option in the IMPORT procedure generates a Read-only note
In SAS® 9.2, when you use the MIXED=YES option in PROC IMPORT, the following message is generated:
PROC IMPORT OUT= mydata
DATAFILE= "J:\users\nsouli\Debugging.xls"
DBMS=EXCEL REPLACE;
SHEET="'SAS$'";
GETNAMES=YES;
MIXED=yes;
RUN;
NOTE: Data source is connected in READ-ONLY mode.
The note occurs because Microsoft Jet locks the Excel file in Read-only mode. In SAS 9.2, a note appears in the SAS log. Earlier versions of SAS also generate Read-only files as well.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | |
| Microsoft® Windows® for x64 | 9.2 TS1M0 | |
| Microsoft Windows 2000 Advanced Server | 9.2 TS1M0 | |
| Microsoft Windows 2000 Datacenter Server | 9.2 TS1M0 | |
| Microsoft Windows 2000 Server | 9.2 TS1M0 | |
| Microsoft Windows 2000 Professional | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | |
| Microsoft Windows XP Professional | 9.2 TS1M0 | |
| Windows Vista | 9.2 TS1M0 | |
*
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.
In SAS® 9.2, when you use the MIXED=YES option in PROC IMPORT, the following message is generated:
NOTE: Data source is connected in READ-ONLY mode.
This message occurs because Microsoft JET locks the Excel file in Read-only mode.
| Date Modified: | 2009-10-21 12:44:14 |
| Date Created: | 2008-07-03 10:09:20 |
