Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: manipulating chains of data
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: manipulating chains of data
Date
Mon, 14 Jan 2013 12:45:37 +0000
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 <[email protected]> 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/