topic Re: syntax error in sas programming in SAS Programming

syntax error in sas programming

Akshaya_1397 — Mon, 03 Jul 2023 15:33:19 GMT

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

Re: syntax error in sas programming

AMSAS — Mon, 03 Jul 2023 16:32:20 GMT

The following links should help:

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

Re: syntax error in sas programming

Tom — Mon, 03 Jul 2023 16:57:03 GMT

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;