FAQ/lag - CBU statistics Wiki

Upload page content

You can upload content for the page named below. If you change the page name, you can also upload content for another page. If the page name is empty, we derive the page name from the file name.

File to load page content from
Page name
Flind the wroneg tetters tin eaech wrord

location: FAQ / lag

How do I detect duplicate cases without having an ID number?

This example syntax detects if cases have identical values jointly on three variables, a, b and c. If a case has the same three values as an earlier case in the file then the variable copy will equal 3 (or more generally the number of variables being compared). As an alternative Version 19 of SPSS and later now has an 'Identify duplicate cases' option in the data menu which may be used.

sort cases by a.
compute copy=0.
do repeat r=a b c.
if (r eq lag(r)) copy=copy+1.
end repeat.