This is the question.    data Totalsales; input name $quote20. @; s1 = substr(name,1,1); If ('A' <= s1 <= 'Z') then do; datalines; "David Wong" 1/Aug/2023 13200 "Brian Leung" 15/Sep/2023 23450 10/Sep/2023 33000 "Mary Chan" 3/Jul/2023 45600 20/Aug/2023 37800 1/Dec/2023 21500 30/Aug/2023 42000 "John Tam" 12/Sep/2023 35000 ; run; I am going on this direction but im stuck. ... View more

thx for your distribution. But the output should be one observation per person.    The output should be:   I am attempting this direction but its stuck rn. data Totalsales; input name $quote20. @; s1 = substr(name,1,1); If ('A' <= s1 <= 'Z') then do; if _n_ ^=1 then do; datalines; "David Wong" 1/Aug/2023 13200 "Brian Leung" 15/Sep/2023 23450 10/Sep/2023 33000 "Mary Chan" 3/Jul/2023 45600 20/Aug/2023 37800 1/Dec/2023 21500 30/Aug/2023 42000 "John Tam" 12/Sep/2023 35000 ; run;       ... View more

Thx for ur reply. It is an assignment from my school so I guess this is the challenging part. ... View more

sorry for the misleading. My aim is to develop a data step to generate the output (provided in the question). I have worked part of it (Can see in the comment section) but I was totally struggled. ... View more

The dataset is relevant to the output.   The logic is firstly record the name of the customer, then count how many sales were made by the customer (can be by the number of date or number of sales made). Finally, compute the days between last sales and 31 Dec 2023.   Below are the code im trying but seems not work: data Totalsales; input name $quote20. @; format var1 date11.;   s1 = substr(name,1,1);   If ('A' <= s1 <= 'Z') then do; if _n_ ^=1 then output; input var1  sales; end;   if endfile=1 then output;     datalines; "David Wong" 1/Aug/2023 13200 "Brian Leung" 15/Sep/2023 23450 10/Sep/2023 33000 "Mary Chan" 3/Jul/2023 45600 20/Aug/2023 37800 1/Dec/2023 21500 30/Aug/2023 42000 "John Tam" 12/Sep/2023 35000 ; run; ... View more

Thanks for ur reply! This was the simplified output above. The full output should be like this:   (i think i can handle the case regarding to dates so i didnt include it  on my question!) Thanks so much.   ... View more