delete the same rows in the database

[France]

dear all,

how could i delete the same observation in the data set?

for example 

name, 20001, 200002
aaa,1,1
aaa,1,1
aaa,1,2
bbb,1,2

how do I only keep one 'aaa,1,1' in the dataset and get the following data

name, 20001, 200002
aaa,1,1
aaa,1,2
bbb,1,2

Could you please give me some suggestion?

many thanks in advance.

[novinosrin · Accepted solution]

proc sql;

select distinct *

from have;

quit;