SAS Tip: Convert MISSING to 0

SAS_Tipster — Fri, 06 Jul 2018 14:07:08 GMT

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 ';

Originally posted by Terry on sasCommunity.org.

Re: SAS Tip: Convert MISSING to 0

Ksharp — Fri, 06 Jul 2018 14:38:19 GMT

proc stdize data=sashelp.class out=want missing=0 reponly;
var weight;
run;

topic Re: SAS Tip: Convert MISSING to 0 in SAS Tips from the Community

SAS Tip: Convert MISSING to 0

Re: SAS Tip: Convert MISSING to 0