Hi Experts,
I use SAS EG 7.1. I want to export reports to excel as follows:
I want to export a report as .xlsx. For this purpose, I am using ODS EXCEL and PROC REPORT. This is working fine with small files say if a dataset has rows upto # 5,000 and output gets generated in few seconds.
But if the # of rows exceed 5,000 in the report, it takes more time to run and after 1 min or so a message pops up “The results are larger (#### bytes) and could take long time and a large amount of system resources to add to the project”. Then I click ‘Yes’. Then it produces output.
But if the # rows exceed 20,000, after I click ‘Yes’, it also closes SAS session.
What can I do to so it write to excel without any problem. And I don’t want user to see that message and click Yes or No.
I would appreciate your help.
... View more