I was wondering if you could help me. I am trying to pull data from the Oracle tables the SAS access passthrough. The account numbers are stored in the oracle databases as numeric (19 digits) and so if you pull it down as normal (or using a libname), the last few digits lose precision. I tried the following and while the customer_id is character with 19 digits, it also loses precision (seems that the last 2-3 numbers are garbage/random). proc sql; connect to oracle as oradb (user=xxxxx password=’xxxxxxx' path='dbname' ); create table dat.test as select * from connection to oradb ( SELECT to_char(account_number) as customer_id ,model_score from FLOW_RESULT where rownum<15 ); disconnect from oradb; quit; Any help woudl be much appreciated!
... View more