Identifying Conditional Cases

Hi all,

I'm currently working with a fairly large data set (sample attached), comprising 50 questions from a survey.

Essentially, respondents choose any option from 1-5.

Skipped questions and Don't Knows are denoted with -1 (Skipped) and -999 (Don't Know).

What I am having some trouble with is, of the respondents who got either a -1 or -999 on the last question, what was the farthest they got before that.

So if ID 1 received a -1 on question 50, but entered a response to question 49, I would want to make a column that indicates "49" for that ID.

Thanks in advance for any suggestions!

Darko

Thank so much Special-K! Worked really well!