Usage Note 5518: Dataset with missing values improperly exported to Excel97 or Excel2000
Exporting from SAS 8.x to Excel97 or Excel2000
under Windows 2000 Service Pack 2 or Windows XP will result in
data appearing in the incorrect columns.
For example if you have a data set that looks like:
Obs var a b c d e f g
1 AAA 1 2 3 4 5 . 6
2 AAB . 1 2 3 4 5 6
3 AAC 1 2 3 . 4 5 6
4 BBB 1 2 3 4 5 6 .
Then you export it to MS Excel by executing:
PROC EXPORT DATA= work.test
OUTFILE= "c:\temp\exportxls.xls"
DBMS=EXCEL97 REPLACE;
RUN;
When you view the data in Excel you will see:
var a b c d e f g
AAA 1 2 3 4 5 6 .
AAB . 1 2 3 4 5 6
AAC 1 2 3 4 5 6 .
BBB 1 2 3 4 5 6 .
Users can create delimited text files (CSV or TAB delimited) or create
an Excel 5 file, as that procedure does not use the MS Jet OLEDB engine.
To correct the problems for users of Windows 2000 sp2 and Windows XP,
1.) Go to the Microsoft web site.
http://microsoft.com
2.) See article Q314763 and take the links to get the MSJet 4.0
Service Pack 6. Be sure to get the Service Pack for the
correct operating system.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows XP Professional | 8.2 TS2M0 | |
| Microsoft Windows 2000 Datacenter Server | 8 TS M0 | |
| Microsoft Windows 2000 Professional | 8 TS M0 | |
| Microsoft Windows 2000 Server | 8 TS M0 | |
| Microsoft Windows 2000 Advanced Server | 8 TS M0 | |
*
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: | Usage Note |
| Priority: | alert |
| Date Modified: | 2003-07-15 10:40:36 |
| Date Created: | 2001-07-27 12:51:36 |