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 .
... View more