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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.