Re: Fw: RE: st: RE: Data aligning

[Jeph Herrin <junk@spandrel.net>]

Are there two variables named -Reporter-, and two named -Partner-?
This is why it is confusing.

Let's assume you really have something like:

 rep1 part1 year1 var1 rep2 part2 year2 var2

Then you should separate in to 2 files and merge the
second one to the first. Something like:

 preserve
 keep rep2 part2 year2 var2
 ren rep2 rep1
 ren part2 part1
 ren year2 year1
 sort rep1 part1 year1
 save temp, replace
 restore
 drop rep2 part2 year2 var2
 sort rep1 part1 year1
 merge rep1 part1 year1 using temp, keeping(var2)

hope this helps,
Jeph




Anita Sayal wrote:
> 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 <n.j.cox@durham.ac.uk>
> > wrote:
> >
> > > From: Nick Cox <n.j.cox@durham.ac.uk>
> > > Subject: RE: st: RE: Data aligning
> > > To: statalist@hsphsun2.harvard.edu
> > > 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 
> > > n.j.cox@durham.ac.uk 
> > >
> > > 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
> > > <jcoveney@bigplanet.com> 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/
*
*   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/