https://communities.sas.com/t5/SAS-Procedures/Reg-Transpose/m-p/51194#M14009 data tran<BR /> input acc date $ emi dpd;<BR /> cards;<BR /> 101 nov08 90 0<BR /> 101 dec08 80 1<BR /> 101 jan09 45 0<BR /> 102 nov08 89 0<BR /> 102 dec08 89 1<BR /> 102 jan09 78 2<BR /> run;<BR /> <BR /> <BR /> Hi i am having a dataset i wnat to transpose this but i wnat to transpose two variable .i wnat the output like this<BR /> <BR /> <BR /> acc nov08 dec08 jan09 nov_emi dec_emi jan_emi<BR /> 101 90 80 45 0 1 0<BR /> 102 89 89 78 0 1 2<BR /> <BR /> <BR /> i have done by transposing emi and then i have taken another datset and again traspose the dpd then i have merged it.<BR /> <BR /> But i wnat this in Transpose Fri, 03 Jul 2009 05:45:56 GMT deleted_user 2009-07-03T05:45:56Z https://communities.sas.com/t5/SAS-Procedures/Reg-Transpose/m-p/51194#M14009 data tran<BR /> input acc date $ emi dpd;<BR /> cards;<BR /> 101 nov08 90 0<BR /> 101 dec08 80 1<BR /> 101 jan09 45 0<BR /> 102 nov08 89 0<BR /> 102 dec08 89 1<BR /> 102 jan09 78 2<BR /> run;<BR /> <BR /> <BR /> Hi i am having a dataset i wnat to transpose this but i wnat to transpose two variable .i wnat the output like this<BR /> <BR /> <BR /> acc nov08 dec08 jan09 nov_emi dec_emi jan_emi<BR /> 101 90 80 45 0 1 0<BR /> 102 89 89 78 0 1 2<BR /> <BR /> <BR /> i have done by transposing emi and then i have taken another datset and again traspose the dpd then i have merged it.<BR /> <BR /> But i wnat this in Transpose Fri, 03 Jul 2009 05:45:56 GMT https://communities.sas.com/t5/SAS-Procedures/Reg-Transpose/m-p/51194#M14009 deleted_user 2009-07-03T05:45:56Z https://communities.sas.com/t5/SAS-Procedures/Reg-Transpose/m-p/51195#M14010 Appears you have multiple, unique PREFIX= requirements for your transposed variables, therefore you must consider two PROC TRANSPOSE executions with a DATA step to MERGE the outputs together creating the columns you have listed.<BR /> <BR /> Below is a link to one of several technical/conference papers found on the SAS support <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> website to consider.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Changing the Shape of Your Data: PROC TRANSPOSE vs. Arrays<BR /> Bob Virgile, Robert Virgile Associates, Inc.<BR /> <A href="http://www2.sas.com/proceedings/sugi24/Begtutor/p60-24.pdf" target="_blank">http://www2.sas.com/proceedings/sugi24/Begtutor/p60-24.pdf</A> Fri, 03 Jul 2009 14:29:25 GMT https://communities.sas.com/t5/SAS-Procedures/Reg-Transpose/m-p/51195#M14010 sbb 2009-07-03T14:29:25Z