Repeat the values based on number in the variable

David_Billa — Fri, 04 Feb 2022 11:21:11 GMT

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

Desired dataset:

Num

Re: Repeat the values based on number in the variable

PeterClemmensen — Fri, 04 Feb 2022 11:35:21 GMT

Do this

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

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

topic Re: Repeat the values based on number in the variable in SAS Programming

Repeat the values based on number in the variable

Re: Repeat the values based on number in the variable