topic Re: IFN in SAS Studio

IFN

Wken1122 — Tue, 14 Nov 2017 01:57:04 GMT

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.

Re: IFN

Reeza — Tue, 14 Nov 2017 02:04:39 GMT

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&docsetVersion=9.4&locale=en

@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.

Re: IFN

Wken1122 — Tue, 14 Nov 2017 03:03:29 GMT

Thanks a lot for the clarification!