Coalesce in Proc Sql

[Timbim]

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 · Accepted solution]

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

https://documentation.sas.com/?docsetId=sqlproc&docsetTarget=p1gdr5t7sd3g3qn1d7fg23zuwzml.htm&docset...

[Timbim]

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

Kind regards,

Magstar

[SASKiwi]

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

[Timbim]

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.