07-10-2017 09:03 PM
As part of a large data set, 2 of my columns contain dates that basically represent the same thing, and they both have missing data in different rows.
Column A Column B Date_Start Date_Begin Column E
How do I combine the Date_Start and Date_Begin columns to replace the blank cells so that I get something like this:
I've also tried Proc Sql, Proc Format, and simply copying Date_Begin across to Data_Start (seen at the end) but it doesn't seem to be working i.e. If Missing(Date_Start) then Date_Start = Date_Begin
Any help with the coding would be appreciated!
Need further help from the community? Please ask a new question.