Getting numeric columns from oracle using proc sql

Reply
Frequent Contributor
Posts: 87

Getting numeric columns from oracle using proc sql

Hi,

I am using proc sql query to get data from oracle i am facing problem with numeric columns i am unable to get complete digits

specally  fraction after .i have 10 digits totally almost 15-20 digits how to get complete

i am using this query

proc sql;

connect to oracle( user=  password= path=);

create table sample as select * from connection to oracle

(select * from oracledataset);

disconnect from oracle;

quit;

Super Contributor
Posts: 349

Re: Getting numeric columns from oracle using proc sql

Hi Santosh,

Try this option...

DBSASTYPE=Option.

Thanks,

Shiva

Ask a Question
Discussion stats
  • 1 reply
  • 161 views
  • 0 likes
  • 2 in conversation