Hi Guys
These following function can work(use) in proc sql
And what is your question?
If you want to know where and how a function works, read up on its documentation (looking into the documentation will also reveal functions that are not available in SAS in the first place).
If you are in need for such functions, please chime in with (Like!) this Ballot:
Honestly, people had been asking window functions more than a decade ago, and yet we still don't freaking have some common functions. Is there a legit reason why SAS does not add new features for its users??
What you can do @jackyboris:
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.