Add sequence number to duplicates to form a primary key sql sas r python multi language %let pgm=utl-add-sequence-number-to-duplicates-to-form-a-primary-key-sql-sas-r-python-multi-language; ...

Now we need to add a sequence number column Seq for the group. When a new event occurs for an account within one hour, Seq+1; If a new event occurs after one hour, reset Seq to 1.