topic Re: Array Question in New SAS User

Array Question

umesh1 — Thu, 20 Jun 2019 16:21:59 GMT

Hi All, I have below dummy data set. I would like to achieve below result in the last column. Result column in T or R depending on the consecutive zero of the row DATA TEST; INPUT ID T1 T2 T3 T4 T5 T6 T7; CARDS; 1 1 1 1 0 1 1 1 2 1 1 0 0 1 1 1 3 1 1 0 0 0 1 1 4 1 1 0 1 1 1 1 5 0 1 1 1 1 1 1 6 0 0 1 1 1 1 1 ; RUN; Result will look like as below 1 1 1 1 0 1 1 1 T 2 1 1 0 0 1 1 1 R 3 1 1 0 0 0 1 1 R 4 1 1 0 1 1 1 1 T 5 0 1 1 1 1 1 1 T 6 0 0 1 1 1 1 1 R

Re: Array Question

Cynthia_sas — Thu, 20 Jun 2019 18:07:10 GMT

Hi:

This seems like a scenario where you could use ARRAY processing if you need to worry about consecutive values. What about data like this:

1 1 1 1 0 1 1 1 T 
2 1 1 0 0 1 1 1 R 
3 1 1 0 0 0 1 1 R 
4 1 1 0 1 1 1 1 T 
5 0 1 1 1 1 1 1 T 
6 0 0 1 1 1 1 1 R 
7 1 1 1 1 1 1 1 T
8 1 0 1 0 1 0 1 ??

I assume that 7 would be a T, but what about 8 -- it has three 0 values, but not consecutive.

Cynthia

Re: Array Question

Tom — Thu, 20 Jun 2019 18:50:42 GMT

Are the values only 0 and 1? Are any missing?

If so you could try converting them to a string and checking the string for the pattern.

if index(cats(of t1-t7),'000') then result='T';
else result='R';