Often times i have had scenarios where the users needed to look at an Excel file having significant number rows ( > 100K) and also columns ( > 40) . To create such a file, I have tried tagsets but they all fell short of expectations of size and performance. Since ODS EXCEL produces native .xlsx binary files occupying much less size compared to all other methods I would like to propose that this Destination be improved to ensure large tables can also be exported to Excel via this method. Obviously, this Destination right now does suffer from memory issues when dealing with large tables as noted here
Some workarounds suggested are splitting large tables etc but this not always welcome by the users. I currently use Base SAS 9.4M4 and this issue still exists. Increasing MEMSIZE system option also does not always help. I do understand this is not an easy issue to address considering how the Destination was designed but would like to see if SAS R&D can come up with some good improvements in the near future.
This improvement would also be useful for companies which have BASE SAS but not necessarily are willing to invest money to buy SAS/ACCESS Interface to PC Files software and thus using PROC EXPORT with .xlsx files is completely ruled out.