topic Re: Reverse Strings in SAS Programming

Reverse Strings

cmoore — Wed, 16 May 2018 08:28:46 GMT

Hi,

Does anybody know a quick way to reverse strings. I basically have some strings like the below;

Germany; Munich

and I want to change them to

Munich; Germany

Would you know a good function to use to do this?

Thanks

Chris

Re: Reverse Strings

RW9 — Wed, 16 May 2018 08:41:57 GMT

Well, that's not really reversed, just swapped over. You could do:

want=catx(';',scan(have,2,";"),scan(have,1,";"));

I suspect your issue is more complicated than that. I would split the string up into rows of data with one element per row. Then have a look up merge, for country, and one for city, merge that on to get a flag for wether it is a country or city, then transpose it up. Provide some test data in the form of a datastep and can show code.

Re: Reverse Strings

cmoore — Wed, 16 May 2018 08:45:13 GMT

Thanks a lot for your advice

Re: Reverse Strings

ShiroAmada — Wed, 16 May 2018 08:48:27 GMT

data x;
  a='Munich; Germany';
  b=catt(scan(a,2,";"),"; ",scan(a,1,";"));
run;