topic Re: Identify data dups in SAS Programming

Identify data dups

Emma2021 — Sat, 17 Jul 2021 10:33:15 GMT

I have 3 variables: name, gender, and age. If name is different I want to identify. How can I do?
Example data input data:

Gender Age Name
F 2 Patsy
F 2 Patsy
F 2 Pat
M 3 Steve

Desired output:
Gender Age Name
F 2 Pat

Thank you.

Re: Identify data dups

maguiremq — Fri, 16 Jul 2021 13:40:23 GMT

data have;
input gender $1. age 3. name :$7.;
datalines;
F 2 Patsy
F 2 Patsy
F 2 Pat
M 3 Steve
;
run;

proc sort data = have;
	by name;
run;

data want;
	set have;
	by name;
		if first.name then counter = 1;
			else counter + 1;
run;

Obs 	gender 	age 	name 	counter
1 	F 	2 	Pat 	1
2 	F 	2 	Patsy 	1
3 	F 	2 	Patsy 	2
4 	M 	3 	Steve 	1

Re: Identify data dups

tarheel13 — Fri, 16 Jul 2021 13:55:21 GMT

proc sort data=have;
   by name;
run;

data have2;
  set have;
  by name;
  if first.name ne last.name then diff_flag=1;
run;

Re: Identify data dups

Ksharp — Sat, 17 Jul 2021 11:07:57 GMT

How do you know 'Patsy' and 'Pat' are the same person ?

Re: Identify data dups

Emma2021 — Sat, 17 Jul 2021 11:11:33 GMT

Thank you.
I would like to identify those cases (the same age and gender and different names).
So the final output can be:
Either this:
F 2 Patsy

Or this:
F 2 Pat

Thank you.

Re: Identify data dups

Ksharp — Sun, 18 Jul 2021 10:16:55 GMT

What if data like this :

F 2 Patsy
F 2 Patsy
F 2 Pat
F 2 Patrick
F 2 Patrick

Re: Identify data dups

Emma2021 — Sun, 18 Jul 2021 11:43:44 GMT

Thank you.
Then the output should be one of those 3 names.

Re: Identify data dups

tarheel13 — Sun, 18 Jul 2021 13:27:31 GMT

Which one though? Does it matter? You don't specify.

Re: Identify data dups

Emma2021 — Sun, 18 Jul 2021 13:34:03 GMT

It does not matter which one—thank you so much!