Hello Friends,
how to access a long database tablename which has specical character like /, _,.?
Any help would be appreciated. Thank you.
I would change the name of the table.
Thank you Reeza, can you please provide example? Thank you.
It was below...more explicitly, something like this:
data want;
set schema.'Table/Name'n;
run;
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
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;
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.