Help using Base SAS procedures

delete observation

Accepted Solution Solved
Reply
Contributor
Posts: 36
Accepted Solution

delete observation

I have a data set like this :

 

NAME               SURNAME
RAYNALD         ALEXANDRE
RAYNALD        ALEXANDRE
RAYNALD        ALEXANDRE

ALICE              ANDRE

ALICE              ANDRE

GERALDINE    ANDRE

 

How can I get some thing like this ?  :

NAME               SURNAME
RAYNALD         ALEXANDRE

ALICE              ANDRE

GERALDINE    ANDRE


Accepted Solutions
Solution
‎04-14-2017 07:46 AM
Trusted Advisor
Posts: 1,137

Re: delete observation

proc sort data=have out=want nodupkey;
by name surname;
run;
Thanks,
Jag

View solution in original post


All Replies
Solution
‎04-14-2017 07:46 AM
Trusted Advisor
Posts: 1,137

Re: delete observation

proc sort data=have out=want nodupkey;
by name surname;
run;
Thanks,
Jag
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 142 views
  • 2 likes
  • 2 in conversation