Date:         Fri, 2 Feb 2007 23:11:41 -0500
Reply-To:     Mayukh Dass <mayukh.dass@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mayukh Dass <mayukh.dass@GMAIL.COM>
Subject:      Creating dyadic relations with time
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Hi,

I have a strange problem and I have no idea how to approach it. I hope some
of you can help me with this.

My dataset looks like


Region               Company             Time of Entry
1                          1                          0.23
1                          2                          0.50
1                          3                          0.55
1                          1                          0.65
1                          3                          0.90
2                          1                          0.10
2                          5                          0.65
2                          1                          0.70
2                          2                          0.77

This is a dataset containing different regions (199 of them) and companies
(255 of them) with the different market entry time in these regions. A
company can enter more than ones in the same market.

What I am trying to get is, creating dyadic relations between each companies
with average entry time difference for all the common regions. The problem
is, if the company enters second time, entry time difference between that
company and next companies will be counted from the second entry time.

For example, for the dataset above, the required output is

Company1              Company2                     Time Diff.
1                                  1                                 0
1                                  2                               0.34/2=[
(0.50-0.23)+(077-0.70)]/2
1                                  3                                0.57/2=
[(0.55-0.23)+(0.90-0.65)]/2


Thanks in advance,

Regards,
Mayukh