When you create a Google BigQuery table in which the input data contains a character variable that is missing, two double quotation marks ("") might be loaded into the resulting string column instead of a blank or null. This issue occurs when any of the following is true:
- You use a DS2 procedure while running SAS® 9.4M6 Rev. 940_19w34 with any SAS/ACCESS® Interface to Google BigQuery 9.41 hot fixes installed, SAS® 9.4M7 (TS1M7), or SAS® 9.4M8 (TS1M8).
- You use the SAVE action with a CAS procedure or a SAVE statement with the CASUTIL procedure and run SAS® Viya® 3.5 with May 28, 2020 or later hot fixes.
- You use the SAVE action with a CAS procedure or a SAVE statement with the CASUTIL procedure and run SAS® Viya® 2020.0.1 or later.
There is no workaround for this issue.