re: filling in missing entries

twildone — Tue, 18 Sep 2018 20:32:20 GMT

Hi.....I am having trouble to get the following code to work properly. Within each ID, I am trying to replace the missing entries with non-missing entry for that ID. What I am getting is the missing entries are being replaced with the non-missing entry until it reaches a non-missing entry then it continues to replace the following missing entries with that non-missing entry. It seems to ignore the grouping by ID. Am I missing something?...Thanks.

data want;
	set have;
	by ID notsorted;
	retain _Program;
		if not missing(Program) then 
			_Program = Program;
		else 
			Program = _Program;
run;

Re: re: filling in missing entries

data_null__ — Tue, 18 Sep 2018 20:43:15 GMT

It would help if you show with example data.

Perhaps you need to reset something at FIRST.ID

Re: re: filling in missing entries

twildone — Tue, 18 Sep 2018 20:50:34 GMT

Hi....thanks for the suggestion.....that what was needed.

topic re: filling in missing entries in SAS Programming

re: filling in missing entries

Re: re: filling in missing entries

Re: re: filling in missing entries