https://communities.sas.com/t5/SAS-Programming/How-to-duplicate-rows-amp-make-transposes-to-fill-the-rows-using/m-p/768924#M243916 <P>Please explain how this is any different than the question you asked in <A href="https://communities.sas.com/t5/SAS-Programming/Transposing-column-data-to-create-duplicate-rows/m-p/768706" target="_blank">https://communities.sas.com/t5/SAS-Programming/Transposing-column-data-to-create-duplicate-rows/m-p/768706</A></P> <P>&nbsp;</P> <P>And why the proposed solutions weren't helpful. The first proposed solution would require exactly one character change to get this output.</P> Tue, 21 Sep 2021 19:27:40 GMT ballardw 2021-09-21T19:27:40Z https://communities.sas.com/t5/SAS-Programming/How-to-duplicate-rows-amp-make-transposes-to-fill-the-rows-using/m-p/768704#M243849 <P>Hello,&nbsp;</P><P>I am a novice SAS programmer assisting research project, and I need help with data manipulation.</P><P>My data is as follows:</P><TABLE border="1"><TBODY><TR><TD>KIS</TD><TD>Stock</TD><TD>Name</TD><TD>Sum2000</TD><TD>Sum2001</TD><TD>Sum2002</TD><TD>Sum2003</TD><TD>Sum2004</TD><TD>Sum2005</TD><TD>Sum2006</TD><TD>Sum2007</TD><TD>Sum2008</TD><TD>Sum2009</TD></TR><TR><TD>000292</TD><TD>059210</TD><TD>AA</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>000442</TD><TD>039020</TD><TD>BB</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>944079000</TD><TD>734022000</TD><TD>1093304000</TD><TD>320309000</TD><TD>1674600000</TD><TD>0</TD><TD>1699003000</TD></TR><TR><TD>000671</TD><TD>036480</TD><TD>CC</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>001097</TD><TD>039230</TD><TD>DD</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to manipulate the data to look like as follows:</P><TABLE border="1"><TBODY><TR><TD>KIS</TD><TD>Stock</TD><TD>Name</TD><TD>Sum</TD></TR><TR><TD>000292</TD><TD>059210</TD><TD>AA</TD><TD>0</TD></TR><TR><TD>000292</TD><TD>059210</TD><TD>AA</TD><TD>0</TD></TR><TR><TD>000292</TD><TD>059210</TD><TD>AA</TD><TD>0</TD></TR><TR><TD>000292</TD><TD>059210</TD><TD>AA</TD><TD>0</TD></TR><TR><TD>000292</TD><TD>059210</TD><TD>AA</TD><TD>0</TD></TR><TR><TD>000292</TD><TD>059210</TD><TD>AA</TD><TD>0</TD></TR><TR><TD>000292</TD><TD>059210</TD><TD>AA</TD><TD>0</TD></TR><TR><TD>000292</TD><TD>059210</TD><TD>AA</TD><TD>0</TD></TR><TR><TD>000292</TD><TD>059210</TD><TD>AA</TD><TD>0</TD></TR><TR><TD>000292</TD><TD>059210</TD><TD>AA</TD><TD>0</TD></TR><TR><TD>000442</TD><TD>039020</TD><TD>BB</TD><TD>0</TD></TR><TR><TD>000442</TD><TD>039020</TD><TD>BB</TD><TD>0</TD></TR><TR><TD>000442</TD><TD>039020</TD><TD>BB</TD><TD>0</TD></TR><TR><TD>000442</TD><TD>039020</TD><TD>BB</TD><TD>944079000</TD></TR><TR><TD>000442</TD><TD>039020</TD><TD>BB</TD><TD>734022000&nbsp;</TD></TR><TR><TD>000442</TD><TD>039020</TD><TD>BB</TD><TD>1093304000</TD></TR><TR><TD>000442</TD><TD>039020</TD><TD>BB</TD><TD>320309000</TD></TR><TR><TD>000442</TD><TD>039020</TD><TD>BB</TD><TD>1674600000</TD></TR><TR><TD>000442</TD><TD>039020</TD><TD>BB</TD><TD>0</TD></TR><TR><TD>000442</TD><TD>039020</TD><TD>BB</TD><TD>1699003000</TD></TR><TR><TD>000671</TD><TD>036480</TD><TD>CC</TD><TD>0</TD></TR><TR><TD>000671</TD><TD>036480</TD><TD>CC</TD><TD>0</TD></TR><TR><TD>000671</TD><TD>036480</TD><TD>CC</TD><TD>0</TD></TR><TR><TD>000671</TD><TD>036480</TD><TD>CC</TD><TD>0</TD></TR><TR><TD>000671</TD><TD>036480</TD><TD>CC</TD><TD>0</TD></TR><TR><TD>000671</TD><TD>036480</TD><TD>CC</TD><TD>0</TD></TR><TR><TD>000671</TD><TD>036480</TD><TD>CC</TD><TD>0</TD></TR><TR><TD>000671</TD><TD>036480</TD><TD>CC</TD><TD>0</TD></TR><TR><TD>000671</TD><TD>036480</TD><TD>CC</TD><TD>0</TD></TR><TR><TD>000671</TD><TD>036480</TD><TD>CC</TD><TD>0</TD></TR></TBODY></TABLE><P>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.</P><P>&nbsp;</P><P>Could anyone provide SAS code for doing this?</P><P>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.</P><P>Since there are thousands of firms, I really need help with coding.</P><P>I'd highly appreciate anyone's help!</P> Tue, 21 Sep 2021 05:06:53 GMT https://communities.sas.com/t5/SAS-Programming/How-to-duplicate-rows-amp-make-transposes-to-fill-the-rows-using/m-p/768704#M243849 JisangYu 2021-09-21T05:06:53Z https://communities.sas.com/t5/SAS-Programming/How-to-duplicate-rows-amp-make-transposes-to-fill-the-rows-using/m-p/768924#M243916 <P>Please explain how this is any different than the question you asked in <A href="https://communities.sas.com/t5/SAS-Programming/Transposing-column-data-to-create-duplicate-rows/m-p/768706" target="_blank">https://communities.sas.com/t5/SAS-Programming/Transposing-column-data-to-create-duplicate-rows/m-p/768706</A></P> <P>&nbsp;</P> <P>And why the proposed solutions weren't helpful. The first proposed solution would require exactly one character change to get this output.</P> Tue, 21 Sep 2021 19:27:40 GMT https://communities.sas.com/t5/SAS-Programming/How-to-duplicate-rows-amp-make-transposes-to-fill-the-rows-using/m-p/768924#M243916 ballardw 2021-09-21T19:27:40Z