syntax error in sas programming

[Akshaya_1397]

PROC SQL;
CREATE TABLE FIN AS
SELECT *,
RANK() OVER(partition by rel_number order by exception_reason)as rn
from test;
quit;


can anyone please helpme what is the syntax error in the above code.
i got a error message as

[AMSAS]

The following links should help:

SQL Procedure Components 
SAS BASE - how can i perform Over Partition 

[Tom · Accepted solution]

RANK and OVER are not part of the ANSI SQL standard that PROC SQL implements.

And it is not needed since you can just do it with a data step.

data fin;
  set test;
  by rel_number expection_reason;
  rn+1;
  if first.rel_number then rn=1;
run;