General SAS Question

[robertrao]

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

[Tom · Accepted solution]

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