Statalist


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

RE: st: RE: Data aligning


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: RE: Data aligning
Date   Wed, 18 Mar 2009 19:05:23 -0000

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/



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