topic Re: Complete a string with "@" depending on it length in SAS Enterprise Guide

Complete a string with "@" depending on it length

anonymous_user — Tue, 29 Sep 2015 02:17:50 GMT

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

user24feb — Tue, 29 Sep 2015 05:56:46 GMT

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;

anonymous_user — Wed, 30 Sep 2015 12:08:24 GMT

It works! Thanks!