SAS Financial Functions

Coalescec Function In SAS Example

What is it?

Returns the first text or string in a list of variables or a series that is non-null and or non-missing

Syntax:

Coalescec(String, String, ..., String_n);

Coalescec Function In SAS Example:

Data work.my_data_file;

    Result_1 = Coalescec(' ', 'John');
    Result_2 = Coalescec(' ', 'John', 'James');
    Result_3 = Coalescec(' ', 'John', 'James', 'Jarred');

Run;

What's happening in the script above?

3 Examples of the Coalescec function which effectively ignores the first blank or empty item in each of the lists (e.g. ' ') and returns the next string in the series

Coalescec Function In SAS Examples:

Variable	Input	Output	Description
Result_1	' ', 'John'	John	1st Non-Empty, Non-Null value
Result_2	' ', 'John', 'James'	John	see above
Result_3	' ', 'John', 'James', 'Jarred'	John	see above

Connect via LinkedIn

Kevin Regan

Have an article, idea, found a typo, want to contribute? Shoot me an email Here

Below are links to some Udemy Data Science Courses. I've been using Udemy for a number of years now, and I've found their courses super helpful, maybe you will also.