Problem Note 68061: Google BigQuery numeric variables might be displayed as garbage
 |  |  |  |
The environment variable SAS_BIGQUERY_DEFAULT_NUMERIC_FORMAT does not recognize when an invalid character format is specified. Rather than returning an error that indicates that the format is not valid, the numeric data in a BigQuery table might be displayed as garbage, as shown below:
To ensure that invalid formats are recognized, use the data set option DEFAULT_NUMERIC_FORMAT.
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.4 | 9.4 | 9.4 TS1M6 | 9.4 TS1M8 |
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | V.03.04 | 2021.1.2 | Viya | Viya |
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-06-25 09:38:38 |
| Date Created: | 2021-06-18 12:49:02 |