topic Re: insert separator in SAS Programming

insert separator

BrahmanandaRao — Tue, 06 Oct 2020 06:50:25 GMT

data _null_;
	separator='*';
	x='SAS';
	y=catx(separator,x);
	put y=;
	run;

Desired output;

S*A*S

Re: insert separator

Kurt_Bremser — Tue, 06 Oct 2020 07:02:48 GMT

Run a loop over the string that selects single characters with SUBSTR, and concatenate those:

do i = 1 to length(x);
  y = catx(separator,substr(x,i,1));
end;

Make sure that the defined length of y is sufficient (at least double the defined length of x minus 1).

Re: insert separator

BrahmanandaRao — Tue, 06 Oct 2020 08:16:46 GMT

data n;
do i = 1 to length(x);
separator='*';
y = catx(separator,substr(x,i,1));
end ;
run;

Re: insert separator

Kurt_Bremser — Tue, 06 Oct 2020 08:19:43 GMT

If the separator does not need to be dynamic, you can "hardcode" it:

do i = 1 to length(x);
  y = catx('*',substr(x,i,1));
end;

Re: insert separator

BrahmanandaRao — Tue, 06 Oct 2020 08:36:19 GMT

i didn't get desired ouput above code

Re: insert separator

Kurt_Bremser — Tue, 06 Oct 2020 08:40:10 GMT

Please supply example data in a data step with datalines (DO NOT SKIP THIS!), and the code you ran against that dataset, and indicate where the result does not meet your expectations.

Re: insert separator

BrahmanandaRao — Tue, 06 Oct 2020 08:52:41 GMT

data s;
x='SAS';
do i=1 to length(x);
y=catx('*',substr(x,i,1));
end;
run;

Re: insert separator

Kurt_Bremser — Tue, 06 Oct 2020 09:11:11 GMT

My bad, y was missing as argument to the CATX function:

data s;
x = 'SAS';
length y $5;
do i = 1 to length(x);
  y = catx('*',y,substr(x,i,1));
end;
drop i;
run;

Re: insert separator

BrahmanandaRao — Tue, 06 Oct 2020 09:16:01 GMT

Perfect
Thank You