IFN

[Wken1122]

Hi,
Can someone please explain this line of code for me?

IFN(SUM(IFHLDCURR_MRTA,IFHLDCURR_TRDL,IFHLDCURR_INVT)>0,1,0);

Does it mean that the sum of the 3, IFHLDCURR_MRTA,IFHLDCURR_TRDL,IFHLDCURR_INVT are > than 0,1,0 then it will return '1'.
Or does it mean that if sum of IFHLDCURR_MRTA>0 and sum of IFHLDCURR_TRDL>1 and sum of IFHLDCURR_INVT>0, only then it will return '1'.
or any other explanation that i misunderstood?

Thank you.

[Reeza · Accepted solution]

RTM. 

IFN(logical-expression, value-returned-when-true, value-returned-when-false
<, value-returned-when-missing>)

Logical Expression -> SUM(IFHLDCURR_MRTA,IFHLDCURR_TRDL,IFHLDCURR_INVT)>0

Value when True: 1

Value when False: 0

Value when Missing: Not declared

http://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=n0l3n5z2h31h7wn1fmnqd33ibhap.htm&...

---

@Wken1122 wrote:

Hi,
Can someone please explain this line of code for me?

IFN(SUM(IFHLDCURR_MRTA,IFHLDCURR_TRDL,IFHLDCURR_INVT)>0,1,0);

Does it mean that the sum of the 3, IFHLDCURR_MRTA,IFHLDCURR_TRDL,IFHLDCURR_INVT are > than 0,1,0 then it will return '1'.
Or does it mean that if sum of IFHLDCURR_MRTA>0 and sum of IFHLDCURR_TRDL>1 and sum of IFHLDCURR_INVT>0, only then it will return '1'.
or any other explanation that i misunderstood?

Thank you.

---

[Wken1122]

Thanks a lot for the clarification!