SAS pulling data incorrectly from our System

[ColumbiaU]

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

[Patrick]

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

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