topic multiple prxchange together in SAS Programming

multiple prxchange together

yashpande — Thu, 20 Jun 2024 13:29:27 GMT

Is there a way I can use multiple prxchange in one go. i want to replace a with d, b with k, c with l, d with a ,

Here is my input

data a;

input_string="abcdjhj";

input_num=12;

input_string2= "robin";

run;

data b;

set a;

changed_string=prxchange('s/a/d/',-1,input_string);

changed_string=prxchange('s/b/k/',-1,input_string);

changed_string=prxchange('s/c/l/',-1,input_string);

changed_string=prxchange('s/d/a/',-1,input_string);

run;

as per logic i want changed_string value to be "ddklajhj" but this is not producing correct output and my table b has 16 such character variables i want to apply the same logic for those variables also. Can someone help me with the same

Thanks in advance. Any help is appreciated

Re: multiple prxchange together

ballardw — Thu, 20 Jun 2024 14:24:31 GMT

First a question, in your real data are you changing single letters or longer strings?

Second this "want changed_string value to be "ddklajhj" " does not match the description " replace a with d, b with k, c with l, d with a" If we are starting with "abcdjhj" which is 7 characters we don't get "ddklajhj" which is 8 characters.

Assuming your are replacing single characters and that you have a typo in the changed string above:

 data example;
    input_string="abcdjhj";
    newstring = translate(input_string,"dkla","abcd");
 run;

TRANSLATE function is only single character replacements which is why I asked. If you have a double-byte character set the function would be KTRANSLATE.

Re: multiple prxchange together

carl_miles — Thu, 20 Jun 2024 14:50:27 GMT

/* a with d, b with k, c with l, d with a , */ data b; set a; input_string = tranwrd(tranwrd(tranwrd(tranwrd(input_string, 'a', 'd'), 'b', 'k'), 'c', 'l'), 'd', 'a'); input_string2 = tranwrd(tranwrd(tranwrd(tranwrd(input_string2, 'a', 'd'), 'b', 'k'), 'c', 'l'), 'd', 'a'); run;

Re: multiple prxchange together

Tom — Thu, 20 Jun 2024 16:41:52 GMT

What value would you expect changed_string to have if you ran:

changed_string='1';
changed_string='2';
changed_string='3';

Do you see what your problem is?

Or let's do it with numbers:

x=1;
y=x+2;
y=x+3;
y=x+4;

How should you modify those four statements so that y ends up with 10?

x=1;
y=x+2;
y=y+3;
y=y+4;

Can you apply the same thing to your assignment statements?