https://communities.sas.com/t5/SAS-Programming/in-and-operator/m-p/60785#M13204 I am using following condition<BR /> <BR /> if li_date ne 0 and ((logging_date - datejul(li_date)) &lt;= 180) and (NEGAUTH_STAT_CD in ('LI') or NEGAUTH_REM1_STAT_CD in ('LI'))<BR /> <BR /> 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.<BR /> <BR /> when I changed NEGAUTH_STAT_CD in ('LI') to NEGAUTH_STAT_CD ='LI' , code works fine.<BR /> <BR /> Could anyone explain, why in() operator shows error and = opertor doen't. Tue, 11 Nov 2008 13:37:43 GMT deleted_user 2008-11-11T13:37:43Z https://communities.sas.com/t5/SAS-Programming/in-and-operator/m-p/60785#M13204 I am using following condition<BR /> <BR /> if li_date ne 0 and ((logging_date - datejul(li_date)) &lt;= 180) and (NEGAUTH_STAT_CD in ('LI') or NEGAUTH_REM1_STAT_CD in ('LI'))<BR /> <BR /> 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.<BR /> <BR /> when I changed NEGAUTH_STAT_CD in ('LI') to NEGAUTH_STAT_CD ='LI' , code works fine.<BR /> <BR /> Could anyone explain, why in() operator shows error and = opertor doen't. Tue, 11 Nov 2008 13:37:43 GMT https://communities.sas.com/t5/SAS-Programming/in-and-operator/m-p/60785#M13204 deleted_user 2008-11-11T13:37:43Z https://communities.sas.com/t5/SAS-Programming/in-and-operator/m-p/60786#M13205 You may want to try to post your full code and question again. You might have a problem with this:<BR /> <BR /> <A href="http://support.sas.com/forums/thread.jspa?messageID=15090㫲" target="_blank">http://support.sas.com/forums/thread.jspa?messageID=15090㫲</A><BR /> <BR /> <BR /> Regards,<BR /> Linus Tue, 11 Nov 2008 15:28:21 GMT https://communities.sas.com/t5/SAS-Programming/in-and-operator/m-p/60786#M13205 LinusH 2008-11-11T15:28:21Z