Macro For Re-Coding Variables after a Specified Cut-off

[Darko_Giac]

Hi All,

I currently have a fairly large data set of dichotomized data points denoting a right (1's) and wrong response (0's)

I currently have a custom function that will start summing correct responses, but stop summing after a respondent has received four (or more) 0's in a row

What I am looking to do next is write a macro that will re-code all of the responses after the participant has reached the four-0's-in-a-row cut-off to 0's (even if they got some questions correct after they answered four or more in a row incorrectly).

I've attached a workbook which will hopefully clarify the issue, but any help/advice would be greatly appreciated!

Darko