Date: Wed, 2 Nov 2005 11:46:29 -0500
Reply-To: "Michael S. Zdeb" <msz03@HEALTH.STATE.NY.US>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Michael S. Zdeb" <msz03@HEALTH.STATE.NY.US>
Subject: Re: What is the difference between NULL and MISSING in PROC SQL?
Content-type: text/plain; charset=US-ASCII
Hi...this has been the subject of a bunch of notes on SAS-L in the past.
Check the archives at...
Also, there's a paper at SAS tech support...
that discusses NULL versus MISSING in relational databases and SAS, and a
that discusses missing values in PROC SQL.
U@Albany School of Public Health
1 University Drive
Rensselaer, NY 12144-3456
Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU
What is the difference between NULL
and MISSING in PROC SQL?
Please respond to
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;