Problem Note 69502: Floating point numeric values loaded into CAS and displayed in SAS® Anti-Money Laundering differ from the actual numeric values loaded in the database
 |  |  |  |  |
Floating point numeric values with more than 15 digits might get truncated or rounded when the data is loaded into CAS.
For example, when you specify the currency_amount field in the amlprep.transactions file to be numeric (18,5) in the Postgres database, the value 9,999,999,999,999.99999 (18 digits, 5 decimal places) is displayed and handled correctly in Postgres database. However, when you load the amlprep.transactions data to CAS in the TM Prep - Transactions data object page, the value is loaded as 10,000,000,000,000.002 (rounded and has 002 decimal points).
You should be aware that SAS cannot support more than 15 digits for fixed point numbers and ensure that your data complies with this limitation in order to prevent impacts on alert generation.
Numerical Accuracy in SAS® systems is discussed in SAS® 9.4 and SAS® Viya® Programming Documentation.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Anti-Money Laundering | Linux for x64 | 8.3 | Viya | ||
An update for this issue is available for SAS Compliance Solutions 8.3. For instructions on how to access and apply these software updates, see the documentation links at the top of
https://tshf.sas.com/techsup/download/hotfix/HF2/ComplianceSol_83_home.html#69502| Type: | Problem Note |
| Priority: | low |
| Date Modified: | 2023-06-21 12:35:42 |
| Date Created: | 2022-08-24 16:26:30 |