what function can i use to replace the variable with 4 in the place of 4 or multiples of 4 ??
the input is
data one ;
a='abcdefghijklmnopqrstuvwx';
run;
the output i want is :
abc4efg4hij4lmn4pqr4tuv4
I think you made a mistake in your wanted output.
You put abc4efg4hij4lmn4pqr4tuv4 when I believe it is abc4efg4ijk4mno4qrs4uvw4. The problem being that h.
Try this.
data work.want;
attrib a format = $50.
want format = $50.
;
a ='abcdefghijklmnopqrstuvwx';
array lettersInA[26] $ _TEMPORARY_;
do i = 1 to lengthn(a);
if mod(i,4) = 0 then lettersInA[i] = "4";
else lettersInA[i] = substr(a,i,1);
end;
want = cats(of lettersInA[*]);
drop i;
run;
I think you made a mistake in your wanted output.
You put abc4efg4hij4lmn4pqr4tuv4 when I believe it is abc4efg4ijk4mno4qrs4uvw4. The problem being that h.
Try this.
data work.want;
attrib a format = $50.
want format = $50.
;
a ='abcdefghijklmnopqrstuvwx';
array lettersInA[26] $ _TEMPORARY_;
do i = 1 to lengthn(a);
if mod(i,4) = 0 then lettersInA[i] = "4";
else lettersInA[i] = substr(a,i,1);
end;
want = cats(of lettersInA[*]);
drop i;
run;
data _null_;
a ='abcdefghijklmnopqrstuvwx';
put a=;
do i = 4 to length(a) by 4;
substr(a, i, 1) = '4';
end;
put a=;
run;
thank you so much this worked
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.