BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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.
1 REPLY 1
JohnH
Fluorite | Level 6
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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Discussion stats
  • 1 reply
  • 993 views
  • 0 likes
  • 2 in conversation