Specifies how to load NUMERIC data from Google BigQuery.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | LIBNAME option value |
| Data source: | Google BigQuery |
| Note: | Support for this option was added in the September 2024 update for SAS/ACCESS on SAS 9.4M7 and in the December 2024 update for SAS/ACCESS on SAS 9.4M8. |
| See: | DBSASTYPE= data set option, FETCH_NUMERIC_TYPE= LIBNAME option |
Table of Contents
specifies that SAS/ACCESS loads NUMERIC values as DOUBLES in SAS.
specifies that SAS/ACCESS loads NUMERIC values first as TKTS_NUMERIC values and then converts these to DOUBLE values in SAS.
When you set FETCH_NUMERIC_TYPE=FLOAT64, SAS/ACCESS converts NUMERIC values directly to DOUBLE values in SAS. The conversion process for FLOAT64 is more efficient and typically results in improved performance when loading NUMERIC data.
DOUBLE values in SAS store up to 15 digits of precision. In cases where you want to convert a NUMERIC value to a CHAR to preserve extended precision, set FETCH_NUMERIC_TYPE=NUMERIC and use the DBSASTYPE= data set option to convert the value to a CHAR. For more information, see Your Options When Choosing Your Needed Degree of Precision.
When you set FETCH_NUMERIC_TYPE=NUMERIC, SAS/ACCESS converts NUMERIC values to TKTS_NUMERIC and then the value is converted to a DOUBLE value. Prior to September 2024 on SAS 9.4M7 and December 2024 on SAS 9.4M8when support for this option was added, this two-step conversion was the default behavior when loading NUMERIC values into SAS.