Advanced Search

Return to Snippet

Revision: 39903
at January 22, 2011 10:20 by webonomic
Initial Code 
/*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:*/

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 ';
Initial URL 
http://www.sascommunity.org/wiki/Tip_of_the_Day:November_25
Initial Description 

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Store a zero value in place of missing when reporting numeric values

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SAS