08-29-2016 09:49 AM
I am just looking to use SQL ISNULL in SAS as below
select ISNULL(b.szMagicColumn6,0) as TotalArrears
from db.MagicData b, db.Master a
where a.wclientcode=b.wclientcode and a.szAccountNumber= b.szAccountNumber
and b.wclientcode in (-100);
But getting following error as
ERROR: Function ISNULL could not be located.
Can you please assist me here ?
Thanks In Advance