topic keep sequence in proc transpose in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/keep-sequence-in-proc-transpose/m-p/94146#M26663 <HTML><HEAD></HEAD><BODY><P>Hi, I'm trying to keep the date of a group of accts. and transpose it into the column name along wiht the score.. here's what I mean..</P><P></P><P>Have</P><P>Acct&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp; Score</P><P>001&nbsp;&nbsp;&nbsp;&nbsp; Jul12&nbsp;&nbsp;&nbsp;&nbsp; 234</P><P>001&nbsp;&nbsp;&nbsp;&nbsp; Aug12&nbsp;&nbsp; 235</P><P>001&nbsp;&nbsp;&nbsp;&nbsp; Sep12&nbsp;&nbsp; 364</P><P>002&nbsp;&nbsp;&nbsp;&nbsp; Jul12&nbsp;&nbsp;&nbsp; 535</P><P>002&nbsp;&nbsp;&nbsp; Aug12&nbsp;&nbsp; 534</P><P>002&nbsp;&nbsp;&nbsp; Sep12&nbsp;&nbsp;&nbsp; 535</P><P></P><P>Want</P><P>Acct&nbsp;&nbsp; Jul12_score&nbsp;&nbsp;&nbsp;&nbsp; Aug12_score&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sep12_score</P><P>001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 235&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 364</P><P>002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 535&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 534&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 535</P><P></P><P>thanks</P></BODY></HTML> Mon, 01 Apr 2013 17:56:36 GMT podarum 2013-04-01T17:56:36Z keep sequence in proc transpose https://communities.sas.com/t5/SAS-Procedures/keep-sequence-in-proc-transpose/m-p/94146#M26663 <HTML><HEAD></HEAD><BODY><P>Hi, I'm trying to keep the date of a group of accts. and transpose it into the column name along wiht the score.. here's what I mean..</P><P></P><P>Have</P><P>Acct&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp; Score</P><P>001&nbsp;&nbsp;&nbsp;&nbsp; Jul12&nbsp;&nbsp;&nbsp;&nbsp; 234</P><P>001&nbsp;&nbsp;&nbsp;&nbsp; Aug12&nbsp;&nbsp; 235</P><P>001&nbsp;&nbsp;&nbsp;&nbsp; Sep12&nbsp;&nbsp; 364</P><P>002&nbsp;&nbsp;&nbsp;&nbsp; Jul12&nbsp;&nbsp;&nbsp; 535</P><P>002&nbsp;&nbsp;&nbsp; Aug12&nbsp;&nbsp; 534</P><P>002&nbsp;&nbsp;&nbsp; Sep12&nbsp;&nbsp;&nbsp; 535</P><P></P><P>Want</P><P>Acct&nbsp;&nbsp; Jul12_score&nbsp;&nbsp;&nbsp;&nbsp; Aug12_score&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sep12_score</P><P>001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 235&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 364</P><P>002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 535&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 534&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 535</P><P></P><P>thanks</P></BODY></HTML> Mon, 01 Apr 2013 17:56:36 GMT https://communities.sas.com/t5/SAS-Procedures/keep-sequence-in-proc-transpose/m-p/94146#M26663 podarum 2013-04-01T17:56:36Z Re: keep sequence in proc transpose https://communities.sas.com/t5/SAS-Procedures/keep-sequence-in-proc-transpose/m-p/94147#M26664 <HTML><HEAD></HEAD><BODY><P>PROC TRANSPOSE has everything you need to create have from want.&nbsp; Have you seen the online documentation it is very informative.</P></BODY></HTML> Mon, 01 Apr 2013 18:03:21 GMT https://communities.sas.com/t5/SAS-Procedures/keep-sequence-in-proc-transpose/m-p/94147#M26664 data_null__ 2013-04-01T18:03:21Z