I have a data set with records containing an array e.g. data1 (1) data2 (.) data3 (1) data4 (1) ... (values are either 1, 2, or missing). There are 1098 vars in the array.

I have a test to conduct as follows:

1. Count the number of CONTINUOUS missing values across the array up to a total of 45 (i.e. =< 45). 2. If there is more than one group of up to 45 continuous missing values then delete the record.

So starting at var1 count the number of vars with continuous missing values. If that number exceeds 45 OR if there is more than one occurance of continuous missing values then delete the record.

Anyone know how I might do this?

Thanks for any help.

Foster Kerrison.