Creating a counter in PROC SQL

[greg6363]

I'm trying to create a counter column in my PROC
SQL query with the following code:

ROW_NUMBER OVER(PARTITION BY CKey ORDER BY Date) -1 AS Counter

Unfortunately, the log generates a syntax error at the ( between the R
and the P saying "expecting one of the following: ' , ' , JOIN

What am I missing here? Any assistance would be greatly appreciated.

Thanks.

 

[bryangoodrich]

PROC SQL doesn't support windowing functions.

Typically you rank number because you want to filter by something in that ranking. There are SAS methods to replicate that behavior (sort and then filter) as shown here:

https://stackoverflow.com/questions...as-similar-like-row-number-function-in-oracle