SAS Financial Functions

SAS Coalesc Example

What is it?

Returns the first number in a list of variables or a series that is non-null and or non-missing
Coalesc is for finding first number in a series or list, however Coalescec is similiar and used for finding a string and or first text

Syntax:

Coalesc(String, String, ..., String_n);

SAS Coalesc:

SAS Coalesc Example:

Data work.my_data_file;

Result_1 = Coalesc(' ', 'Baseball');
Result_2 = Coalesc(' ', 'Baseball', '39');

Run;

What's happening in the script above?

2 Coalesc examples which demonstrate how null and or blank elements are ignored, as well as text.

Coalescec Function In SAS Examples:

Variable	Input	Output	Description
Result_1	' ', 'Baseball'	.	Error; there is no number in the list of values
Result_2	' ', 'Baseball', '39'	39	The first two elements are skipped; Null / Empty for the first element; 2nd element because it's not a number

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.