Specifies how to load NUMERIC data from Google BigQuery.
| Valid in: | LIBNAME statement that connects to an external data source |
|---|---|
| Category: | Data Set Control |
| Default: | FLOAT64 |
| Data source: | Google BigQuery |
| Notes: | Support for this option was added in the September 2024 update for SAS/ACCESS on SAS 9.4M7 and in the December 2024 update of SAS/ACCESS on SAS 9.4M8. |
| This option applies only when submitting FedSQL and DS2 programs in PROC FEDSQL and PROC DS2. | |
| See: | DBSASTYPE= data set option, FETCH_NUMERIC_TYPE= data set 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. If you intend to preserve more than 15 digits of precision by converting the NUMERIC value to a CHAR value, select NUMERIC for this option.
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 perserve 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.4M8 when support for this option was added, this two-step conversion was the default behavior when loading NUMERIC values into SAS.