topic Re: replace string in SAS Programming

replace string

Ronein — Thu, 09 Jan 2020 13:08:03 GMT

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;

Re: replace string

Oligolas — Thu, 09 Jan 2020 13:18:52 GMT

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.

Re: replace string

andreas_lds — Thu, 09 Jan 2020 13:18:40 GMT

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

Re: replace string

Ronein — Thu, 09 Jan 2020 13:19:54 GMT

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;

Re: replace string

Ronein — Thu, 09 Jan 2020 13:39:15 GMT

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