As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Tips:Find the LAST Non-Missing Value in a List of Variables

From sasCommunity
Jump to: navigation, search

Did you know that you can use the COALESCE function to find the LAST non-missing value in a list of variables? It is just a matter of how the arguments to the COALESCE function are entered. Here is an example.

data test;
input x1-x5;
if n(of x:) ge 2 then diff = coalesce(of x5-x1) - coalesce(of x:);
datalines;
10 20 30 40 50
. . 20 40 .
10 . . . . 
15 . 25 . 55
. . . . .
;
 
 
the data set ...
x1    x2    x3    x4    x5    diff
10    20    30    40    50     40
 .     .    20    40     .     20
10     .     .     .     .      .
15     .    25     .    55     40
 .     .     .     .     .      .

Note ... the COALESCEC function can also be used in this manner.

Submitted by Mike Zdeb. Contact me at my Discussion Page.

....see also