Identifying duplicate values among nine variables per case

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

tackleberry
Posts: 2
Joined: Mon Feb 10, 2014 2:37 pm

Identifying duplicate values among nine variables per case

Postby tackleberry » Mon Feb 10, 2014 2:46 pm

Hello,

I want to compare nine variable for duplicate values for the same case. Is there a function in SPSS that can do that?

Example

1 2 3 4 5 6 7 8 9 -> no duplicate in case 1
1 1 1 2 3 4 5 6 7 => duplicates in ase 2
1 2 3 4 5 5 6 7 8 => duplicates in case 3
1 3 4 5 6 7 8 9 2 => no duplicate in case 4

If there is no option in SPSS, does anyone know a solution in Excel? There I could use conditional formating but I would have to select the variable for each case (each row) by hand, select CF, set option, selected the nine variable for 2nd case by hand and so on. Since I have like 400 cases that would be not so nice.

Why do I need that? Well I want to identify observation where responds did not read the instructions carefully, typed in wrong number and delete these by hand.

Thank you in advance
GerineL
Moderator
Posts: 1477
Joined: Tue Jun 10, 2008 4:50 pm

Re: Identifying duplicate values among nine variables per ca

Postby GerineL » Mon Feb 10, 2014 4:50 pm

do you have 400 cases or 400 vars to compare with each other?
tackleberry
Posts: 2
Joined: Mon Feb 10, 2014 2:37 pm

Re: Identifying duplicate values among nine variables per ca

Postby tackleberry » Tue Feb 11, 2014 4:06 pm

There are around 500 cases in one dataset. I need to check for duplicates among var1 to var9 for each single case.

The background of the question is that we collected data via an online survey. Respondents had to assign values between 0 and 100 to 9 items (the nine variables I mentioned above). Since a respondent was not allowed to assign the same value twice but the limitation could not be implemented in the online survey, we want to idenfity the responses (cases) which violate the instructions we gave.
GerineL
Moderator
Posts: 1477
Joined: Tue Jun 10, 2008 4:50 pm

Re: Identifying duplicate values among nine variables per ca

Postby GerineL » Tue Feb 11, 2014 5:05 pm

then use if function:


if (var1 = var2 | var2 = var3 | var1 = var4 | var1 = var5 | var1 = var6 | var1 = var7 | var1 = var8 | var1 = var9) double = 1.
if (var2 = var3 | var2 = var4 | var2 = var5 | var2 = var6 | var2 = var7 | var2 = var8 | var2 = var9) double = 1.
if (var3 = var4 | var3 = var5 | var3 = var6 | var3 = var7 | var3 = var8 | var3 = var9) double = 1.
[etc]
execute.

Who is online

Users browsing this forum: No registered users and 1 guest

cron