Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Re: transform observations in variables


From   "Fabian Brenner" <Fabian.Brenner@gmx.de>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Re: transform observations in variables
Date   Sat, 20 Sep 2008 21:32:56 +0200

Dear Martin,

Thank you for your help (I corrected the mistakes) but I think reshape is not the right command in my case because I have other data-items in the dataset where I don't want to change the shape (or destroy the allocation).

So I am looking for a solution to copy observations of "size" in the columns (with a loop?) for each "familyname".

Thanks,
Fabian




Martin Weiss schrieb:
> -h reshape-
>
> HTH
> Martin
> _______________________
> ----- Original Message ----- From: "Fabian Brenner" <Fabian.Brenner@gmx.de>
> To: <statalist@hsphsun2.harvard.edu>
> Sent: Saturday, September 20, 2008 8:38 PM
> Subject: st: transform observations in variables
>
>
>> Dear statalist:
>>
>> My data look like the following:
>>
>> "familiyname"    "period"     "size"        "period1"      "period2" "period3"
>>
>> AA                    1              8
>> AA                    2              7
>> AA                    3              3
>>
>> AB                    1               2
>>
>> BG                    1               4
>> BG                    2               6
>>
>> For each "familyname" I want to get the values of "size" in the column with the equivalent "period" (1 to 3). The values of "size" should be written in the column of the equivalent period for all observations of the same "familyname" (that is why I wasn't able to manage it with -if-)
>>
>> The result should be:
>>
>> "familiyname"    "period"        "size"            "period1"            "period2"          "period3"
>>
>> AA                    1              8                         8                        7                     3
>> AA                    2              7                         8                        7                     3
>> AA                    3              3                         8                        7                     3
>>
>> AB                    1               2                        2
>>
>> BG                    1               4                        4                         6
>> BG                    2               6                        4                         6
>>
>> I hope someone has a solution or an idea to solve this problem. Thanks in advance!
>> Fabian
>>
>> -- 
>> GMX Kostenlose Spiele: Einfach online spielen und Spaß haben mit Pastry Passion!
>> http://games.entertainment.gmx.net/de/entertainment/games/free/puzzle/6169196
>> *
>> *   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/
>

-- 
GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen!
Jetzt dabei sein: http://www.shortview.de/wasistshortview.php?mc=sv_ext_mf@gmx
*
*   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