Hello to all, hope you are doing well. I have a database TEST that has 5 columns. Here is an example: ID_Customer ID_Project ID_Application Nbre_Application Creation_Application 200200 1000 267 1 20JANV2020 200200 1000 256 1 10JANV2020 200200 1000 456 1 15JANV2020 400400 2000 120 2 10FEB2020 400400 2000 101 1 05JANV2020 For each client, I would like to classify his applications, from the oldest to the most recent with the number 1 for the oldest, 2 for the most recent... Like this : ID_Customer ID_Project ID_Application Nbre_Application Creation_Application 200200 1000 256 1 1 200200 1000 456 1 2 200200 1000 267 1 3 400400 2000 101 1 1 400400 2000 120 2 2 I know there's a proc rank procedure but here how can I use it ? And is there a way with proc sql ? Thank you !
... View more
