That worked perfectly, thank you.  I now need to isolate the last applications for each customer for each store.  I have de duped by last.app_id but that only gives me one record per customer.  If the customer applied at 4 stores, I want to keep the last application entered (these are numerical) for each customer by store.  If the customer went to 1 store, they would have 1 record, 4 stores 4 records etc.   I am trying to sort by store name ascending application numb er, then take the last ssn for each store but am not getting success.. ... View more

All of the data is in one dataset.  There is a column for Store_ID and another for SSN.  There are many dupllicates for both of these variables and I am trying to find the ssn's that are common in more than one store.   There is a unique record for each credit application that a customer fills out.  I want to see how many stores they apply to.  I de-duped by SSN and took the last record but that only gave me the store they applied for on the last application. ... View more