Statalist


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

Re: st: RE: Data aligning


From   Eva Poen <eva.poen@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: Data aligning
Date   Wed, 18 Mar 2009 19:08:26 +0000

Oops.
Sorry, misguided post.
Apologies.

Eva

2009/3/18 Eva Poen <eva.poen@gmail.com>:
> Anita,
>
> it sounds to me like you are using Stata mainly interactively. You
> should think about writing your commands up in do-files, which makes
> it very easy to just change a line (-reshape- in your case) and re-run
> the do-file. Also, the general advise by people on statalist is to
> never overwrite your existing data file, and to not save different
> versions of your data after having manipulated it. Instead, save in a
> do-file the commands that got you there. This way, you can replicate
> your findings, and you still have a chance of knowing what exactly you
> typed after 3 months or so.
>
> As to your current problem, I assume that you have not overwritten the
> original data file that you had before the -reshape- attempt. If this
> is the case, you can -preserve- your current data, then -drop _all-
> and -use- your original file. Proceed with -reshape- as you have been
> advised. Then save the resulting data temporarily, -restore-, and
> -merge-.
>
> Hope this helps,
> Eva
>
>
> 2009/3/18 Anita Sayal <anitasayal@yahoo.com>:
>> 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/



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