I'm having data like this, Subject_ID Test_Name Start_Date End_Date 123 ABC 123 ABC 123 ABC 123 XYZ 124 ABC 124 ABC 124 XYZ and respective dates for those ID's, I want to create one more Variable ROWID for above dataset which will have sequential count for every Subject_ID and Test_Name. It should be depends on both these variables. Like an example: If there is a first test ABC for subject 123 then ROWID will '1' and for next test ABC for same subject 123 ROWID will '2' but if Test is ABC and subject is 124 then it should start from '1'. Output like below: ROWID 1 2 3 1 1 2 1
... View more