Problem Note 65487: An incorrect number of observations is returned after you use the DATEPART function in a WHERE statement for a CAS table
 |  |  |  |  |
Using the DATEPART function in a WHERE statement against a SAS® Cloud Analytic Services (CAS) table can return an incorrect number of observations.
This issue happens only when the variable that is being passed to the DATEPART function contains missing values.
The following syntax can illustrate the problem:
caslib _all_ assign;
input x : datetime18.;
datalines;
01jan2020:00:00:00
03jan2020:00:00:00
;
set casuser.a;
where datepart(x) ge '01jan2019'd;
run;
Instead of receiving all the observations that you expect, you receive only a portion of them in the results.
You can circumvent this issue by using a subsetting IF statement in place of the WHERE statement, as shown here:
set casuser.a;
if datepart(x) ge '01jan2019'd;
run;
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya | Linux for x64 | 3.4 | |||
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2020-02-03 10:47:01 |
| Date Created: | 2020-01-30 13:27:53 |