BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Tal
Pyrite | Level 9 Tal
Pyrite | Level 9


i have a char variable that need to be filled with |||| to the left and 2 zeros to the right

and write to an output file with  a length of 19 (pos 2 to position 20)

so if the variable is "aaaaaaaaaa"

then it needs to be displayed as    |||||||aaaaaaaaaa00

The zeros  are easy to be added  but the ||| no clue

also another char var (length=16) that needs to be right justified with zeros

so it the var is bbbbbbbbbb it will be 000000bbbbbbbbbb  in the  output

anyone please Smiley Happy

1 ACCEPTED SOLUTION

Accepted Solutions
Haikuo
Onyx | Level 15

I am sure there will be many solutions, here is two of them, _var1--tranwrd() and _var2--substr()

data test;

length _var1 var1 _var2 $ 19;

var="aaaaaaaaaa";

var1=cats(var,'00');

_var1=tranwrd(right(var1),' ','|');

_var2=repeat('|',18);

substr(_var2,19-length(var)-2)=cats(var,'00');

run;

Regards,

Haikuo

Or _var3:

_var3=cats(repeat('|',19-length(var)-3),var,'00');

View solution in original post

2 REPLIES 2
Haikuo
Onyx | Level 15

I am sure there will be many solutions, here is two of them, _var1--tranwrd() and _var2--substr()

data test;

length _var1 var1 _var2 $ 19;

var="aaaaaaaaaa";

var1=cats(var,'00');

_var1=tranwrd(right(var1),' ','|');

_var2=repeat('|',18);

substr(_var2,19-length(var)-2)=cats(var,'00');

run;

Regards,

Haikuo

Or _var3:

_var3=cats(repeat('|',19-length(var)-3),var,'00');

Tal
Pyrite | Level 9 Tal
Pyrite | Level 9

thanks Haikuo!

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1408 views
  • 1 like
  • 2 in conversation