An error message similar to the following that indicates an out of memory condition might occur when you use the ODS destination for Excel with large tables:

The out of memory condition occurs because the ODS destination for Excel is a measured destination that requires the entire table to be held in memory until the table ends. This is different from some of the other ODS destinations that write to Excel, such as the ExcelXP tagset. It does not perform any measurement and holds one cell in memory at a time. Because the ODS destination for Excel is a measured destination, it is more susceptible to out of memory conditions. In addition to memory errors, you might also experience increased CPU and clock times compared to the other ODS destinations, such as the ExcelXP tagset. 

To prevent the error, you can reduce the size of larger tables by breaking them up into smaller tables. This action enables the memory to be freed after processing each of the smaller tables. This action can be accomplished by using methods such as BY-group processing or using the OBS= and FIRSTOBS= data set options to subset the data.

You also can increase the memory for the job by using the MEMSIZE system option either at start-up or in the configuration file.