st: data management - sets of two lines into single line observation

["b. water" <barleywater@hotmail.com>]

dear all,

stata 8.2,

would appreciate advice on how the following data management transformation can be undertaken:

at the moment data look like this:

Epid	Att	Ned	Yag	Pallad
Gord	Molb	Nur	Zn
Yes	5	twice	Off	Present
2	3	PRN	no
No	4	no	On	Present
0	1	no	yes
.	.	.	.	.
.	.	.	.
.	.	.	.	.
.	.	.	.
Yes	5	twice	Off	Present
2	3	PRN	no
No	4	no	On	Present
0	1	no	yes

i want to change it so it looks like this:

Epid	Att	Ned	Yag	Pallad	Gord	Molb	Nur	Zn
Yes	5	twice	Off	Present	2	3	PRN	no
No	4	no	On	Present	0	1	no	yes
.
.
.
.
Yes	5	twice	Off	Present	2	3	PRN	no
No	4	no	On	Present	0	1	no	yes

thank you for any advice/help.

bw
_________________________________________________________________
Climb to the top of the charts!� Play Star Shuffle:� the word scramble challenge with star power.
http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_oct
*
*   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/