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.
Tip of the Day:May 26
sasCommunity Tip of the Day
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 May 26 (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)
*** 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;
Submitted By Otterm1
Feel free to comment on this tip.