DATA Step, Macro, Functions and more

Window functions in PROC SQL?

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 91
Accepted Solution

Window functions in PROC SQL?

Just trying to take the first of a group.  In SQL I use window functions.  Any equivalent in PROC SQL?


Accepted Solutions
Solution
‎11-14-2017 03:36 PM
Super User
Posts: 23,244

Re: Window functions in PROC SQL?

Posted in reply to tomcmacdonald

No, there are other methods to accomplish those type of tasks in SAS. 

 

There os the monotonic() function in SQL though. 

View solution in original post


All Replies
Solution
‎11-14-2017 03:36 PM
Super User
Posts: 23,244

Re: Window functions in PROC SQL?

Posted in reply to tomcmacdonald

No, there are other methods to accomplish those type of tasks in SAS. 

 

There os the monotonic() function in SQL though. 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 310 views
  • 0 likes
  • 2 in conversation