Date:         Fri, 25 Jul 2008 13:44:37 -0400
Reply-To:     Chang Chung <chang_y_chung@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Chang Chung <chang_y_chung@HOTMAIL.COM>
Subject:      Re: data transformation question
Comments: To: Ya Huang <ya.huang@AMYLIN.COM>

On Fri, 25 Jul 2008 13:16:23 -0400, Ya Huang <ya.huang@AMYLIN.COM> wrote:

>OK, this one should do it, though take much more steps:
...
> ------------------------------
> |        | 11 | 12 | 25 | 63 |
> |--------+----+----+----+----|
> |101-125 |   0|   1|   0|   0|
> |101-150 |   0|   0|   0|   0|
> |101-231 |   0|   0|   0|   0|
> |101-246 |   0|   0|   0|   0|
> |101-250 |   0|   0|   0|   0|
> |101-255 |   0|   1|   0|   0|
> |125-150 |   0|   0|   0|   0|
> |125-231 |   0|   0|   0|   0|
> |125-246 |   0|   0|   0|   0|
> |125-250 |   0|   0|   0|   0|
> |125-255 |   0|   1|   0|   0|
> |150-231 |   0|   0|   0|   0|
> |150-246 |   0|   0|   0|   0|
> |150-250 |   0|   0|   0|   0|
> |150-255 |   0|   0|   0|   0|
> |231-246 |   1|   0|   0|   0|
> |231-250 |   1|   0|   0|   0|
> |231-255 |   0|   0|   0|   0|
> |246-250 |   1|   0|   0|   0|
> |246-255 |   0|   0|   0|   0|
> |250-255 |   0|   0|   0|   0|
> ------------------------------

hi,
here is another way. I used ya's test data. almost the same idea. the final
steps are a bit different. in terms of results, ya and i have different
counts of pairs involving 231-246 231-250. I don't know why...
cheers,
chang