Re: st: Re: transform observations in variables

["Fabian Brenner" <Fabian.Brenner@gmx.de>]

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/