Hi, I have tried to better explain here   If all [viewable] = no Or Day 1 [Goodimage 1,2,3 ] =no and [viewable 1,2,3]=yes now becomes [Goodimage 1,2,3 ] =no And and [viewable 1,2,3]=no Or Day1 [Goodimage 1,2,3 ] =yes and [viewable 1,2,3]=yes now becomes [Goodimage 1,2,3 ] =yes and [viewable 1,2,3]=no or [viewable 1,2,3]=yes and [length 1,2,3] <10   Thanks! ... View more

Here is the sas dataset I hope someone can help me with this thanks! ... View more

person_id visitday Viewable_1 length_1 Goodimage_1 Viewable_2 lengthe_2 Goodimage_2 Viewable_3 length_3 Goodimage_3 1 day1 Yes 36 No Yes 15 Yes Yes 15 No 1 day2 Yes 19 No Yes 31 Yes Yes 18 No 1 day3 Yes 28 No Yes 27 Yes Yes 30 No 2 day1 Yes 38 No Yes 15 No Yes 49 Yes 3 day1 Yes 47 No Yes 14 No Yes 41 Yes 3 day2 Yes 78 No . . . . . . 4 day1 Yes 74 No . . . . . . 4 day2 Yes 8 No Yes 7 No . . . 4 day3 Yes 8 No Yes 7 No Yes 12 No 5 day1 Yes 3 No Yes 23 Yes . . . 5 day2 Yes 8 No Yes 15 Yes . . . 5 day3 Yes 7 No Yes 13 Yes . . . 5 day4 Yes 7 No Yes 11 Yes . . . 5 day5 Yes 6 No no 11 Yes . . . 6 day1 Yes 16 No no 12 Yes . . . 6 day2 Yes 17 No Yes 12 Yes . . . 7 day1 Yes 6 No Yes 6 Yes . . . 7 day2 No . No Yes 5 Yes . . . 8 day1 No . No Yes 6 Yes . . . 8 day2 No . No Yes 6 Yes . . . 9 day1 Yes 16 No . . . . . . 9 day2 . . . . . . . . . 10 day1 Yes 21 No . . . . . . 10 day2 Yes 24 Yes Yes 24 yes Yes 33 No 10 day3 Yes 26 Yes Yes 26 No Yes 54 No 11 day1 no 27 Yes Yes 26 No . . . 11 day2 Yes 10 No Yes 31 Yes Yes 44 No 11 day3 Yes 56 No . . . . . . 12 day1 Yes 43 No . . . . . . 12 day2 Yes 41 No . . . . . . 12 day3 Yes 40 No . . . . . . 13 day1 Yes 34 No . . . . . .   Here is the data Thanks! ... View more

person_id visitday Viewable_1 length_1 Goodimage_1 Viewable_2 lengthe_2 Goodimage_2 Viewable_3 length_3 Goodimage_3 1 day1 Yes 36 No Yes 15 Yes Yes 15 No 1 day2 Yes 19 No Yes 31 Yes Yes 18 No 1 day3 Yes 28 No Yes 27 Yes Yes 30 No 2 day1 Yes 38 No Yes 15 No Yes 49 Yes 3 day1 Yes 47 No Yes 14 No Yes 41 Yes 3 day2 Yes 78 No . . . . . . 4 day1 Yes 74 No . . . . . . 4 day2 Yes 8 No Yes 7 No . . . 4 day3 Yes 8 No Yes 7 No Yes 12 No 5 day1 Yes 3 No Yes 23 Yes . . . 5 day2 Yes 8 No Yes 15 Yes . . . 5 day3 Yes 7 No Yes 13 Yes . . . 5 day4 Yes 7 No Yes 11 Yes . . . 5 day5 Yes 6 No no 11 Yes . . . 6 day1 Yes 16 No no 12 Yes . . . 6 day2 Yes 17 No Yes 12 Yes . . . 7 day1 Yes 6 No Yes 6 Yes . . . 7 day2 No . No Yes 5 Yes . . . 8 day1 No . No Yes 6 Yes . . . 8 day2 No . No Yes 6 Yes . . . 9 day1 Yes 16 No . . . . . . 9 day2 . . . . . . . . . 10 day1 Yes 21 No . . . . . . 10 day2 Yes 24 Yes Yes 24 yes Yes 33 No 10 day3 Yes 26 Yes Yes 26 No Yes 54 No 11 day1 no 27 Yes Yes 26 No . . . 11 day2 Yes 10 No Yes 31 Yes Yes 44 No 11 day3 Yes 56 No . . . . . . 12 day1 Yes 43 No . . . . . . 12 day2 Yes 41 No . . . . . . 12 day3 Yes 40 No . . . . . . 13 day1 Yes 34 No . . . . . .     Unfortunately i don thave an existing sas dataset I will create one and post it ... View more

Sorry about that..I have attached my table with this post Thanks! ... View more

I basically transposed the dataset and deleted the missings ... View more

Thank you! I figured it out ... View more