• Print |
• E-mail  |
• Bookmark

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