Just update from /* start date */: input(t1.Date_of_birth, ddmmyy8. FORMAT=ddmmyy10. AS Date_of_birth, input(t1.Default_satisfaction_date, ddmmyy8.) FORMAT=ddmmyy10. AS Default_satisfaction_date, case when not missing(t1.Close_date) and input(t1.Close_date, ddmmyy8.) < input(t1.Start_date, ddmmyy8.) then 1 else 0 end AS Close_Date_LT_Start_Date, case when t1.Name contains "&" or upcase(t1.Name) contains " AND " then 1 else 0 end AS Name_Line_Invalid, case when upcase(t1.Name) contains " LTD" or upcase(t1.Name) contains " LIMITED" or upcase(t1.Name) contains " LLP" then 1 else 0 end AS Potential_Commercial_Record ... View more