Desktop productivity for business analysts and programmers

SQL ISnull in SAS

Reply
Contributor
Posts: 25

SQL ISnull in SAS

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

 

Grand Advisor
Posts: 17,355

Re: SQL ISnull in SAS

Try Coalesce function. 

Respected Advisor
Posts: 4,608

Re: SQL ISnull in SAS

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

PG
Ask a Question
Discussion stats
  • 2 replies
  • 1073 views
  • 2 likes
  • 3 in conversation