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

MB_Analyst — Fri, 18 Oct 2019 10:39:27 GMT

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

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

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

PeterClemmensen — Fri, 18 Oct 2019 10:56:54 GMT

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

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

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

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