topic How to replace a substring at first instance in a string in SAS Programming

How to replace a substring at first instance in a string

Siva_Harish — Wed, 30 Sep 2020 12:25:10 GMT

Hi Folks,

i have data like beloow

i want to replace soft in software as hard at first instance only but not in consecutive cases

data have;

input string $100.;

datalines;

He is a software and a software programmer

software and a hardware

;

want

He is a hardware and software programmer

hardware and a hardware worker

Re: How to replace a substring at first instance in a string

novinosrin — Wed, 30 Sep 2020 12:29:43 GMT

data have;
infile cards truncover;
input string $100.;

datalines;
He is a software and a software programmer
software and a hardware
;

data want;
 set have;
 substr(string,index(string,'soft'),4)='hard';
run;
proc print noobs;run;

Re: How to replace a substring at first instance in a string

Siva_Harish — Wed, 30 Sep 2020 12:38:43 GMT

Thank you!! @novinosrin