SAS pulling data incorrectly from our System

Reply
New User
Posts: 1

SAS pulling data incorrectly from our System

Hi everyone,
 
I am having a problem pulling some data into SAS via an ODBC connection. Negative monetary values from our database are being pulled in as extremely large integers (e.g.-1,090.00 > 1,844,674,407,369,865.00, -450.00 > 1,844,674,407,369,895.00, -552.00 > 1,844,674,407,369,873.00). Positive monetary values pull in just fine. I am connecting using an Adaptive Server Enterprise Driver. When I access the same data source through MS Access, both positive and negative monetary values pull in fine. Has anyone seen this before or have any ideas of what might be causing it?
 
Thanks,
Josh
Respected Advisor
Posts: 3,834

Re: SAS pulling data incorrectly from our System

Given that no one answered I'd suggest that you contact SAS Tech Support

https://support.sas.com/techsup/contact/

 

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