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
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;
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;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.