Tip of the Day
sasCommunity Tip of the Day
I often need to store a 0 value in place of missing when reporting numeric values. I take advantage of the SUM function for this purpose. For each variable I sum itself with 0 as in:
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.
Tips Index by Status
The Tip of the Day Project
A new technical Tip of the Day related to SAS software will be shown on this page and the sasCommunity.org main page every day. Before getting started, you can Browse and Search the current list of tips contributed by users.
Anyone can participate. We hope you do! Here's how:
- Submit a Tip by posting a SAS tip that you think others might find useful
- Review a Tip prior to publishing