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

MuraliK — Thu, 25 Oct 2018 22:20:21 GMT

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 .

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

ballardw — Fri, 26 Oct 2018 16:20:10 GMT

@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.

topic Re: I am running this below code in SAS using ROW_NUMBER() function but it's not working throwing be in New SAS User

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

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