topic Re: Period in oracle table name in SAS Programming

Period in oracle table name

hmadams — Wed, 16 Dec 2020 03:41:57 GMT

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;

Re: Period in oracle table name

ChrisNZ — Wed, 16 Dec 2020 04:55:41 GMT

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;

Re: Period in oracle table name

hmadams — Wed, 16 Dec 2020 11:59:56 GMT

This worked. Thank you!