12-17-2014 08:19 PM
suppose I have the following table:
Is it possible to delete the duplicate rows for IDs 1 and 3, but the rows where there are no duplicates, like those for IDs 2 and 4, to keep them as they are?
12-17-2014 09:03 PM
I did the following including your code:
input id name$;
But I get an error message:
ERROR 180-322: BY variables not properly sorted on dataset DUP
And the result that I get is:
It seems that the duplicate was deleted for the first row, but after that the code stopped functioning
12-17-2014 09:08 PM
You need to sort dataset dup by id before performing by processing
proc sort data=dup;
then try this
Need further help from the community? Please ask a new question.