DATA Step, Macro, Functions and more

repeat letter

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

repeat letter

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


Accepted Solutions
Solution
‎06-13-2017 01:00 PM
PROC Star
Posts: 547

Re: repeat letter

[ Edited ]

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;

View solution in original post


All Replies
Solution
‎06-13-2017 01:00 PM
PROC Star
Posts: 547

Re: repeat letter

[ Edited ]

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;
Super User
Posts: 10,466

Re: repeat letter

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.

Super User
Posts: 9,662

Re: repeat letter

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

Re: repeat letter

repear function should work

data want;
set have;
nvar=repeat(var1,nbr-1);
run;
Occasional Contributor
Posts: 13

Re: repeat letter

Thank you for your answer

Super User
Posts: 17,750

Re: repeat letter

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 161 views
  • 0 likes
  • 6 in conversation