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
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');
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');
thanks Haikuo!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.