Trying to merge rows in which an individual was at the same location but has multiple date ranges resulting in multiple rows. Want to have one row per location with the first start date and last end date. Having a blank end date means they are still at that location and that would need to be kept. I don't even know where to start with this merge. Open to DATA and PROC SQL steps. This data has approximately 500 rows currently for approximately 60 individuals. The reason the data populates like this is because there are separate bed assignments for each row, that level of data is not needed for this output, just location and the dates. What my data currently looks like: FULLNAME START END LOCATION SMITH, JOHN 14Sep2010 15Sep2010 CEDAR SMITH, JOHN 15Sep2010 28Sep2010 CEDAR SMITH, JOHN 28Sep2010 27Oct2010 CEDAR SMITH, JOHN 28Oct2010 20Apr2011 OAK SMITH, JOHN 20Apr2011 02May2011 OAK SMITH, JOHN 02May2011 17May2011 OAK SMITH, JOHN 17May2011 18Jul2011 PINE-A SMITH, JOHN 18Jul2011 03Oct2011 PINE-A SMITH, JOHN 03Oct2011 13Dec2011 PINE-A SMITH, JOHN 13Dec2011 31Jan2012 OAK SMITH, JOHN 31Jan2012 08Feb2012 OAK SMITH, JOHN 08Feb2012 08Aug2012 OAK SMITH, JOHN 08Aug2012 17Dec2012 OAK MILLER, SALLY 21Aug2015 26Aug2015 PINE-B MILLER, SALLY 26Aug2015 22Sep2015 CEDAR MILLER, SALLY 22Sep2015 14Oct2015 CEDAR MILLER, SALLY 14Oct2015 22Nov2015 CEDAR MILLER, SALLY 22Nov2015 04Dec2015 CEDAR MILLER, SALLY 04Dec2015 10Dec2015 CEDAR MILLER, SALLY 10Dec2015 10Mar2016 OAK MILLER, SALLY 10Mar2016 29Dec2017 OAK MILLER, SALLY 29Dec2017 10May2018 OAK MILLER, SALLY 10May2018 01Nov2018 OAK MILLER, SALLY 01Nov2018 OAK JOHNSON, ROBERT 16Apr2017 17Apr2017 MAPLE-A JOHNSON, ROBERT 17Apr2017 08May2017 MAPLE-A JOHNSON, ROBERT 08May2017 22May2017 MAPLE-B JOHNSON, ROBERT 22May2017 31May2017 WILLOW JOHNSON, ROBERT 31May2017 08Jun2017 WILLOW JOHNSON, ROBERT 08Jun2017 02Aug2017 WILLOW JOHNSON, ROBERT 02Aug2017 07Aug2017 MAPLE-C JOHNSON, ROBERT 07Aug2017 11Sep2017 WILLOW JOHNSON, ROBERT 11Sep2017 03Apr2018 WILLOW What I want my data to look like: FULLNAME START END LOCATION SMITH, JOHN 14Sep2010 27Oct2010 CEDAR SMITH, JOHN 28Oct2010 17May2011 OAK SMITH, JOHN 17May2011 13Dec2011 PINE-A SMITH, JOHN 13Dec2011 17Dec2012 OAK MILLER, SALLY 21Aug2015 26Aug2015 PINE-B MILLER, SALLY 26Aug2015 10Dec2015 CEDAR MILLER, SALLY 10Dec2015 OAK JOHNSON, ROBERT 16Apr2017 08May2017 MAPLE-A JOHNSON, ROBERT 08May2017 22May2017 MAPLE-B JOHNSON, ROBERT 22May2017 02Aug2017 WILLOW JOHNSON, ROBERT 02Aug2017 07Aug2017 MAPLE-C
... View more