Date:         Fri, 19 Jan 2007 11:49:28 -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 matrix
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Hi,

I have a dataset that looks like

Region         Company
1                      32
1                      21
1                      23
1                      11
1                       3
2                       3
2                       2
3                       4
3                      23
3                      21
3                      45
3                      14

There are 25 regions and 45 companies in my dataset. I am trying to create a
matrix 45 X 45 and with each cell containing the number of common regions
the company pair does business.

I tried breaking down the dataset by each region, but unable to run a loop
in order to record all the possible combinations of the companies.

It will be great if someone can help me with this.

Thanks in advance.

Best,

Mayukh Dass
University of Georgia,
Athens, GA 30602.