topic Re: do loop, how to keep missing observations in SAS Programming

do loop, how to keep missing observations

pamplemouse22 — Tue, 26 Sep 2017 19:05:44 GMT

Hello everyone,

I am using a do loop to create a counter variable, count. However, the values that needs to be counted is not fully complete. How can I adjust the following code to include missing observations? I want to add a line that makes count=. if time=., and have no rows added if time=., but i couldn't get an if-then statement to work. Instead, the rows where time=. are removed from the dataset.

Thank you!

data dat2; 
	set dat1; 
	if time ge 0 then do 
		count=1 to round(time, 1);
			output; 
			end;
run;

Re: do loop, how to keep missing observations

Astounding — Tue, 26 Sep 2017 19:12:10 GMT

Try adding one more statement at the end of the DATA step:

else output;

Re: do loop, how to keep missing observations

Haikuo — Tue, 26 Sep 2017 19:12:37 GMT

data dat2; 
	set dat1; 
if time=. then output;
	else if time ge 0 then do 
		count=1 to round(time, 1);
			output; 
			end;
run;

Re: do loop, how to keep missing observations

pamplemouse22 — Tue, 26 Sep 2017 19:13:18 GMT

That worked! Thank you 🙂

Re: do loop, how to keep missing observations

Tom — Tue, 26 Sep 2017 19:16:23 GMT

You could just make sure your upper bound is at least 1.

data dat2; 
  set dat1; 
  do count=1 to max(1,round(time, 1));
    output; 
  end;
run;