Solved: Window functions in PROC SQL? - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Quartz | Level 8

Quartz | Level 8

Window functions in PROC SQL?

Posted 11-14-2017 03:27 PM (1742 views)

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

1 ACCEPTED SOLUTION

Accepted Solutions

Super User

Super User

Re: Window functions in PROC SQL?

Posted 11-14-2017 03:34 PM (2119 views) | 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

1 REPLY 1

Super User

Super User

Re: Window functions in PROC SQL?

Posted 11-14-2017 03:34 PM (2120 views) | 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.