06-12-2014 12:54 AM
I need some help with a code to delete the first row using unique ID, this is my data
I want to delete the rows marked in red, that is the first row of each unique ID, any ideas?
06-12-2014 01:40 AM
You have to sort and use a by statement before using if then delete. it should work just check for them still if you are facing problem please present the full code so that we can help. The statement you have mentioned above is fine.
06-12-2014 01:46 AM
i have done the sorting, it says "Variable FIRST.id is uninitialized" . I have a very simple code,
DATA data_1 ;
IF first.id then delete;
Need further help from the community? Please ask a new question.