topic Re: SQL ISnull in SAS in SAS Enterprise Guide

SQL ISnull in SAS

yudhishtirb — Mon, 29 Aug 2016 13:49:37 GMT

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

Re: SQL ISnull in SAS

Reeza — Mon, 29 Aug 2016 14:04:29 GMT

Try Coalesce function.

Re: SQL ISnull in SAS

PGStats — Mon, 29 Aug 2016 17:40:35 GMT

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