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.
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.