topic Re: Fillng out missing values in SAS Programming

Fillng out missing values

hkgejd — Wed, 20 May 2020 09:13:17 GMT

How do you do the following?

data have;
input group id;
datalines;
TEST 1
TEST 2
TEST 3
TEST .
TEST .
TEST2 1
TEST2 2
TEST2 .
;
run;

data want;
input group id;
datalines;
TEST 1
TEST 2
TEST 3
TEST 4
TEST 5
TEST2 1
TEST2 2
TEST2 3
;
run;

Thanks in advance 😀

ed_sas_member — Wed, 20 May 2020 09:18:18 GMT

Please try this:

data want;
	set have;
	if not missing(id) then _id=id;
	else _id+1;
	drop id;
	rename _id=id;
run;

hkgejd — Wed, 20 May 2020 09:21:28 GMT

Worked like a charm!

Thank you for your quick response 😁

ed_sas_member — Wed, 20 May 2020 09:23:26 GMT

You're welcome @hkgejd !