|Date: ||Wed, 2 Nov 2005 08:08:07 -0800|
|Reply-To: ||Glen Chen <ymmv_123@HOTMAIL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Glen Chen <ymmv_123@HOTMAIL.COM>|
|Subject: ||What is the difference between NULL and MISSING in PROC SQL?|
|Content-Type: ||text/plain; charset="iso-8859-1"|
Could anybody kindly explain to me the difference b/w "NULL" and
"MISSING" when used in PROC SQL?
I didn't find any difference so far. Below is an example:
The only difference between the two PROC SQL blocks is NULL/MISSING. I
was given the same results from the two SQLs.
Any help is appreciated.
do value = "a","b","" ,"d"; output; end;
create table aaa as
where value is not NULL;
create table bbb as
where value is not MISSING;