DATA Step, Macro, Functions and more

"Reverse Transposing(?)"

Reply
Frequent Contributor
Posts: 122

"Reverse Transposing(?)"

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.

Super User
Posts: 10,023

Re: "Reverse Transposing(?)"

Posted in reply to maroulator

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;

Ask a Question
Discussion stats
  • 1 reply
  • 253 views
  • 0 likes
  • 2 in conversation