topic Re: Coalesce in Proc Sql in SAS Programming

Coalesce in Proc Sql

Timbim — Tue, 09 Oct 2018 05:40:32 GMT

Hi Community,

I am need your help understanding this within a proc sql step. Have never used coalesce function.

coalesce(t.amt_increase,r.loanamtchg) as amt_increase,

coalesce(t.pct_increase,r.loanamtchg/r.loanamount) as pct_increase

Thanks kindly for your help.

Magstar

SASKiwi — Tue, 09 Oct 2018 06:06:40 GMT

What is it about the documentation that you don't understand?

Timbim — Fri, 19 Oct 2018 00:09:26 GMT

Thank you for sharing this article. It is very clear and explained so well.

Kind regards,

Magstar

SASKiwi — Fri, 19 Oct 2018 00:14:35 GMT

@Timbim - good to hear! Personally I find this function very useful.

Timbim — Fri, 19 Oct 2018 00:16:36 GMT

Would you normally use in place of joins? It is the first time I've come across this. I am not an expert in coding but want to be one.