Creating new variable with latest non missing entry

[Priyamvada07]

I have the following sample dataset, here 99 is a missing entry.

DATA HAVE;
input var2001 var2002 var2003 var2004;
cards;
1 1 99 99
3 99 4 4
99 4 3 99
4 4 99 4
99 99 99 99
;
run;

I want to create a new variable 'var_cur' for latest non missing entry. If a variable only has missing entries then the new variables must have '99' as entry.

Desired output

Obs var_cur

1          1

2           4

3           3
4           4

5           99

Thank you for the help.

[blueskyxyz · Accepted solution]

data want;
	set have;
	array a(4) var2001 var2002 var2003 var2004;
	do i=1 to dim(a);
		if a(i)^=99 then var_cur=a(i);
	end;
/*	for all missing vars*/
	if var_cur=. then var_cur=99;
run;