in() and = operator

[deleted_user]

I am using following condition

if li_date ne 0 and ((logging_date - datejul(li_date)) <= 180) and (NEGAUTH_STAT_CD in ('LI') or NEGAUTH_REM1_STAT_CD in ('LI'))

I am getting error in datejul(li_date) function as few values of li_date = 0, i used li_date ne 0 to avoid this condition but error is keep comming.

when I changed NEGAUTH_STAT_CD in ('LI') to NEGAUTH_STAT_CD ='LI' , code works fine.

Could anyone explain, why in() operator shows error and = opertor doen't.

[LinusH]

You may want to try to post your full code and question again. You might have a problem with this:

http://support.sas.com/forums/thread.jspa?messageID=15090㫲


Regards,
Linus