copy previous row multiple times

okaka23 — Wed, 18 Oct 2017 19:27:01 GMT

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

Re: copy previous row multiple times

Kurt_Bremser — Wed, 18 Oct 2017 19:54:08 GMT

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