How to access database tablename with special character?

[woo]

 Hello Friends, 

how to access a long database tablename which has specical character like /, _,.?

Any help would be appreciated. Thank you.  

[HB]

I would change the name of the table. 

[Reeza]

Have you tried the NLITERAL approach?

schema.'Table/Name'n

[woo]

Thank you Reeza, can you please provide example? Thank you. 

[Reeza]

It was below...more explicitly, something like this:

data want;
set schema.'Table/Name'n;
run;

[Reeza]

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.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/nlsref/n10nwm6blrcrtmn0zdcwyxlwxfjh.htm

[Tom]

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;