Thanks. This is great.
Dalhia Mani
----- Original Message -----
From: Nick Cox <njcoxstata@gmail.com>
To: statalist@hsphsun2.harvard.edu
Cc:
Sent: Monday, January 14, 2013 1:45 PM
Subject: Re: st: manipulating chains of data
See a concurrent thread starting at
http://www.stata.com/statalist/archive/2013-01/msg00436.html
Also,
please note Statalist policy on using full real names.
please use Stata terminology (observations not rows; variables not columns).
Nick
On Mon, Jan 14, 2013 at 12:40 PM, Dalhia <ggs_da@yahoo.com> wrote:
> I have network data in the following two columns:
>
>
> column1 column2
>
> FirmA person1
> person1 FirmB
> FirmB FirmC
> person2 FirmB
> FirmA person3
>
>
> I
> need to find a way to convert this data so that only firms remain in
> the data. Basically, in cases where a person is the link between two
> firms, I want the firms to get directly linked. So I want to somehow
> convert the data to this form:
>
> column1 column2
> FirmA FirmB
> FirmB FirmC
>
>
> Is
> there a way that Stata can do this automatically? I have 58000 rows and
> there is no way to do this manually. Any help will be much appreciated.
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/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/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/
