topic Re: removal of duplicate and original records in datasets in New SAS User

removal of duplicate and original records in datasets

rajeshm — Thu, 20 Aug 2020 12:43:39 GMT

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

my output should contain only 3.

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

novinosrin — Thu, 20 Aug 2020 12:46:10 GMT

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

PeterClemmensen — Thu, 20 Aug 2020 12:47:00 GMT

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 — Thu, 20 Aug 2020 15:08:07 GMT

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

1 3

1 2

3 2

rajeshm — Thu, 20 Aug 2020 15:29:22 GMT

Thanks a lot for quick solution.