BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Siva_Harish
Obsidian | Level 7

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
novinosrin
Tourmaline | Level 20
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;

View solution in original post

2 REPLIES 2
novinosrin
Tourmaline | Level 20
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;
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 3331 views
  • 1 like
  • 2 in conversation