morinia
asked on
Numbering records with same client number - SAS
Experts,
I have an Excel file that has a client_number and start_date end_date residual_start residual_end.
I would like to number the records if they have the same client_number so I can do an edit on the dates to ensure there is no overlapping.
Can someone tell me how to number the records in SAS? I woule like to program to get the number which is currently in record_number.
See attached example.
Numbering-Sample.xlsx
I have an Excel file that has a client_number and start_date end_date residual_start residual_end.
I would like to number the records if they have the same client_number so I can do an edit on the dates to ensure there is no overlapping.
Can someone tell me how to number the records in SAS? I woule like to program to get the number which is currently in record_number.
See attached example.
Numbering-Sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.