As the first step in the decommissioning of 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

From sasCommunity
Revision as of 20:18, 13 May 2011 by Frankfry (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

sasCommunity Tip of the Day

As part of the decommissioning effort for this article/tip has been migrated to

The new home for this article/tip is May 26 (

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;
*** use missing;
proc print data=makemissing;
    where initial is missing and newage is not missing;
*** or equivalently, use IS NULL;
proc print data=makemissing;
    where initial is null and newage is not null;

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