I am running this below code in SAS using ROW_NUMBER() function but it's not working throwing below

[MuraliK]

48 (SELECT s.shp_trk_nbr as trk_nbr,st.scan_type_acrnm,
49 s.scan_type_cd ||coalesce(s.excp_type_cd, '') as ScanexcpCd,
50 v.svc_commit_tmstp,
51 s.scan_trk_tmstp as scan_tm,
52 opnl_scan_loc_cd as Scan_loc_cd,
53
2 The SAS System 15:39 Thursday, October 25, 2018

54 row_number() over(partition by s.shp_trk_nbr order by s.scan_trk_tmstp desc) as ScantimeRank,
____
22
76
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN,
CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

Can some one help me to find out which function to use in SAS instead of ROW_NUMBER  OVER PARTITION .

[ballardw]

---

@MuraliK wrote:

48 (SELECT s.shp_trk_nbr as trk_nbr,st.scan_type_acrnm,
49 s.scan_type_cd ||coalesce(s.excp_type_cd, '') as ScanexcpCd,
50 v.svc_commit_tmstp,
51 s.scan_trk_tmstp as scan_tm,
52 opnl_scan_loc_cd as Scan_loc_cd,
53
2 The SAS System 15:39 Thursday, October 25, 2018

54 row_number() over(partition by s.shp_trk_nbr order by s.scan_trk_tmstp desc) as ScantimeRank,
____
22
76
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN,
CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

Can some one help me to find out which function to use in SAS instead of ROW_NUMBER  OVER PARTITION .

---

What does ROW_NUMBER  OVER PARTITION do? OVER and PARTITION are also not part of SAS ANSI standard Proc SQL

If this is supposed to add some sort of RANK perhaps combine the data you are doing and use PROC RANK to add ranks based on some rules. But would have to know what the rules are.