topic Extend the last values for more periods in SAS Programming

Extend the last values for more periods

apolitical — Mon, 01 Oct 2018 20:20:38 GMT

I have this table

ID Period Value

A 1 10

A 2 50

A 3 30

B 1 20

B 2 50

I want to make a table that extends for each ID to period 5, filling the previously non-existent values with the last existing value. Like this.

ID Period Value

A 1 10

A 2 50

A 3 30

A 4 30

A 5 30

B 1 20

B 2 50

B 3 50

B 4 50

B 5 50

In the existing table, the last period could be different. How do I program this? Thanks.

Astounding — Mon, 01 Oct 2018 21:59:34 GMT

It should be straightforward as long as your data set is sorted:

data want;

set have;

by id period;

output;

if last.id and period < 5 then do period = period + 1 to 5;

output;

end;

run;

ChrisNZ — Mon, 01 Oct 2018 22:03:38 GMT

This looks like homework, What have you tried?

apolitical — Tue, 02 Oct 2018 13:33:17 GMT

Astoundingly simple solution. Thanks!

apolitical — Tue, 02 Oct 2018 13:34:09 GMT

Unfortunately this is not homework and there is no buddy to copy from...

ChrisNZ — Tue, 02 Oct 2018 20:40:01 GMT

@Astounding's code is the answer.

You can even shorten it slightly.

if last.id then do period = period + 1 to 5;