st: data management

[Shubhabrata Mukherjee <joy_stat@yahoo.com>]

Hi,

  I have a dataset of the form:

                         Time1                    Time2                 Time3
                    m1  m2  m3             m1 m2 m3         m1  m2  m3
 ID  

2018            1      2     1                1    1    1           1     1     2

2020          ............................................................................

2023          ..........................................................................

.....................................


 and I want my data to look like this:

ID             m1         m2       m3

20181         1           2          1
20182         1           1          1 
20183         1           1          2

20201       .............................
20202       .....................
20203

20231
20232
20233
........................................

and I was wondering what would be the best way to accomplish this?  Thanks,    Joey


      
*
*   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/