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

# RE: st: Calculate individual distance from other group members

 From "Martin Weiss" To Subject RE: st: Calculate individual distance from other group members Date Tue, 23 Feb 2010 22:06:27 +0100

<>

" and for the Group, it is not uniform at 5, it is from 1 to
7."

Are the ids within the wards contiguous, i.e. 1,2,3,4? If not, the -assert-
line in Austin`s code will stop Stata.

HTH
Martin

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Kartika Sari
Sent: Dienstag, 23. Februar 2010 21:46
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: Calculate individual distance from other group members

Austin,
Thanks for your reply. Yes, i would like to have something like that.

But, its turn out the actual data is more complicated than the hypothetical
I have 74 wards. and for the Group, it is not uniform at 5, it is from 1 to
7.

So?

Best regards,
Kartika

2010/2/23 Austin Nichols <austinnichols@gmail.com>

> Kartika Sari <kartika.sj@gmail.com>:
> Like so?
>
> clear all
> input gid id ward d1 d2 d3 d4 d5
> 1 1 3 10 4 0 9 7
> 1 2 1 0 6 10 8 5
> 1 3 2 6 0 4 11 3
> 1 4 1 0 6 10 8 5
> 1 5 2 6 0 4 11 3
> end
> forv i=1/5 {
> bys gid (id): assert id[`i']==`i'
> bys gid (id): g i`i'=d`=ward[`i']'
> }
> l, noo
>
> On Tue, Feb 23, 2010 at 11:22 AM, Kartika Sari <kartika.sj@gmail.com>
> wrote:
> > Dear All,
> >
> > In my data, I have  a distance matrix of  wards for each individual. I
> also
> > know in which ward they live. The problem is i want to calculate ward
> > distance from each individual to each of other members in a group. Say
> there
> > are 5 people in a group, so I need to calculate distance for 4 others
for
> > each person. I am wondering whether there is any syntax for this.
> >
> > The structure of data is something like this:
> >
> > group_id individual_id ward dtoward1 dtoward2 dtoward3 dtoward4 dtoward5
> > distance1? distance2? distance3? distance4?
> > 1 1 3 10 4 0 9 7
> > 1 2 1 0 6 10 8 5
> > 1 3 2 6 0 4 11 3
> > 1 4 1 0 6 10 8 5
> > 1 5 2 6 0 4 11 3
> >
> > Thank you very much in advanced.
> >
> > Best regards,
> > Kartika
> >
>
> *
> *   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/
>
*
*   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/

*
*   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/