st: Re: transform observations in variables

["Martin Weiss" <martin.weiss1@gmx.de>]

BTW, how does the "size" for AB go from 4 to 2 in period 1? Same question 
for BG...

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               4
>
> BG                    1               4
> BG                    2               8
>
> 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/