Re: st: manipulating chains of data

[Nick Cox <njcoxstata@gmail.com>]

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/