topic Are numeric missing values... in SAS Programming

Are numeric missing values...

edasdfasdfasdfa — Tue, 10 Dec 2019 19:39:58 GMT

naturally treated as 0's?

Re: Are numeric missing values...

PeterClemmensen — Tue, 10 Dec 2019 19:43:40 GMT

No. Missing values are treated as less than any number you think of in SAS. Including zero.

Re: Are numeric missing values...

novinosrin — Tue, 10 Dec 2019 19:45:52 GMT

Hi @edasdfasdfasdfa For all I know,0 isn't missing. Missing values are valid values that does not have a value in other words a blank value.

Using operator(arithmetic) propagates missing values while functions ignore missing values.

Re: Are numeric missing values...

edasdfasdfasdfa — Tue, 10 Dec 2019 19:46:32 GMT

haha. thanks for the laugh!

Re: Are numeric missing values...

edasdfasdfasdfa — Tue, 10 Dec 2019 19:48:04 GMT

Thanks, Novinorsin.
No doubt that missing values might be valuable and are not the same as 0's..but how we would go about setting numeric missing to zero? I was wondering if this was the default behavior?

Re: Are numeric missing values...

novinosrin — Tue, 10 Dec 2019 19:51:15 GMT

"I was wondering if this was the default behavior?"-- No default is just plain missing as-is

"but how we would go about setting numeric missing to zero?"

Do you mean this? options missing=0;


options missing=0;

data w;
k=.;
run;

@edasdfasdfasdfa wrote:
Thanks, Novinorsin.
No doubt that missing values might be valuable and are not the same as 0's..but how we would go about setting numeric missing to zero? I was wondering if this was the default behavior?

Re: Are numeric missing values...

edasdfasdfasdfa — Tue, 10 Dec 2019 19:55:01 GMT

Using operator(arithmetic) propagates missing values while functions ignore missing values.

What if you use a function with an operator?

Ie sum(of var1-var9) ?

Re: Are numeric missing values...

novinosrin — Tue, 10 Dec 2019 19:59:23 GMT

should your operands(variable values) are all missing, of course you would get the result as missing too, otherwise, the propagation of missing values doesn't occur when you use functions. For example,

options missing=0;

data w;
k=sum(.,.,.,.,20);
k1=sum(.,.,.,.,.,.);
k2=.+.+.+20;
run;

options missing=.;

data w;
k=sum(.,.,.,.,20);
k1=sum(.,.,.,.,.,.);
k2=.+.+.+20;
run;

Re: Are numeric missing values...

Tom — Tue, 10 Dec 2019 20:03:32 GMT

@edasdfasdfasdfa wrote:

naturally treated as 0's?

No they are treated naturally as missing. So depending on what you are doing the result is what your would normally expect.

So simple operators, like +-*/, will generate a missing values as a result of operating on one or more missing values.

But more complex operations like MIN(), MAX(), SUM(), MEAN() will work appropriately. So if your data values are

1 . 2 3 4

The SUM() will be 10, but the MEAN() will be 10/4 = 2.5 and NOT 10/5=2 since the missing values does not contribute.

Re: Are numeric missing values...

seeff — Tue, 10 Dec 2019 21:57:21 GMT

You've gotten many responses about the behavior of missing values, but it sounds like you're asking how to set numeric missing to zero. Perhaps this previous post is what you're looking for:

https://communities.sas.com/t5/SAS-Procedures/How-to-set-all-missing-values-to-zero-for-all-variables/td-p/41478