delete the same rows in the database

France — Tue, 11 Sep 2018 20:30:39 GMT

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.

Re: delete the same rows in the database

novinosrin — Tue, 11 Sep 2018 20:34:53 GMT

proc sql;

select distinct *

from have;

quit;