The name can include special characters, except for the / \ * ? " < > |: -. characters.
Several of your characters fall into the characters that cannot be included unfortunately. You will need to rename them.
To allow SAS code to use non-standard names for datasets (members) you need to the VALIDMEMBERNAME option to EXTEND. But even then there are some characters, like / , that are not allowed.
You mentioned that the data is in a database. Use a pass through query to access the data.
For example if you have a libref defined that points to some external database, like ORACLE,
libname mydb oracle ... ;
You can use that LIBREF in SQL code like this.
proc sql; connect using mydb; create table want as select * from connection to mydb (select * from "mygoofy or long table name" ); quit;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.