I have a file in which for each borrower there are different segments like AS,BS,GS,RS. Due to business requirement i need to split all the AS into 1 file from main file so on for each segments before loading the same in SAS. But there is no Common key by which i can merge all the segments for one particular borrower. So need help in creating a code in SAS by which i can assign a unique index no to all segments for each borrower so that can merge/join them later. eg: index_no | borrower_name | Segments 1 abc BS 1 pqr GS 1 hcbj RS 2 yet BS i.e it should assign the same index no till it finds the next BS in the file
... View more