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 <[email protected]> wrote:
> From: Joseph Coveney <[email protected]>
> Subject: st: RE: Data aligning
> To: [email protected]
> 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/
