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
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;