topic Re: How to sepcify missing values in where clause in SAS Enterprise Guide

How to sepcify missing values in where clause

eagles_dare13 — Thu, 08 May 2014 13:28:07 GMT

In SAS, is there a difference between saying:

select * from table where col1 is missing

and

select * from table where col1 = .

We assume that col1 is numeric.

Re: How to sepcify missing values in where clause

DBailey — Thu, 08 May 2014 13:31:09 GMT

I think they're equivalent as is

select * from table where col1 is null

Re: How to sepcify missing values in where clause

Haikuo — Thu, 08 May 2014 13:57:47 GMT

When I am not sure the the variable type, I tend to use MISSING() function, which will cover both Char and Number, and within Number, these wired missing values such as .z, .B, ._ etc.

Haikuo