I'm running SAS 9.3 and Excel 2007 on Windows XP - and have recently encountered a problem. I have a number of overnight jobs that creates simple output for various members of the business - and have traditionally out put this to an excel file that is then sent to the relevant parties as part of the SAS job. Recently a number of people have complained that the file is corrupt - however I can open the file no problems and have been copying the output into another file and emailing it to them once I get into work. Its not a valid long term solution as its a painful task for me and relies on me being in work to be able to do this. After some searching around - it appeared to be a problem with other members running Windows 7 and some issue with Excel 2007. The solution seemed to be to uninstall and install SAS PC server - I did this to no avail - also from a recent test I did with a colleague (non SAS literate) they could open the file and they are running Windows 7. Does anyone have any experience or help that might shed light on this? Thanks in advance
... View more