Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

# st: Finding out id in Sequence Analysis matrix

 From Edward James <[email protected]> To [email protected] Subject st: Finding out id in Sequence Analysis matrix Date Tue, 4 Jun 2013 18:28:14 +0900

```Dear Statalist.

Hi, I am currently performing Sequence analysis with Stata.

Here is the tabulation of Sequence.

Sequence-Pattern |      Freq.     Percent        Cum.
---------------------+-----------------------------------
00000000000000000000 |          7       30.43       30.43
00 |          1        4.35       34.78
00000000000000000100 |          1        4.35       39.13
00000000000000000101 |          1        4.35       43.48
00000000000000010100 |          1        4.35       47.83
00000000000001011010 |          1        4.35       52.17
00000000012010100000 |          1        4.35       56.52
00000000101110101011 |          1        4.35       60.87
00000001010010000000 |          1        4.35       65.22
00001000001110111001 |          1        4.35       69.57
00111000100010000000 |          1        4.35       73.91
01010101010101000000 |          1        4.35       78.26
10010010101010010000 |          1        4.35       82.61
11111 |          1        4.35       86.96
11111010101010010010 |          1        4.35       91.30
11111111111111111111 |          1        4.35       95.65
11111111111112111111 |          1        4.35      100.00
---------------------+-----------------------------------
Total |         23      100.00

When I conduct a syntax "sqom, full k(2)", and "matrix list SQdist"

c1   c2   c3   c4   c5   c6   c7   c8   c9  c10  c11  c12  c13
c14  c15  c16  c17
r1    0
r2   .1    0
r3   .2   .1    0
r4   .2   .1   .2    0
r5   .4   .3   .3   .2    0
r6   .4   .4   .5   .5   .5    0
r7   .8   .7   .6   .6   .5   .5    0
r8   .3   .3   .4   .4   .6   .3   .6    0
r9   .8   .7   .7   .6   .5   .5   .3   .7    0
r10   .5   .5   .6   .6   .8   .6   .9   .3   .8    0
r11   .7   .7   .8   .8   .9   .5   .8   .4   .8   .4    0
r12   .7   .7   .8   .7   .8   .5   .7   .4   .7   .4   .2    0
r13  1.1    1    1    1    1   .8   .9   .8   .9   .6   .4   .4    0
r14    2  1.9  1.8  1.8  1.6  1.7  1.2  1.7  1.2  1.5  1.3  1.3   .9    0
r15    2  1.9  1.8  1.8  1.6  1.7  1.2  1.7  1.2  1.5  1.3  1.3   .9   .1    0
r16    2  1.9  1.8  1.8  1.7  1.9  1.6    2  1.6    2    2  1.9  1.8
1.5  1.5    0
r17  1.8  1.8  1.9  1.8  1.8  1.8  1.9  1.8  1.8  1.8  1.8  1.8  1.8
2    2   .5    0

But I cannot find out the match between r1-r17 and id.

I want to know if there are any commands or syntax that figure out the
match between sequence(r1-r17) and id.

Thanks.
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/
```