Help using Base SAS procedures

General SAS Question

Accepted Solution Solved
Reply
Super Contributor
Posts: 1,041
Accepted Solution

General SAS Question

Hi,

I have a dataset(1) and want only the duplicates by MRN to output into another dataset(2)

so that I want to look at those MRN with  multiple records very closely....

Thanks

Dataset1(HAVE)

MRN

101   

101

102

103

104

104

104

Dataset2(WANT)

101

101

104

104

104


Accepted Solutions
Solution
‎05-18-2013 12:02 PM
Super User
Super User
Posts: 7,042

Re: General SAS Question

Posted in reply to robertrao

data want; set have; by mrn; if not (first.mrn and last.mrn); run;

View solution in original post


All Replies
Solution
‎05-18-2013 12:02 PM
Super User
Super User
Posts: 7,042

Re: General SAS Question

Posted in reply to robertrao

data want; set have; by mrn; if not (first.mrn and last.mrn); run;

🔒 This topic is solved and locked.

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

Discussion stats
  • 1 reply
  • 172 views
  • 0 likes
  • 2 in conversation