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.


Main Page Test

From sasCommunity
Jump to: navigation, search
banner_text.gif banner_image.jpg

Welcome to sasCommunity.org! - 2012 Conference Chair

icon_globe_large.gif

Requests for Applications for the SAS Global Forum 2012 Conference Chair now being accepted. Read more ...

Announcing - registration is NOW OPEN for SAS Global Forum 2009.

See the archive of prior Main Page articles.


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 Main Page Test (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;


Submitted By Otterm1



Feel free to comment on this tip.


Prior tip - Next tip -- Random Tip

Submit a Tip




Join sasCommunity.org Get Involved Sasopedia Events User Groups

View the web-site usage statistics and the definition of terms used in that report.