st: transform observations in variables

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

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/