topic Re: division by ZERO in SAS Programming

division by ZERO

deleted_user — Tue, 09 Dec 2008 15:52:02 GMT

hi,
i used the new IFC function to avoid division by 0, but it seems it does not work:
data test;
input a b ;
l=ifn(b=0 , 0 , a/B ) ;
cards;
10 2
10 5
8 0
8 4
;
run;

reason ????

Re: division by ZERO

deleted_user — Tue, 09 Dec 2008 15:52:59 GMT

i mean IFN function of course

Re: division by ZERO

KevinQin — Wed, 10 Dec 2008 07:43:04 GMT

Not like IF/THEN/ELSE, IFN calculate 'a/b' in advance, then judge the logical statement 'b=0'. 🙂

Re: division by ZERO

Cynthia_sas — Wed, 10 Dec 2008 15:45:43 GMT

Hi:
Also, using the DIVIDE function
http://support.sas.com/kb/19/965.html

does not produce the "divide by zero" message that you get when you code your division this way divide(a,b) versus a/b

cynthia