Repeat the values based on number in the variable

[David_Billa]

I've a variable called 'num' and it has some unique values. Now I want to repeat values in the same variable based on the value. If it is 2, then I want the value 2 to be displayed 2 times. If it is 3, then I want the value 3 to be displayed 3 times in the same variable.

E.g.

Input Dataset:

Num

1

2

3

Desired dataset:

Num

1

2

2

3

3

3

[PeterClemmensen · Accepted solution]

Do this

data have;
input Num;
datalines;
1
2
3
;

data want;
   set have;
   do _N_ = 1 to Num;
      output;
   end;
run;