> Hi,
>
> I have two variable whose values are strings,
> I want to remove substring from big string.
> for example,
>
> A=adc sgk ghhj
> B= sgk
>
> I want to create a new variable as C, So that it
> should be c=adc ghhj.
> Can any one give the solution on that?
>
>
> Thanks in advance,
> Pabitra
Hi Pabitra,
One way to accomplish this is to use the BASE SAS substring function in an EM SAS code node.
Substr Returns a portion of the variable value based on a starting position
and number of characters.
cpart1 = SUBSTR(a,1,3);
cpart2 =SUBSTR(a,9,3);
You could runt the function twice as above and the use || to cancatenate back the two extract strings into a single varaible c =adc ghhj.
c=cpart1 ||(left)cpart2;
drop cpart1 cpart2;
Others may have an easier step.
... View more