How to extend cross sectional units in a panel data

[Kodi Hannon]

Dear all,


I have a dataset in the current format:

ID	Year	X	Y	Z
1	2000	3	1	9
1	2001	4	2	5
1	2002	12	15	21
2	2000	0	7	4
2	2001	...
2	2002
3	2001
3	2002
3	2003
4	2000
4	2001
4	2002

And I would like to extend each cross section unit, for each year, 3 times as follows:

ID	Year	X	Y	Z
1	2000	3	1	9
1	2000	3	1	9
1	2000	3	1	9
1	2001	4	2	5
1	2001	4	2	5
1	2001	4	2	5
1	2002	4	2	5
1	2002	12	15	21
1	2002	12	15	21
2	2000	12	15	21
2	2000	0	7	4
2	2000	0	7	4
2	2001	0	7	4
2	2001	...
2	2001
2	2002
2	2002
2	2002
3	2000
3	2000
3	2000
3	2001
3	2001
3	2001
3	2002
3	2002
3	2002
4	2000
4	2000
4	2000
4	2001
4	2001
4	2001
4	2002
4	2002
4	2002

I tried with several commands and interpolations, but so far I did not manage to get what I wanted. Could you please help me with this?

Many thanks.

Kodi

[Andrew Musau]

expand 3

[Kodi Hannon]

Wonderful.

Many thanks!

Kodi