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 .