3119 - Warning: End of Datasource Reached when Exporting SAS Dataset to Excel or to MSAccess

Problem Note 3119: Warning: End of Datasource Reached when Exporting SAS Dataset to Excel or to MSAccess

If PROC EXPORT or the Export Wizard is used to write a SAS dataset to
the Excel or MSAccess file formats, and that SAS dataset exceeds the
size limitations of those external file formats, the following error
message is returned:

      WARNING: End of DataSource reached.
      ERROR:  Read Access Violation In Task [ EXPORT ]


An Excel file can have a maximum of 256 columns and 65,536 rows.
A MSAccess file can have a maximum of 255 fields, and a maximum
file size of 1 gb.

Users can use PROC TRANSPOSE on the dataset and then export
the newly reorganized dataset to the external file format.

Operating System and Release Information

Product Family	Product	System	Reported Release	Fixed Release*
SAS System	SAS/ACCESS Interface to Teradata	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to SAP BW	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to Sybase	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to PeopleSoft	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to R/3	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to PC Files	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to OLE DB	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to Oracle	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to Oracle Rdb	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to MySQL	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to ODBC	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to Informix	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to IMS-DL/I	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to DB2	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to DB2 Server for VM	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to CA-IDMS	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to CA-OpenIngres	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to Adabas	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to Baan	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0
SAS System	SAS/ACCESS Interface to CA-Datacom/DB	Microsoft Windows NT Workstation	8 TS M0	8.2 TS2M0
		Microsoft Windows 95/98	8 TS M0	8.2 TS2M0
		Microsoft Windows 2000 Professional	8 TS M0	8.2 TS2M0

* 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.

Type:	Problem Note
Priority:	low
Topic:	SAS Reference ==> LIBNAME Engines

Date Modified:	2000-11-27 15:47:59
Date Created:	2000-07-28 11:00:12

Knowledge Base

Problem Note 3119: Warning: End of Datasource Reached when Exporting SAS Dataset to Excel or to MSAccess

Operating System and Release Information