removal of duplicate and original records in datasets

[rajeshm]

I would like to remove original and duplicates from that dataset. so finally i will get unique records .

1

2

1

2

3

my output should contain only 3. 

Note : i mentioned only one column but i have several columns. please someone help me on this

[novinosrin · Accepted solution]

proc sql;
 create table uniques as
 select *
 from your_table
 group by id_variable
 having count(id_variable)=1;
quit;

[rajeshm]

Thanks a lot for quick  solution.

[PeterClemmensen]

What is the logic when you more than one variable? What if your dataset looks like this?

data have;
input x y;
datalines;
1 3
2 1
1 2
2 1
3 2
;

[rajeshm]

Output should be like this (records should be deleted 2 1 )

1  3

1  2

3  2

1 3
2 1
1 2
2 1
3 2