repeat letter

[mansour_ibrahim]

Good morinig,

I have a column contains single letters and another number of repetition n.
I want to create a new column that will take value of letters multiply by  n
example.

data have;

input var1 $1 nbr;

cards;

a  3

b  5

c  2

;run;

I want:

data want

var1  nbr  nvar

a      3      aaa

b      5      bbbbb

c      2      cc

thank you

[PeterClemmensen · Accepted solution]

Like this?

data have;
input var1 $1 nbr;
cards;
a 3
b 5
c 2
;

data want;
	set have;
	nvar = repeat(var1, nbr-1);
run;

[ballardw]

If you don't want to have a variable defaulting to 200 characters, OR you need the result to be longer than 200 you will want to have a LENGTH statement to assign a desired length to the result variable.

[Ksharp]

data have;
input var1 $1 nbr;
rep=repeat(var1,nbr-1);
cards;
a  3
b  5
c  2
;
run;

[kiranv_]

repear function should work

data want;
set have;
nvar=repeat(var1,nbr-1);
run;

[mansour_ibrahim]

Thank you for your answer

[Reeza]

@mansour_ibrahim Please mark one of the solutions as the answer.