Statalist


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

Re: st: RE: Data aligning


From   Anita Sayal <anitasayal@yahoo.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: Data aligning
Date   Wed, 18 Mar 2009 11:53:34 -0700 (PDT)

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:

> From: Joseph Coveney <jcoveney@bigplanet.com>
> Subject: st: RE: Data aligning
> To: statalist@hsphsun2.harvard.edu
> Date: Wednesday, March 18, 2009, 11:53 AM
> Anita Sayal 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