topic Re: Mapping characters in string in SAS Programming

Mapping characters in string

betty2 — Fri, 21 May 2021 12:56:27 GMT

Hello,

How can I replace characters in string please.

SOURCE	DESTINATION
And	&
Country	C!
City	CI
Under	\

For exemple :

If the field contains : Country and City

I have to turn it into : C! & CI

Thanks for your help

Re: Mapping characters in string

Oligolas — Fri, 21 May 2021 13:11:06 GMT

Hi,

there are many ways. The easiest may be to use the tranwrd function

data test;
   length string string2 $50;
   string='Country and City';
   string2=string;
   string2=tranwrd(String2,'And','&');
   string2=tranwrd(String2,'Country','C!');
   string2=tranwrd(String2,'City','CI');
   string2=tranwrd(String2,'Under','\');
   put string2;
run;

Re: Mapping characters in string

Ksharp — Fri, 21 May 2021 13:46:38 GMT

I would like to use PRXCHANGE(),which could handle a word ,not a string.

data test;
   length string string2 string3 $50;
   string='Country and Cityand';
   string2=tranwrd(String,'and','&');
   string3=prxchange('s/\band\b/&/',-1,string);
run;