candace yuan
02-16-2009, 10:20 PM
My original dataset is like this:
date AA02 BB02 CC02.......GG02
198001 0.35 0.85 0.95.... 0.5
198002 0.13 0.22 0.55...... 0.11
.
.
20000 0.32 0.52 0.77 0.42
How can i using macro to translate ABOVE dataset TO the following format:
funds date return
AA02 198001 0.35
AA02 198002 0.13
............
please help!!!!!!!!!!
date AA02 BB02 CC02.......GG02
198001 0.35 0.85 0.95.... 0.5
198002 0.13 0.22 0.55...... 0.11
.
.
20000 0.32 0.52 0.77 0.42
How can i using macro to translate ABOVE dataset TO the following format:
funds date return
AA02 198001 0.35
AA02 198002 0.13
............
please help!!!!!!!!!!