Deleting the duplicate observations for unique ID

danwarags — Fri, 20 May 2016 18:19:32 GMT

Hello Everyone,

I have a sample dataset as shown below. Each ID has different dates. I want to get an output which satisfies two conditions.

1. Keeping only the IDs which have atleast two dates.

2. Deleting the dulpicate dates for each ID.

So, when the above conditions are met, My output should look like below.

Please guide me in coding this.

Thank you

Re: Deleting the duplicate observations for unique ID

Reeza — Fri, 20 May 2016 18:34:43 GMT

Look at proc sort

For 1 you need NOUNIQRECS option

For 2 you need NODUPKEY option.

You on should probably apply your second criteria first.