BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sasphd
Lapis Lazuli | Level 10

 

I want to delete row if id is the same

data have;
input id name $ age $;
cards;
1 aik 26 
1 aik 29 
2 bik 23 
2 bik 23 
5 cik 30 
6 cik 28 
;
run;

 

I want this 

1 aik 26 
2 bik 23  
5 cik 30 
6 cik 2

1 ACCEPTED SOLUTION

Accepted Solutions
novinosrin
Tourmaline | Level 20

 

proc sort data=have out=want nodupkey;

by id;

run;

 

 

 

View solution in original post

1 REPLY 1
novinosrin
Tourmaline | Level 20

 

proc sort data=have out=want nodupkey;

by id;

run;

 

 

 

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →
What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1136 views
  • 1 like
  • 2 in conversation