In reply to Eva K Smith.

I think the thing that's getting you is the REPLACE in your PROC EXPORT. You might need to check (and delete) for the XLSX file before you begin, and then use this process to run PROC EXPORT for each value, adding each sheet as it goes.

The 'kad' Keeps just the Alpha and Decimal characters in the name, removing special characters that can't be in a SAS file name.