What is the equivalent to row_number()

Patricio_22582

Hello,

I've noticed that row_number() does not exist in Workbench?  I tried the following:

proc sql;
create table cn_servicelevel as

select distinct
RegardingNoticeName
,CreatedOn
,CreatedOn format=datetime16. as CreatedOnF
,Name
,row_number() over (partition by RegardingNoticeName order by CreatedOn asc) as rn
,case when Name like '%Resubmitted' then 1 end as test
from
Table

;quit;

But an error: The function "row_number" is not known

Is there an equivalent to row_number()?

Thanks,

Patricio

Nico Chart_21517

Hi Patricio,

I'm sure there's a way to do this! I'm creating a support ticket to make sure we answer you properly.

Best Regards,

Nico