copy previous row multiple times

[okaka23]

I have a question regarding copy rows multiple times in SET statement.

say, in Dataset 1, I hope each ID count adds up to 5 and copy ID in the next row

Dataset1:

ID          Count

123         2

456         1

Dataset 2 (result):

ID        Count

123      2

123      3

123      4

123      5

456      1

456      2

456      3

456      4

456      5

[Kurt_Bremser · Accepted solution]

data want;
set have;
do count = count to 5;
  output;
end;
run;