Hi all,  I have a dataset of laboratory results. Labs were collected at multiple time points. I am specifically interested in knowing if a patient tested negative at sequential time points. Specifically, if they tested negative twice or more in a row. Here's an example dataset, where neg1-neg5 is a yes/no (1/0) for a negative value. I do not want to reorder the dataset, as it is important to keep the results in the order in which they were received.    This is an example of what I have:   patid neg1 neg2 neg3 neg4 neg5 1 0 1 0 0 1 2 1 1 1 0 0 3 0 1 1 0 0 4 0 1 1 1 1 5 0 0 0 1 0   And I would like something like this, where #seqneg is the number of sequential negatives by patient.  patid neg1 neg2 neg3 neg4 neg5 #seqneg 1 0 1 0 0 1 0 2 1 1 1 0 0 3 3 0 1 1 0 0 2 4 0 1 1 1 1 4 5 0 0 0 1 0 0   Thank you!! ... View more

Hi all,    I have 21 variables of results (rslt_1 - rslt_21). Values within each variable are 'yes', 'no', 'unknown' and blanks. I am interested in one variable, lets call it helpme, that will tell me whether or not a subject ever had a 'yes' in any of the 21 results. If not, then I want the value of helpme to be either no or none if results were no, unknown, or blank. For example, I would like my final data to look like this:   rslt_1   rslt_2   rslt_3  ...   rslt_21            helpme yes      no                         unknown        yes no                                     no                  no yes      yes                                              yes                                                                none   I use an array, right? But I'm getting stuck on creating the new variable. Here's the code I have tried, which creates "helpme" but without any values and SAS tries to convert my character variables to numeric.    data want (drop=i); set have; array rsltarray (21) rslt_1-rslt_21; do i=1 to 21; if rsltarray(i) in ('yes') then helpme='yes'; else if rsltarray(i) in ('no', 'unknown') then helpme='no'; else if rsltarray(i) in ('') then helpme='none'; end; run;   Thanks so much! ... View more