Problem Note 67707: Unexpected characters might be appended to the end of a value on a string variable in a Google BigQuery table when it is read into SAS® software
 |  |  |  |  |
Unexpected characters might be appended to the end of a value on a string variable in a Google BigQuery table when it is read into SAS under the following conditions:
- The SCANSTRINGCOLUMNS=YES LIBNAME or data set option is included.
- The DIRECT_SQL=NO LIBNAME option is included.
The workaround for this option is to use SCANSTRINGCOLUMNS=NO or DIRECT_SQL=YES.
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 TS1M6 | ||
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | 2020.1.1 | 2020.1.4 | Viya | Viya |
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#67707A fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H5A.html#67707| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-04-02 14:01:29 |
| Date Created: | 2021-04-01 12:06:24 |