Problem Note 67025: Variables defined as a NUMERIC data type in Google BigQuery might be read into SAS® as a different value
 |  |  |  |  |
Variables defined as a NUMERIC data type in Google BigQuery might be read into SAS as a different value. The difference varies but usually results in there being additional decimal digits starting after the 11th decimal digit.
For example, 15.27 might be read in as something similar to 15.270000000000010658141036401500 while 2000 might be read in as something similar to 2000.000000000001136868377216160000.
This issue occurs when you use the BULKUNLOAD=YES option.
The workaround is to use BULKUNLOAD=NO.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Google BigQuery | Linux for x64 | 9.42 | 9.43 | 9.4 TS1M7 | 9.4 TS1M8 |
A fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K2L.html#67025| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-04-16 11:47:48 |
| Date Created: | 2020-12-02 16:09:31 |