As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Tips:Use IS MISSING and IS NULL with Numeric or Character Variables

From sasCommunity
Jump to: navigation, search


As part of the decommissioning effort for sasCommunity.org this article/tip has been migrated to communities.sas.com.

The new home for this article/tip is Use IS MISSING and IS NULL with Numeric or Character Variables (https://communities.sas.com/t5/SAS-Tips-from-the-Community/SAS-Tip-Use-IS-MISSING-and-IS-NULL-with-Numeric-or-Character/m-p/475183#M170)



The IS MISSING and IS NULL operators, which are used with a WHERE statement, can handle character or numeric variables. They also work with the NOT operator:

*** create a sample dataset with some missing values;
data makemissing;
    set sashelp.class;
    if substr(name,1,1) eq 'J' then initial='J';
    if 11 le age le 13 then newage=age;
run;
 
*** use missing;
proc print data=makemissing;
    where initial is missing and newage is not missing;
run;
 
*** or equivalently, use IS NULL;
proc print data=makemissing;
    where initial is null and newage is not null;
run;

This may be especially useful in a macro that takes mixed-type variables as parameters in a where clause;

....see also

....see also

....in the 96 SUGI Proceedings see also


Submitted By Otterm1