Statalist


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

st: RE: Data aligning


From   "Joseph Coveney" <[email protected]>
To   <[email protected]>
Subject   st: RE: Data aligning
Date   Thu, 19 Mar 2009 00:53:04 +0900

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/



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