Desktop productivity for business analysts and programmers

Complete a string with "@" depending on it length

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

Complete a string with "@" depending on it length

[ Edited ]

Hi, I'm trying to do something like this to complete some string variable with "@" depending on it length:

 

 

x is a number variable that receives the length

y is a string with multiple length

z is the destination variable

 

x = length(y)

 

if x < 50 then

 

   a || 50 - x  /* at this point I'm trying to put some number of repeated "@" to complete a length of 50 */

 

else

 

   substr(a,1,50) /* if length is greater then 50, I just cut it using substr */

 

end if

 

Regards from Brazil


Accepted Solutions
Solution
‎09-30-2015 08:08 AM
Super Contributor
Posts: 339

Re: Complete a string with "@" depending on it length

You could try:

 

Data A;
  Input y $20.;
  Datalines;
SDFED
GDDE CDEX
DFDXCE
DD
;
Run;

%Let x=40;
Data B;
  Set A;
  z=Repeat('@',&x.);
  Substr(z,1,Length(y))=y;
Run;

View solution in original post


All Replies
Solution
‎09-30-2015 08:08 AM
Super Contributor
Posts: 339

Re: Complete a string with "@" depending on it length

You could try:

 

Data A;
  Input y $20.;
  Datalines;
SDFED
GDDE CDEX
DFDXCE
DD
;
Run;

%Let x=40;
Data B;
  Set A;
  z=Repeat('@',&x.);
  Substr(z,1,Length(y))=y;
Run;

Occasional Contributor
Posts: 16

Re: Complete a string with "@" depending on it length

It works! Thanks!
🔒 This topic is solved and locked.

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

Discussion stats
  • 2 replies
  • 253 views
  • 0 likes
  • 2 in conversation