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
What is it about the documentation that you don't understand?
What is it about the documentation that you don't understand?
Thank you for sharing this article. It is very clear and explained so well.
Kind regards,
Magstar
@Timbim - good to hear! Personally I find this function very useful.
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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.