replace string

[Ronein]

Hello

I want to replace  following substrings within Model varaible.

Change   "niz_crd_max"   to   "max"
Change    "Second_Max_niz_crd"   to   "SecondMax"
Change    "50000"   To   "50K"
Change    "20000"   TO  "20K"

data aaa;
Model='niz_crd_max-1.1-50000-50';output;
Model='Second_Max_niz_crd-1';output;
Model='niz_crd_max-1.2'output;
Model='Second_Max_niz_crd-1-50000-50';output;
Run;

[Oligolas]

Use the tranwrd function for example or explain your problem?

Here is a useful PDF for character functions, you'll find anything you need and even more.

[Ronein]

data aaa;
Model='niz_crd_max-1.1-50000-50';output;
Model='Second_Max_niz_crd-1';output;
Model='niz_crd_max-1.2';output;
Run;
data bbb;
set aaa;
ModelNew1 = tranwrd(Model,'niz_crd_max', 'Max');
ModelNew2 = tranwrd(ModelNew1,'Second_Max_niz_crd', 'SecondMax');
ModelNew3 = tranwrd(ModelNew2,'50000', '50K');
ModelNew4 = tranwrd(ModelNew3,'20000', '20K');
run;

[andreas_lds]

Fully agree to @Oligolas: using tranwrd four-times is imho the easiest way to solve the problem.

[Ronein]

so as i understand best way is using 4 times tranwrd function as i did 🙂