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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.