Never mind, I added firstob=2 in my infile statement and it works. Thanks again for your detail explanation! ... View more

Much appreciated for the thorough explanation! But when I try to run the program, however, the output is as follows:                     How can I get rid of the first line from the data set and replace it with the person "David Wong" instead? ... View more

Thanks for the suggestion! And to answer your curiosity, the author and I should be mates if I'm not mistaken.      Anyway, for the output table, is there any methods to rearrange the order so that it looks the same as shown in the requirements above? ... View more

But even after running this program, I still have multiple observations for each person. How can my output shows only one name; one Latest_Sales_Date number that is the largest among others; and one Total_Sales sum of all the associated sales amount; for each respective salesperson?   data Sales_Total ; infile datalines firstobs=2 ; length Dummy Name $15 Latest_Sales_Date Total_Sales 8; input dummy $15. Latest_Sales_Date date11. Total_Sales ; retain name; name=coalescec(dummy,name); drop dummy; datalines; 1234567890123456789012345678901234567890 David Wong     1/Aug/2018  13200 Brian Leung    15/Sep/2018 23450                10/Sep/2018 33000 Mary Chan      3/Jul/2018  45600                20/Aug/2018 37800                1/Sep/2018  21500                30/Aug/2018 42000 John Tam       12/Sep/2018 35000 run;         ... View more

Greetings all,   I am trying to read a data set into the following table.                       When I try to run my program, however, the Name column contains more than one observation for each person. What can I do to make the output contains only one name for each person? And the same goes for the date column, how can I only select the most recent date to show in my output table? Here is what I have so far.   data Sales_Total ; infile datalines firstobs=2 ; length Dummy Name $15 Latest_Sales_Date Total_Sales 8; input dummy $15. Latest_Sales_Date date11. Total_Sales ; retain name; name=coalescec(dummy,name); drop dummy; datalines; 1234567890123456789012345678901234567890 David Wong     1/Aug/2018  13200 Brian Leung    15/Sep/2018 23450                10/Sep/2018 33000 Mary Chan      3/Jul/2018  45600                20/Aug/2018 37800                1/Sep/2018  21500                30/Aug/2018 42000 John Tam       12/Sep/2018 35000 run; ... View more

The condition is that I must use only one datastep ... View more

Well the output shows several observations for each person. What if I only want one observation for each salesperson, with their most recent sales date and sum of total sales instead? ... View more

This data is stored as a .txt file ... View more