topic Re: repeat letter in SAS Programming

repeat letter

mansour_ibrahim — Tue, 13 Jun 2017 14:18:30 GMT

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

Re: repeat letter

PeterClemmensen — Tue, 13 Jun 2017 14:26:39 GMT

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;

Re: repeat letter

Ksharp — Tue, 13 Jun 2017 14:26:24 GMT

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

Re: repeat letter

kiranv_ — Tue, 13 Jun 2017 14:27:56 GMT

repear function should work

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

Re: repeat letter

mansour_ibrahim — Tue, 13 Jun 2017 14:35:38 GMT

Thank you for your answer

Re: repeat letter

Reeza — Tue, 13 Jun 2017 15:25:13 GMT

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

Re: repeat letter

ballardw — Tue, 13 Jun 2017 16:06:51 GMT

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.