Period in oracle table name

[hmadams]

I have an oracle table with a period in the name. How do I get the data into SAS? I have tried...

Libname testlib oracle user='xxxxx' password='xxxxx' path='xxxxx' show_synonyms=YES;
data table_without_period;
set testlib.table_name.with_period;
run;

And I have tried...

Libname testlib oracle user='xxxxx' password='xxxxx' path='xxxxx' show_synonyms=YES;
data table_without_period;
set testlib.'table_name.with_period'n;
run;

[ChrisNZ · Accepted solution]

And I have tried...

Libname testlib oracle user='xxxxx' password='xxxxx' path='xxxxx' show_synonyms=YES;
data table_without_period;
set testlib.'table_name.with_period'n;
run;

What comes back?

Have you tried

proc sql;
  connect using TESTLIB;
  create table WANT as select * from connection to TESTLIB ( 
    select * from table_name.with_period
  );
quit;

[hmadams]

This worked. Thank you!