data sashelp.file1; infile datalines dsd truncover; input Name:$13. BeginDate:mmddyy10. EndDate:mmddyy10.; datalines4; Bob,05/03/2007,07/18/2016 Carol,06/07/2008,08/09/2010 Evan, 03/02/2004,12/24/2016 Trevor, 06/26/2009,06/26/2010 Tyler, 07/17/2007, 09/28/2011 ;;;; data sashelp.file2; infile datalines dsd truncover; input Name:$13. Date:mmddyy10. ; datalines4; Evan, 07/08/2007 Evan, 02/02/2010 Tyler, 05/11/2009 ;;;; data sashelp.file3; infile datalines dsd truncover; input Name:$13. BeginDate:mmddyy10. EndDate:mmddyy10.; datalines4; Bob,05/03/2007,07/18/2016 Carol,06/07/2008,08/09/2010 Evan, 03/02/2004,7/8/2007 Evan, 7/8/2007,2/2/2010 Evan, 2/2/2010,12/24/2016 Trevor, 06/26/2009,06/26/2010 Tyler, 07/17/2007, 5/11/2009 Tyler, 5/11/2009, 09/28/2011 ;;;; I couldn't really get the program to work but I think this should at least get you where you need to be. Essentially, I am trying to break up file 1 with information from file 2. For every name and date in File 2, I need to locate the row in File 1, break it up into 2 data rows, and replace the BeginDate in one row with the new date and EndDate in the other row with the new Date. I have tried to use data steps but I cannot see how it will work in this instance because, for example Evan, needs to have the split done for the first date in File 2 before going to the second split. But maybe there is an advanced data set expression that can handle what I need it to do. Thanks for you help.
... View more