Fillng out missing values

[hkgejd]

Hi

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 · Accepted solution]

Hi @hkgejd 

Please try this:

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

[hkgejd]

Worked like a charm!

Thank you for your quick response 😁

[ed_sas_member]

You're welcome @hkgejd !