-reshape- is your friend.
In fact, to -reshape- your data are wide, not long.
Nick
[email protected]
Nikolaos Kanellopoulos
> I have a typical longitudinal data set, which gives me
> information about the
> status of individuals for each month within a year. The data
> are in a long
> format, thus every row represents a year. Variable pid
> distinguishes the
> individuals and variable year shows the time dimension. Every month is
> represented by a variable (v1-v12). This is a binary variable
> but it can
> also contain missing values.
>
> My question is how I can convert my data from yearly panel to
> monthly panel
> based on v1-v12.
>
> To show what I mean, let's say that my original data look like that:
>
> pid year v1 v2 v3 v4 v5 v6
> v7 v8
> v9 v10 v11 v12 x
> 1 1 1 1 1 1 1 1
> 1 1
> 1 1 1 1 .1369841
> 1 2 1 1 1 1 1 1
> 1 1
> 1 1 1 1 .6432207
> 1 3 1 1 1 1 0 0
> 0 1
> 1 1 1 1 .5578017
> 2 3 1 1 1 1 1
> 1 .0610638
> 2 4 1 1 0 0 0 0
> 1 1
> 1 1 1 1 .5552388
>
> I want to convert them so they will look like:
>
> pid v year x
> 1 1 1 .1369841
> 1 1 1 .1369841
> 1 1 1 .1369841
> 1 1 1 .1369841
> 1 1 1 .1369841
> 1 1 1 .1369841
> 1 1 1 .1369841
> 1 1 1 .1369841
> 1 1 1 .1369841
> 1 1 1 .1369841
> 1 1 1 .1369841
> 1 1 1 .1369841
> 1 1 2 .6432207
> 1 1 2 .6432207
> 1 1 2 .6432207
> 1 1 2 .6432207
> 1 1 2 .6432207
> 1 1 2 .6432207
> 1 1 2 .6432207
> 1 1 2 .6432207
> 1 1 2 .6432207
> 1 1 2 .6432207
> 1 1 2 .6432207
> 1 1 2 .6432207
> 1 1 3 .5578017
> 1 1 3 .5578017
> 1 1 3 .5578017
> 1 1 3 .5578017
> 1 0 3 .5578017
> 1 0 3 .5578017
> 1 0 3 .5578017
> 1 1 3 .5578017
> 1 1 3 .5578017
> 1 1 3 .5578017
> 1 1 3 .5578017
> 1 1 3 .5578017
> 2 1 3 .0610638
> 2 1 3 .0610638
> 2 1 3 .0610638
> 2 1 3 .0610638
> 2 1 3 .0610638
> 2 3 .0610638
> 2 3 .0610638
> 2 3 .0610638
> 2 3 .0610638
> 2 3 .0610638
> 2 3 .0610638
> 2 1 3 .0610638
> 2 1 4 .5552388
> 2 1 4 .5552388
> 2 0 4 .5552388
> 2 0 4 .5552388
> 2 0 4 .5552388
> 2 0 4 .5552388
> 2 1 4 .5552388
> 2 1 4 .5552388
> 2 1 4 .5552388
> 2 1 4 .5552388
> 2 1 4 .5552388
> 2 1 4 .5552388
>
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
