I think you are right..I didnt explain it well.
This is purly a data arranging issue, pre-estimation. The
second set of Reporter Partner Year to be dropped once Var2
data is aligned with corresponding the Year Report Partener (frist 3 columns)..for example A D 1986 .4 should be aligned with 2nd row 2..and C A 1989 .3 should be in row 6..its a question of how to do this for a large dataset..
Reporter Partner Year Var1 Reporter Partner Year Var2
> A B 1985 10 A D 1986 .4
> A C 1986 12 C A 1989 .3
> A D 1986 14
> B A 1985 15
> B C 1985 18
> C A 1989 20
>
>
> --- On Wed, 3/18/09, Nick Cox <[email protected]>
> wrote:
>
> > From: Nick Cox <[email protected]>
> > Subject: RE: st: RE: Data aligning
> > To: [email protected]
> > Date: Wednesday, March 18, 2009, 3:05 PM
> > Tell people more about your precise data structure and
> > variable names.
> > (You can not have two variables with the same name.)
> >
> > I think your previous description led Joseph (and no
> doubt
> > several
> > others) to guess that you were talking about two
> different
> > datasets.
> >
> > Nick
> > [email protected]
> >
> > Anita Sayal
> >
> > I repeated your example..Its works fine doing
> manually..but
> > how would I
> > replicate for a very large data set and when all data
> is in
> > single file
> >
> > --- On Wed, 3/18/09, Joseph Coveney
> > <[email protected]> wrote:
> >
> > >
> > > Would someone Please tell me what commands arto
> ae
> > used to
> > > align the data for
> > > Var2 with corresponding Reporter Partner
> combination
> > in
> > > Column 1 and 2 for
> > > corresponding years.. trying to do thiis for a
> large
> > data
> > > set..TX
> > >
> > >
> > > Reporter Partner Year Var1 Reporter
> Partner Year Var2
> > > A B 1985 10 A D 1986
> .4
> > > A C 1986 12 C A 1989 .3
> > > A D 1986 14
> > > B A 1985 15
> > > B C 1985 18
> > > C A 1989 20
> > >
> > >
> >
> ------------------------------------------------------------------------
> > --------
> > >
> > > -merge- is what I think you're looking for.
> Try
> > the
> > > do-file below, and see
> > > whether it gives you the kind of data alignment
> that
> > you
> > > want.
> > >
> > > Joseph Coveney
> > >
> > > clear *
> > > set more off
> > > input str1 Reporter str1 Partner int Year byte
> Var1
> > > "A" "B" 1985 10
> > > "A" "C" 1986 12
> > > "A" "D" 1986 14
> > > "B" "A" 1985 15
> > > "B" "C" 1985 18
> > > "C" "A" 1989 20
> > > end
> > >
> > > tempfile tmpfil0
> > > save `tmpfil0'
> > >
> > > clear
> > > input str1 Reporter str1 Partner int Year float
> Var2
> > > "A" "D" 1986 .4
> > > "C" "A" 1989 .3
> > > end
> > >
> > > merge Reporter Partner Year using `tmpfil0',
> sort
> > > list Reporter Partner Year Var1 Var2, noobs
> > sepby(_merge)
> > > exit
> >
> > *
> > * 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/