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
proc sql;
create table uniques as
select *
from your_table
group by id_variable
having count(id_variable)=1;
quit;
proc sql;
create table uniques as
select *
from your_table
group by id_variable
having count(id_variable)=1;
quit;
Thanks a lot for quick solution.
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
;
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.