I have a file of raw data(given below) and I am hoping to turn it in to the output (given below) by using a single data step. Each observation contains only the following variables: the salesperson’s name (character type of length at least 20), the salesperson’s latest sales date (in SAS DATE numeric values), the number of days (standard numeric type) between the salesperson’s latest date of sales and the 30th of September 2021 (For example, if the latest sales date is 29/Sep/2021, then the number of days between the latest date of sales and the 30th of September 2021 is 1.), and the salesperson’s total sales (standard numeric type). Raw Data: David Wong,1/Sep/2021,13200 Brian Leung,15/Sep/2021,23450 Brian Leung,10/Sep/2021,33000 Mary Chan,3/Sep/2021,45600 Mary Chan,20/Sep/2021,37800 Mary Chan,1/Aug/2021,21500 Mary Chan,30/Aug/2021,42000 John Tam,12/Sep/2021,35000 Output:
... View more