Problem Note 63426: Null values are not read into SAS® Cloud Analytic Services (CAS) as missing when the variable's data type is REAL
 |  |  |  |
Null values are not read into SAS Cloud Analytic Services (CAS) as a missing value when the original column in the database table is defined as a REAL data type. Instead of a missing value, the variable contains an actual value. This issue occurs when you use either LOAD CASDATA with the CASUTIL procedure or with the FEDSQL procedure. Here are some examples.
Example 1
proc casutil;
load casdata="nulltest" incaslib="mydblib" outcaslib="casuser" casout="mynulltest";
quit;
load casdata="nulltest" incaslib="mydblib" outcaslib="casuser" casout="mynulltest";
quit;
Example 2
proc fedsql sessref=mysession;
select * from mydblib.nulltest;
quit;
select * from mydblib.nulltest;
quit;
There is no workaround for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Connector to Teradata | Linux for x64 | V.03.03 | V.03.04 | Viya | Viya |
| SAS System | SAS Data Connector to SAP HANA | Linux for x64 | V.03.03 | V.03.04 | Viya | Viya |
| SAS System | SAS Data Connector to PostgreSQL | Linux for x64 | V.03.03 | V.03.04 | Viya | Viya |
| SAS System | SAS Data Connector to Impala | Linux for x64 | V.03.03 | V.03.04 | Viya | Viya |
| SAS System | SAS Data Connector to Microsoft SQL Server | Linux for x64 | V.03.03 | V.03.04 | Viya | Viya |
| SAS System | SAS Data Connector to ODBC | Linux for x64 | V.03.03 | V.03.04 | Viya | Viya |
| SAS System | SAS Data Connector to Oracle | Linux for x64 | V.03.03 | V.03.04 | Viya | Viya |
| SAS System | SAS Data Connector to Hadoop | Linux for x64 | V.03.03 | V.03.04 | Viya | Viya |
| SAS System | SAS Data Connector to DB2 | Linux for x64 | V.03.03 | V.03.04 | Viya | Viya |
| SAS System | SAS Data Connector to Amazon Redshift | Linux for x64 | V.03.03 | V.03.04 | Viya | Viya |
| SAS System | SAS Data Connect Accelerator for Teradata | Linux for x64 | V.03.03 | V.03.04 | Viya | Viya |
| SAS System | SAS Data Connect Accelerator for Hadoop | Linux for x64 | V.03.03 | V.03.04 | Viya | Viya |
| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2019-01-09 15:09:57 |
| Date Created: | 2018-12-21 13:30:04 |