There are instances in databases where the same variables values are stored in multiple tables or systems. For instance, the same employment details field captured for a customer may be missing or may have different values across the various contacts points that it may have been collected. The value might be accurate and updated in a credit application but may not be updated in a social media profile. The functions in the following section help to deal with missing and multiple values.
Missing and multiple values
COALESCE and COALESCEC
If the objective is to only select the first non-missing value from amongst the options, we can use COALESCE for numeric and the COALESCEC function for character values.
Both functions accept...
