The second line is unnecessary.
Nick
[email protected]
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]]On Behalf Of Nick Cox
> Sent: 20 April 2004 14:18
> To: [email protected]
> Subject: st: RE: Resdesigning dyadic data formats
>
>
> fillin c1 c2
> replace x = . if _fillin
> drop _fillin
>
> Nick
> [email protected]
>
> Neumayer,E
>
> > I have a "dyadic" dataset that looks like this (which is the
> > traditional way of setting up such data):
> >
> > c1 c2 x
> > 1 2 567
> > 1 3 345
> > 1 4 7
> > 1 5 348
> > 2 3 47
> > 2 4 3
> > 2 5 48
> > 3 4 23424
> > 3 5 347
> > 4 5 234
> >
> > The "c1" and "c2" are identifiers for the two dyads. I would
> > like to re-design the data to have it in the following format:
> >
> > c1 c2 x
> > 1 1
> > 1 2 567
> > 1 3 345
> > 1 4 7
> > 1 5 348
> > 2 1 567
> > 2 2
> > 2 3 47
> > 2 4 3
> > 2 5 48
> > 3 1 345
> > 3 2 47
> > 3 3
> > 3 4 23424
> > 3 5 347
> > 4 1 7
> > 4 2 3
> > 4 3 23424
> > 4 4
> > 4 5 234
> > 5 1 348
> > 5 2 48
> > 5 3 347
> > 5 4 234
> > 5 5
> >
> > Note that now the identical pairs (1-1, 2-2, 3-3, 4-4, 5-5)
> > have missing x-values, of course, and that all x-values exist
> > twice now (e.g., once for 1-5, and once for 5-1). I know, one
> > could do this redesigning by hand, but given that my actual
> > dataset is far bigger, I am looking for a way to let Stata do
> > the work for me. Any ideas?
> >
>
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
