topic Re: Replace special characters in SAS Programming

Replace special characters

anjankumar08 — Wed, 11 Nov 2020 01:10:28 GMT

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

Re: Replace special characters

ChrisNZ — Wed, 11 Nov 2020 01:17:26 GMT

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?

Re: Replace special characters

ChrisNZ — Wed, 11 Nov 2020 01:18:22 GMT

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

Re: Replace special characters

anjankumar08 — Wed, 11 Nov 2020 01:29:33 GMT

Below is my code.

data exp;
x='Andrè';

A = 'Àerò';

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

Re: Replace special characters

anjankumar08 — Wed, 11 Nov 2020 01:33:14 GMT

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

Re: Replace special characters

ChrisNZ — Wed, 11 Nov 2020 02:09:40 GMT

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

Re: Replace special characters

PGStats — Wed, 11 Nov 2020 04:00:18 GMT

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

y = basechar(x);

Re: Replace special characters

Ksharp — Wed, 11 Nov 2020 12:04:20 GMT

Try Ktranslate() as mentioned by @Tom