SQL ISnull in SAS

[yudhishtirb]

Hello Team,

Greetings

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

[Reeza]

Try Coalesce function. 

[PGStats]

SAS hasn't implemented Magic (yet). You still have to look up the documentation.