SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

SAS Export to Excel

Posts: 0

SAS Export to Excel

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.
Posts: 73

Re: SAS Export to Excel

Posted in reply to deleted_user
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.
Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation