ODS is a wonderful tool, but sometimes it can drive you crazy. The older ExcelXP destination put out XML that you could (and sometimes had to) manually read and correct the problem. It's a little more reliable with the newer Excel destination, but when you do have a problem, it's tricky because you can't typically just open it in Notpad.exe and see what's wrong.
A shot in the dark: Take the spaces out of your sheet name. Replace them with underscores. If that doesn't work then maybe @Cynthia_sas or @Vince_SAS might be of more assistance.
Jim
Told ya it was a long shot.
Hmm. Well, let me think about it. These things are at least in my experience difficult to debug.
Jim
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.