how to identify last item completed for each respondent

[Cleland, Patricia (EDU)]

For each respondent (record), I need to identify the last item completed on a survey.  I know that I’ve seen this discussed on the list serve but a Google search and a search of the list serve archives don’t turn up anything.

 

Any help would be appreciated.

 

Pat

 

[Maguin, Eugene]

Pat,

I would do this. Let the survey be s1 to 47, all numeric.

Vector s=s1 to s47.
Loop #i=47 to 1 by -1.
+  do if (missing(s(#i)) ne 1).
+     compute last=#i.
+     break.
+  end if.
End loop.

Gene Maguin



________________________________

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Cleland, Patricia (EDU)
Sent: Wednesday, September 01, 2010 9:04 AM
To: [hidden email]
Subject: how to identify last item completed for each respondent

For each respondent (record), I need to identify the last item completed on
a survey.  I know that I've seen this discussed on the list serve but a
Google search and a search of the list serve archives don't turn up
anything.

Any help would be appreciated.



Pat

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[David Millar]

 

---

From: David Millar
Sent: Wednesday, September 01, 2010 3:24 PM
To: 'Cleland, Patricia (EDU)'
Subject: RE: how to identify last item completed for each respondent

Patricia, the code below looks at missing responses at the end of two subtests - a 40 item vocab test and a 36 item comprehension test.  It recodes a solid string of 9s at the end of a test from 9 (missing) to 7 (not presented).  Does this do what you are looking for?  It would be possible to add a line in to indicate what was the last completed item if you wanted.

 

Best wishes

 

David

 

 

_______________

 

compute addressrv=40.
compute addressrc=36.

 

vector itemrv=rv1 to rv40.
vector itemrc=rc1 to rc36.

 

loop #i=1 to 40.
do if  (itemrv(addressrv)=9).
compute itemrv(addressrv)=7.
compute addressrv=addressrv-1.
else if (itemrv(addressrv) ne 9).
break.
end if.
end loop.

 

loop #i=1 to 36.
do if  (itemrc(addressrc)=9).
compute itemrc(addressrc)=7.
compute addressrc=addressrc-1.
else if (itemrc(addressrc) ne 9).
break.
end if.
end loop.

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Cleland, Patricia (EDU)
Sent: Wednesday, September 01, 2010 2:04 PM
To: [hidden email]
Subject: how to identify last item completed for each respondent

For each respondent (record), I need to identify the last item completed on a survey.  I know that I’ve seen this discussed on the list serve but a Google search and a search of the list serve archives don’t turn up anything.

 

Any help would be appreciated.

 

Pat