Increase ODS Excel bandwidth

[kpl05]

Can increase the number of rows of data put out by ODS Excel to around 10,000 rows at all? Currently, I find that it struggles to get to 1,000 rows with 24 columns. While using PROC EXPORT or the XLSX library engine would get around this, that means that the ability to format the output would be lost.

[ballardw]

You might have asked about this and shown the code you are currently using to generate that output.

I just generated a set with 20000 rows and used proc print to ODS Excel.

All 20000 rows are in the output and took about 35 seconds total.

There are things that affect performance, such as having multiple ods destinations open like the default results window html and possibly the complexity of the output.

Also your installation may have imposed some limitations.

[Reeza]

What version of SAS do you have? This was an issue with the early versions of ODS EXCEL but thought it was resolved.

Check your version with proc product_status; run;