extract non missing value

[bhanuprakash]

Hi Team,

Can you please tell me how to extract non missing value (Expected_data) data by using single statement.

Below is the example I am expecting expected_data column

Please let me know if you need any further clarification form my side.  

[novinosrin · Accepted solution]

want=coalescec(of race_a--race_e);

[bhanuprakash]

Thank you so much for the quick response.