If you share full code will be helpful but some time if your dataset is not having set statement then your original dataset is destroyed and start over. ... View more

yes that is what I'm trying to do, thank you very much. I've got it ... View more

Have to disagree with AkilanR: only true if there are not instances of multiple rows per combination of n-1 key variables. You might want to sort all variables if you are subsequently going to process with a data step using First.key and Last.key methods. Consider the table id account customer ABC 123 JIM ABC 123 ALICE Sorting by all three variables is going to reverse the order, while sorting by only id and account may not. ... View more