@Reinhard That’s why I didn’t post any detail regarding the assignment. I put my code here in my last post because I had been working for many hours and I was almost done. It was about the timing of using an output statement and thanks some of you for pointing out the problem of my code. This time the same I didn’t want to ask for the answer directly but you think I did i’m sorry. I have no friends in this class so I have no idea about what they did before sorry for annoying you. I’ll ask the the same thing to my prof too if it is not weekend so indeed I don’t care whether my prof is following this post or not. Thanks for your reply tho. ... View more

Sorry guys, I don't want to enclose too much detail (e.g. my codes) as I found some of my classmates are asking for the same question too. I know this looks stupid. I'm going to find out the solution myself. Thanks for all replies! Have a nice day! ... View more

set statement is totally fine and I understand it is the easiest way but I'm actually doing an assignment and we're told to solve this by using if-then, retain, output statement etc. Thanks tho! ... View more

Thanks for your reply it works but can we make it without using proc sort and set statement? ... View more

Thank you for the explanation! It helps a lot 🙂 ... View more

Thank you for the explanation! Have a nice day 🙂 ... View more

Thanks all !!!  ... View more