Window Functions

[BrahmanandaRao]

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

[Kurt_Bremser]

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

[LinusH]

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#com...

[Ksharp]

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

[jackyboris]

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

[LinusH]

What you can do @jackyboris:

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