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.