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;
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.