I have a strange "error" when I use Proc Export and it doesn't always happen, only sometimes and happens in multiple programs. It's a standard Proc Export: proc export data = dataset outfile = "C:\myfile.xlsx" dbms = Excel replace;sheet="test";run; SAS 9.3 | Windows 7 There will be no error, the log will say it all completed successfully, but when I check the sheet (which is set up with formatting so I don't have to copy/paste from a new file) it is not updated. The only way I know how to make it work is to open the sheet, make ANY change, even 1 number in one cell, and save it. Then re-run the export and VOILA! it works, never fails. Any ideas? Anyone else get this?
... View more