Date: Fri, 20 Apr 2001 12:18:01 -0400
Reply-To: "Kerrison, Foster" <FKerrison@NT.DMA.STATE.MA.US>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Kerrison, Foster" <FKerrison@NT.DMA.STATE.MA.US>
Subject: Reading an array
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.