Tips:Automatically Separating Data into Excel Sheets
From sasCommunity
You can use the macro language with a PROC EXPORT to automatically generate a Excel workbook with one sheet for each level of a classification variable.
Submitted by Art Carpenter. Contact me at my Discussion Page.
....read more
