"Reverse Transposing(?)"

maroulator — Sun, 30 Aug 2015 04:34:59 GMT

I have a data set that currently looks like the following:

LoanID Mod_Date Payoff_Date

422593 12/01/2005 07/23/2014

422593 04/09/2007 .

245234 07/09/2004 03/30/2008

245234 09/08/2006 .

353255 08/03/2006 09/23/2012

353255 03/04/2008 .

353255 05/21/2009 .

...and I would like to make it look like the one below:

LoanID Mod_Date1 Mod_Date2 Mod_Date3 Payoff_Date

422593 12/01/2005 04/09/2007 07/23/2014

245234 07/09/2004 09/08/2006 03/30/2008

353255 08/03/2006 03/04/2008 05/21/2009 09/23/2012

Any ideas? Thanks in advance.

Re: "Reverse Transposing(?)"

Ksharp — Sun, 30 Aug 2015 04:55:36 GMT

Code: Program

data have;
input (LoanID  Mod_Date   Payoff_Date) (: $20.);
cards;
422593 12/01/2005 07/23/2014
422593 04/09/2007 .
245234 07/09/2004 03/30/2008
245234 09/08/2006 .
353255 08/03/2006 09/23/2012
353255 03/04/2008 .
353255 05/21/2009 .
;
run;

proc transpose data=have out=want(drop=_name_) prefix=Mod_Date  ;
by LoanID notsorted ;
var Mod_Date   ;
copy Payoff_Date;
run;

topic "Reverse Transposing(?)" in SAS Programming

"Reverse Transposing(?)"

Re: "Reverse Transposing(?)"

Code: Program