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.


User:LainieH/sandbox10/main

From sasCommunity
Jump to: navigation, search


MOCKUP FOR POTENTIAL DESIGN CHANGE.. BRAINSTORMING ONLY

Welcome to sasCommunity.org

A collaborative online community for SAS® users worldwide.

sasCommunity.org is an ongoing global community effort—created by SAS users for SAS users. This site is a place to find answers, share technical knowledge, collaborate on ideas and connect with others in the worldwide SAS Community. Get started now by creating a UserID.

Follow Us
For daily SAS Tips, Web updates & more.


DAILY UPDATES

sasCommunity Blogs

Recent SAS user blog entries:

...view more

sasCommunity Content

Recent sasCommunity.org articles:

...view more
...create an article

run;submit Questions:

Top SAS user questions on RunSubmit.com:

...view more

SAS Discussion Forums

Top SAS user threads on support.sas.com:

...view more


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 LainieH/sandbox10/main (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.




Check out the Tip of the Day page for details about this effort.

Featured Members

imagine modified list with just image and name Recent contributors appear at top of the list. Opt in to appear on list.



9,514 UserIds have been created on sasCommunity.org!
View the Web-site usage statistics and the definition of terms.


Join sasCommunity.org Get Involved Sasopedia Events User Groups