topic Re: how can i replace multiple varibale in SAS Programming

how can i replace multiple varibale

Aayushi_17 — Tue, 13 Nov 2018 05:01:13 GMT

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

Re: how can i replace multiple varibale

error_prone — Tue, 13 Nov 2018 06:27:05 GMT

Can't test the code now, try something like:

data work.want;
a ='abcdefghijklmnopqrstuvwx';

do i = 1 to lengthen(a);
if int(i/4) = 0 then do;
substr(a, i, 1) = '4';
end;
end;
run;

Re: how can i replace multiple varibale

DanielLangley — Tue, 13 Nov 2018 09:26:32 GMT

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;

Re: how can i replace multiple varibale

Ksharp — Tue, 13 Nov 2018 12:35:13 GMT

data _null_;
a ='abcdefghijklmnopqrstuvwx';
put a=;
do i = 4 to length(a) by 4;
substr(a, i, 1) = '4';
end;
put a=;
run;

Re: how can i replace multiple varibale

Aayushi_17 — Wed, 14 Nov 2018 05:00:55 GMT

thank you so much this worked