for even moderate sized tables (80,000 recs) ODS EXCEL can blow out of memory while proc export works just fine.
There are some useful features to ODS EXCEL but it can only be used on small tables. I have MEMSIZE=2147483648 and yet SAS crashes with 80k recs.