topic Re: Window Functions in SAS Programming

Window Functions

BrahmanandaRao — Mon, 14 Feb 2022 08:20:03 GMT

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()

Re: Window Functions

Kurt_Bremser — Mon, 14 Feb 2022 08:25:44 GMT

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).

Re: Window Functions

LinusH — Mon, 14 Feb 2022 09:08:21 GMT

If you are in need for such functions, please chime in with (Like!) this Ballot:

https://communities.sas.com/t5/SASware-Ballot-Ideas/Add-window-functions-in-SAS-SQL/idi-p/462556#comments

Re: Window Functions

Ksharp — Mon, 14 Feb 2022 13:58:46 GMT

These are all ORACEL function, but NOT available in PROC SQL.
You can use these functions in Data Step or PROC RANK

Re: Window Functions

jackyboris — Tue, 16 Aug 2022 10:13:22 GMT

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??

Re: Window Functions

LinusH — Tue, 16 Aug 2022 10:17:05 GMT

What you can do @jackyboris:

vote for the ballot (link above)
contact your SAS representative to give this feedback.