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
Revision as of 22:08, 22 April 2014 by Frankfry (Talk | contribs)

Jump to: navigation, search

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