Is anyone aware of problems with the SAS Export to the EXCEL Workbook which has multiple sheets with links between them to create a summary sheet? I have no problem with a simple Excel Workbook but when I have to update a complex Workbook I do not get the results anticipated. SAS always creates a new sheet instead of updating the intended sheet.
I find that using the sas EXCEL engine with the libname statement creates a dynamic link where the XLS file is the :library" and the sheets are "datasets" within the library. We found it to be superior to the Import/Export Procs.