Oops.
Sorry, misguided post.
Apologies.
Eva
2009/3/18 Eva Poen <[email protected]>:
> 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 <[email protected]>:
>> 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/
