Problem Note 65552: Running the SUMMARY procedure against a Google BigQuery table might return incorrect values for weight variables that have null values
 |  |  |  |  |
Running the SUMMARY procedure against a Google BigQuery table might result in different values than what SAS® software would have generated. You encounter this issue when the columns specified in the WEIGHT statement contain null values.
This issue occurs because BASE procedures are not currently enabled for in-database processing with SAS/ACCESS® Interface to Google BigQuery. Instead, the processing is handled through FEDSQL. The difference in results occurs due to the part of the code that contains the expression where var < 0. In a database, a null is the absence of a value, so it is not considered as less than 0. However, in FedSQL, the comparison is considered true.
The workaround is to pull the data into SAS and run the procedure on the SAS data set.
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.4 | 9.42 | 9.4 TS1M6 | 9.4 TS1M7 |
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | V.03.04 | 2020.0.4 | Viya | Viya |
A 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#65552| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-04-17 15:35:38 |
| Date Created: | 2020-02-12 16:07:05 |