Hello, I am a novice SAS programmer assisting research project, and I need help with data manipulation. My data is as follows: KIS Stock Name Sum2000 Sum2001 Sum2002 Sum2003 Sum2004 Sum2005 Sum2006 Sum2007 Sum2008 Sum2009 000292 059210 AA 0 0 0 0 0 0 0 0 0 0 000442 039020 BB 0 0 0 944079000 734022000 1093304000 320309000 1674600000 0 1699003000 000671 036480 CC 0 0 0 0 0 0 0 0 0 0 001097 039230 DD 0 0 0 0 0 0 0 0 0 0 I want to manipulate the data to look like as follows: KIS Stock Name Sum 000292 059210 AA 0 000292 059210 AA 0 000292 059210 AA 0 000292 059210 AA 0 000292 059210 AA 0 000292 059210 AA 0 000292 059210 AA 0 000292 059210 AA 0 000292 059210 AA 0 000292 059210 AA 0 000442 039020 BB 0 000442 039020 BB 0 000442 039020 BB 0 000442 039020 BB 944079000 000442 039020 BB 734022000 000442 039020 BB 1093304000 000442 039020 BB 320309000 000442 039020 BB 1674600000 000442 039020 BB 0 000442 039020 BB 1699003000 000671 036480 CC 0 000671 036480 CC 0 000671 036480 CC 0 000671 036480 CC 0 000671 036480 CC 0 000671 036480 CC 0 000671 036480 CC 0 000671 036480 CC 0 000671 036480 CC 0 000671 036480 CC 0 In short words, after AA's Sum for Years 2000-2009 ends, then BB's Sum for Years 2000-2009 follows, and CC's Sum for Years 2000-2009 follows, and so on. Could anyone provide SAS code for doing this? It seems like I have to use proc transpose to do this, but I don't know how to duplicate rows along with proc transpose. Since there are thousands of firms, I really need help with coding. I'd highly appreciate anyone's help!
... View more