Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Fw: RE: st: RE: Data aligning


From   Anita Sayal <anitasayal@yahoo.com>
To   statalist@hsphsun2.harvard.edu
Subject   Fw: RE: st: RE: Data aligning
Date   Thu, 19 Mar 2009 02:13:41 -0700 (PDT)

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index