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

# Re: st: correlation-like table to dyadic pairs transformation

 From Stas Kolenikov <[email protected]> To [email protected] Subject Re: st: correlation-like table to dyadic pairs transformation Date Wed, 19 Jan 2011 10:04:22 -0600

```matrix D = (input your distance matrix here)
clear
set obs 5
generate byte i = _n
expand 5
bysort i : generate byte j = _n
generate double distance = .
generate str7 points = ""
local thenames "ABW AFG AGO ALB ANT"
forvalues i=1/5 {
replace points = "`: word `i' of `thenames''" if i == `i'
forvalues j=1/5 {
replace distance = D[`i',`j'] if i == `i' & `j' == j
replace points = points + "-" + "`: word `j' of `thenames'" if i
== `i' & `j' == j
}
}

There are other solutions of course; it would probably be a little
shorter in Mata, but you'd need to transfer the results back to Stata.

On Wed, Jan 19, 2011 at 8:20 AM, Sorin Krammer <[email protected]> wrote:
>
> Dear All,
>
> I have a problem in transforming a table that looks like this:
>
>            ABW    AFG            AGO                            ALB
>            ANT
> ABW    0    13074,04493    10155,77746    9108,047048    135,1991754
> AFG    13074            0          7072,696531    4052,529947    13005,47268
> AGO    10156    7072,69653                   0      5958,121764  10020,59095
> ALB    9108    4052,52995    5958,121764    0
>  9025,064452
> ANT    135    13005,47268    10020,59095    9025,064452                0
>
>
> This is distance data between two points.
>
> What I need is basically a dyadic dataset:
>
> ABW - AFG        13074,04493
> ABW- AGO        10155,77746
> ABW-ALB            9108,047048
> ..............
>
> ALB-ANT                9025,064452
>
> Any suggestions are welcomed. My programming is basic so I incline for
> command-based solution , if possible.
>
> Many thanks,
> Sorin
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>

--
Stas Kolenikov, also found at http://stas.kolenikov.name
Small print: I use this email account for mailing lists only.

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