sas >> SAS created Excel files unreadable under Win 7

by William W. Viergever » Tue, 18 May 2010 08:54:23 GMT

hi all:

a week ago i finally did a clean install of 64-bit windows 7 on an
almmost 3-year dual Opteron box that had been running 64-bit XP since
October 2007

i'm running the latest 64-bit v9.2 and Office 2007

today, when i went to open an Excel file created from one of my sas
jobs and Excel siad it found unreadable content and asked if i wanted
to recover it ... of course i said yes, yet when i opened the file,
all data was gone

ggogled all around and found other posts saying that Excel file
created by other 3rd party apps would give the same unreadable message
under Win 7 (using both Excel 2003 & 2007)

i then opened my 64-bit Vista laptop here at the office, and was able
to open the SAS created Excel file (that was still on my dual Opteron
box) with no problems

saved it, first to the laptop (and then copied to the desktop machine)
and secondly, saved it directly back to the desktop after opening

and then it would open fine under Win7 ?!?!!?

note: on the proc export i use the DBMS = XLS option (as that's the
only one that will work w/ 64-bit *and* support the SHEET option)

according to the all the other posts i had discovered/read, M$ has
failed to respond to this apparent problem w/ Win 7 reading Excel
files created by these other 3rd party apps (that all worked, and
still work, fine under Vista and XP

also

many of these other posts did not mention any 64-bitness ....

so

was wondering, if anyone out ther under Win 7 might whip out a quick
SAS created/test Excel file & see if it opens OK for you

again: it appears that whatever file-format SAS and these 3rd party
apps have been using is no longer working under Win 7

thanks

Similar Threads

1. SAS/MS Experts: Pass Protecting Excel Sheet Created By SAS

SAS-Xperts:



Is there a way password protect an excel file created by SAS ? Preferably as
part of the application's processing.  Excel files themselves can be
password protected, but is there a way for SAS to engage this, or a third
party utility available ?



We needed to do the same thing with PDF files, which I'm told will be a new
feature (password protecting) in v9.2. We found a utility that operates from
the command that will accomplish what we want to do (the utility hasn't come
in yet -- I'm assuming, and hopefully not ASSuming, that the user will be
able to execute the utility via their SAS programs, ie:  %Sysexec, CALL
SYSTEM, "X", etc).



Now, the same question has arisen concerning Excel files. Given the
popularity of Excel, I'm assuming that we aren't unique in having to tackle
this problem.



Any and all information/suggestions/assistance will be much appreciated.



Thank you.



-Gerry



Gerard T. Pauline

Mgr, Internet Applications &

University Web Master

Computer Systems, DoIT

Pace University

2. SAS/MS Experts: Pass Protecting Excel Sheet Created By SAS

3. emailed Excel files turn up as unreadable "mime" files

Would be great if someone could help.  

Sometimes when PC users send attachments to me (like excel, word or
powerpoint files), they show up as "mime" documents and my mac will
not read the file.

I don't know how to overcome this problem and it is a huge pain in the
butt.  I'd appreciate some feedback, thanks in advance!

 XXXX@XXXXX.COM 

4. How do I restore an unreadable floppy disk created in excel - Excel

5. creating excel file beyond the size of an excel worksheet

6. Thank you creating excel file beyond the size of an excel

7. .xls files Win 98 to Win XP home

HELP !! I now have Win XP Home with Microsoft Suite 2003 
installed on a new computer. What needs to be in place to 
allow me to transfer .xls files from Win 98 on my old 
computer??


Thanks, Ed Ralph  Ottawa, Canada.

8. Error: Configuration file "C:\Program" is unreadable."