The COALESCE function is employed to pick the first non-missing value in a list of variables. In other words, it returns the first non-blank value of each row.
Let’s produce a sample dataset in SAS to know how COALESCE perform.
- COALESCE : First Non-Missing Value
a1 - a4);
If you examine the output shown within the image below, you’d realize COALESCE returns 98 in first observation which is the first non-missing value among a1 = ., a2 = 98, a3 = 52, a4 =.
- COALESCE : Last Non-Missing Value
Let us suppose you want to find out last non-missing value instead of first. For that, there is no such function available which will return last non-missing value but to achieve that we can reverse the list of variables and calculate the first non-missing value which would be equivalent to last non-missing value. Indirectly, we are considering to evaluate variables from right to left instead of left to right.
Note: coalesce(of a4-a1) is equivalent to coalesce(a4, a3, a2, a1).
- SAS | COMPRESS Function with Examples
- Modulo Operator (%) in C/C++ with Examples
- PImpl Idiom in C++ with Examples
- Arrow operator -> in C/C++ with Examples
- Java Swing | JDialog with examples
- Java Swing | JCheckBox with examples
- Java Swing | JComboBox with examples
- Java Swing | JSplitPane with Examples
- What happens when we call a Function
- Compute Variance and Standard Deviation of a value in R Programming - var() and sd() Function
- Check if a numeric value falls between a range in R Programming - between() function
- Converting a List to Vector in R Language - unlist() Function
- Changing row and column values of a Matrix in R Language - sweep() function
- Modify values of a Data Frame in R Language - transform() Function
- Remove Leading whitespaces from a String in R Language - trimws() Function
- Binding rows and columns of a Data Frame in R - bind_rows() and bind_cols() Function
- Case conversion of a String in R Language - toupper(), tolower(), casefold() and cartr() Function
- Find Location and Character Vector of an Object with partial name in R Language - apropos() and find() Function
- Playing a beep Sound in R Language - beep() Function
- Getting attributes of Objects in R Language - attributes() and attr() Function
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.