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.
Tip of the Day:March 22
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 March 22 (https://communities.sas.com/t5/SAS-Tips-from-the-Community/SAS-Tip-Convert-MISSING-to-0/m-p/476013#M189)
COST = SUM(COST, 0);
The SUM function ignores missing values. So if COST is not missing, no change occurs. If COST is missing, it is now 0.
If only the display of missing values as 0 as needed, use the options statement (which does not change the internal value):
options missing = '0 ';
Submitted by Terry. Contact me at my Discussion Page.
Feel free to comment on this tip.