Replace special characters

[anjankumar08]

Hi All,

I'm not sure why it is not working in my SAS. I'm using SAS 9.4.

data exp;
x='Andrè';

A = 'ÀerÒ';
y=translate(x,'AAAAAAACEEEEIIIIDNOOOOO OUUUUY Saaaaaaaceeeeiiiidnooooo ouuuuy y',
'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþÿ');

z=translate(A,'AAAAAAACEEEEIIIIDNOOOOO OUUUUY Saaaaaaaceeeeiiiidnooooo ouuuuy y',
'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþÿ');
run;

output:

X = Andre 

A = Aero

Thanks

[ChrisNZ]

It's working for me.

x	A	y	z
Andrè	ÀerÒ	Andre	AerO

What errors do you get? 

What SAS version, OS and encoding are you using?

[anjankumar08]

Below is my code.

data exp;
x='Andrè';

A = 'Àerò';

y=translate(x,'AAAAAAACEEEEIIIIDNOOOOO OUUUUY Saaaaaaaceeeeiiiidnooooo ouuuuy y',
'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþÿ');

z=translate(A,'AAAAAAACEEEEIIIIDNOOOOO OUUUUY Saaaaaaaceeeeiiiidnooooo ouuuuy y',
'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþÿ');
run;

[ChrisNZ]

Also do not post your program as text. Use the program icon.

[anjankumar08]

I'm using Windows 7 OS.

NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.4 (TS1M4)
Licensed to NOVARTIS PHARMA AG, Site 70110812.
NOTE: This session is executing on the W32_7PRO platform.



NOTE: Updated analytical products:

SAS/STAT 14.2
SAS/ETS 14.2
SAS/OR 14.2
SAS/IML 14.2
SAS/QC 14.2

NOTE: Additional host information:

W32_7PRO WIN 6.1.7601 Service Pack 1 Workstation

NOTE: SAS initialization used:
real time 6.75 seconds
cpu time 0.98 seconds

[ChrisNZ]

Do not post LOG as free text, Use the </> icon.

What errors to you get?

What encoding do you use? (run proc options).

29         data exp;
30          A1='Andrè';
31          B1='Àerò';
32          A2=translate(A1,'AAAAAAACEEEEIIIIDNOOOOO OUUUUY Saaaaaaaceeeeiiiidnooooo ouuuuy y',
33                          'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþÿ');
34          B2=translate(B1,'AAAAAAACEEEEIIIIDNOOOOO OUUUUY Saaaaaaaceeeeiiiidnooooo ouuuuy y',
35                          'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþÿ');
36          put A2= B2=;
37         run;

A2=Andre B2=Aero

[PGStats]

Try using the BASECHAR function, without a second argument, it simply removes the accents :

y = basechar(x);

[Ksharp · Accepted solution]

Try Ktranslate() as mentioned by @Tom