In SAS, while using in a WHERE clause, is there any differnece between
WHERE col1 is MISSING
vs
WHERE col1 is NULL
Can you explain citing the case when col1 is char and when col1 is numeric?
Asked
Active
Viewed 6,767 times
1 Answers
5
WHERE col1 is NULL and WHERE col1 is MISSING are identical: SAS translates between the two freely (the documentation refers to them as one). Both pick up character missing, numeric missing, and numeric special missings (.M etc.) fine.
See the SAS documentation for more specific information on IS NULL / IS MISSING.
Note that this is only true for SAS-side processing. If you're connected to another kind of database/data source (such as Oracle, SQL Server, etc.), these do not necessarily apply - even if you're running it in PROC SQL with a LIBNAME.
Joe
- 62,789
- 6
- 49
- 67
-
2Perhaps add some distinction for how non-SAS libnames and ODBC passthrough may behave differently? – Robert Penridge Nov 25 '15 at 18:12
-
Yeah, I meant to put that in and then forgot-thanks! – Joe Nov 25 '15 at 18:18