Count value in multiple characters and mark position?

[#1]

Hi, how can I count the number 0,1,2 from the 1 characteristic column as below? Thank you so much! (x = missing)

Pattern	Count 0	Count 1	Count 2	Position 0	Position 1	Position 2
x,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0	26	1	0	2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28	4	0
2,2,2,2,2,0,0,0,0,0,0,1,1,1,2,0,1,1,1,2,2,2,0,0,0,0,0,0
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,1,1,1,0
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,1
2,2,2,2,2,2,2,2,0,2,2,2,0,0,0,1,2,2,2,2,2,2,2,2,2,2,2,2

[#2]

Hi Jim, 

Thank you so much, but when I try 1 and 2, it seems difficult due to a lot of data rows (6000+). The 3 dose not work because there are multiple patterns on it (2000 pattern of 28 positions in 6000 rows). 

Best regards, 

Theerachai

[#3]

My misunderstanding. Now my response back to you is that I am sure JMP can do what you want.......if you can define the rules as to how to determine what a group is?  

[#4]

Hi Jim, Thank you, I try to combine the pattern of data. In general, my data positions 1-5, 6-9,10-11,12-17, 18-22, 23-25, and 26-28 are the same categories if they have the same 0-2 points (without fixing position in each category) in addition, sometimes, the categories would be 11-17, 1 5 6 8 13 18 23 26, 2 7 19 24 25 27 28, 3 9, 4 20 22, and 21. And I want to find other patterns in all the data. Could you please to guide me? 

Thank you!

[#5]

I remain confused.  You attached an example data table.  Would you please take a specific row(s) from the example data table and walk through the logic on how you would analyze the data from the row?