Set new Variable as the non-missing value in an array

[MB_Analyst]

I have a data set in this form:

data have;
	input id x1-x5;
	datalines;
1 3 . . . . 
2 . 2 . . .
3 . . 5 . . 
4 . . . 7 .
5 . . . . 7
;

I'm trying to use an array that will create a new variable to the non-missing value. I want my new variable to look like:

x_new

3

2

5

7

7

My do loop is only selecting the final value (x5), how do I get it to select the non-missing. 

[PeterClemmensen · Accepted solution]

Use the Coalesce Function like this

data have;
	input id x1-x5;
	datalines;
1 3 . . . . 
2 . 2 . . .
3 . . 5 . . 
4 . . . 7 .
5 . . . . 7
;

data want(keep=id xnew);
    set have;
    xnew=coalesce(of x1-x5);
run;

Result:

id  xnew
1	3
2	2
3	5
4	7
5	7