Reverse Strings

[cmoore]

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

[RW9 · Accepted solution]

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.

[cmoore]

Thanks a lot for your advice

[ShiroAmada]

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