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 Talk:Convert MISSING to 0

From sasCommunity
Jump to: navigation, search

Good tip. I added the templates back for submitted by and a link to an existing article that has more detail. Also added mention of alternative to use options missing = --Don Henderson 09:28, 14 March 2009 (EDT)


looks good to me. --Statprof 07:54, 15 March 2009 (EDT)


Corrected username, addred category, Tip Ready --Nancy 05:26, 16 March 2009 (EDT)


I thought that is what COALESCE() is for. - Peter.Crawford, 24 March 2016‎

I also like coalesce [1], but see where you might just want to display something (perhaps 'missing' or 'NA') for missing values. Coalesce can also be used to combine rows where one may be missing where the other is not. [2] - paulkaefer (talk) 09:07, 11 July 2016 (CDT)