Creating new variable with latest non missing entry

Priyamvada07 — Fri, 19 Mar 2021 01:48:18 GMT

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.

Re: Creating new variable with latest non missing entry

blueskyxyz — Fri, 19 Mar 2021 02:30:36 GMT

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;

topic Creating new variable with latest non missing entry in SAS Programming

Creating new variable with latest non missing entry

Re: Creating new variable with latest non missing entry