How to remove duplicate observation through only datastep?

[Tushar]

Hi All,

want to remove duplicate observation from data set only in data  step not using any proc not even proc SQL, can we do that?

can first. and last, variable will help in this case? any other way please let me know.

[Reeza]

How are you defining a "DUPLICATE" and how many variables?

And why...

[Tushar]

Duplicate like below one suppose Test is my dataset then

id    Name  address

===============

1     xyz       St  stef road

1     xyz       St  stef road

2     abc       St  josef raod

2     abc       St  josef road

3     pqr        mery road

now all i want to remove duplicare rows like id 1 and 2 and want to keep only single one.. like

id    Name  address

===============

1     xyz       St  stef road

2     abc       St  josef raod

3     pqr        mery road

[Reeza]

Use a hash table:

How to remove duplicated records\observations WITHOUT sorting in SAS？ - Stack Overflow