Sascommunity Tips RSS

From sasCommunity
Jump to: navigation, search

<newsfeed limit="1" notalk nominor postfix prefix permalink>

sasCommunity Tip of the Day

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;


Submitted By Otterm1



Feel free to comment on this tip.


Prior tip - Next tip -- Random Tip

Submit a Tip


Visit sasCommunity.org to view or sumbit more Tips </newsfeed>