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 (2386 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 (2763 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 (2764 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.

744853-sas-innovate-data-ai (1).jpg

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →