topic array or proc tranpose in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/array-or-proc-tranpose/m-p/8278#M336 <HTML><HEAD></HEAD><BODY><P>If i want to transpose a dataset that has millions of records which method wolud be efficient enough either a proc tranpose or arrays.</P><P></P><P>Thanks.</P></BODY></HTML> Sat, 03 Dec 2011 17:56:24 GMT Kethy 2011-12-03T17:56:24Z array or proc tranpose https://communities.sas.com/t5/SAS-Procedures/array-or-proc-tranpose/m-p/8278#M336 <HTML><HEAD></HEAD><BODY><P>If i want to transpose a dataset that has millions of records which method wolud be efficient enough either a proc tranpose or arrays.</P><P></P><P>Thanks.</P></BODY></HTML> Sat, 03 Dec 2011 17:56:24 GMT https://communities.sas.com/t5/SAS-Procedures/array-or-proc-tranpose/m-p/8278#M336 Kethy 2011-12-03T17:56:24Z array or proc tranpose https://communities.sas.com/t5/SAS-Procedures/array-or-proc-tranpose/m-p/8279#M337 <HTML><HEAD></HEAD><BODY><P>You have to provide more info.&nbsp; How many variables before and after the desired transpose and is there a by variable.</P></BODY></HTML> Sat, 03 Dec 2011 20:40:42 GMT https://communities.sas.com/t5/SAS-Procedures/array-or-proc-tranpose/m-p/8279#M337 art297 2011-12-03T20:40:42Z array or proc tranpose https://communities.sas.com/t5/SAS-Procedures/array-or-proc-tranpose/m-p/8280#M338 <HTML><HEAD></HEAD><BODY><P> transpose might like to hold the entire file in memory. That will cause problems for very large data.</P><P>If you know the data structure, you are that step ahead of proc transpose and will probably make a more successful transpose in a data step.</P></BODY></HTML> Sun, 04 Dec 2011 15:22:42 GMT https://communities.sas.com/t5/SAS-Procedures/array-or-proc-tranpose/m-p/8280#M338 Peter_C 2011-12-04T15:22:42Z