- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 02-14-2022 03:20 AM
(2879 views)
Hi Guys
These following function can work(use) in proc sql
- Ranking Window Functions
RANK(), DENSE_RANK(), ROW_NUMBER(), NTILE() - Value Window Functions
LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE()
5 REPLIES 5
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
If you are in need for such functions, please chime in with (Like!) this Ballot:
Data never sleeps
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
These are all ORACEL function, but NOT available in PROC SQL.
You can use these functions in Data Step or PROC RANK
You can use these functions in Data Step or PROC RANK
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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??
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
What you can do @jackyboris:
- vote for the ballot (link above)
- contact your SAS representative to give this feedback.
Data never sleeps