re: filling in missing entries

[twildone]

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;

[data_null__ · Accepted solution]

It would help if you show with example data. 

Perhaps you need to reset something at FIRST.ID

[twildone]

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