Throwing it out as a suggestion. If the 10 tables have the same variables, can you just set them on top of one another? data want; set have1 have2 have3 .. have10; run; You can maybe add a variable that distinguishes the different tables in the list. Then just proc export 'want' into a single excel sheet.
... View more