Adding a macron (e.g. ā)

[ywon111]

Hi

Hoping to get some help. Is there a way to create a dataset that convert from Maori to Māori?

data one;

length name $30;
input name;
datalines;
Maori
;
run;

[ChrisNZ]

And do you have a list of words that match cafe to café?

[ChrisNZ]

é uses an acute accent by the way. A macron is horizontal, as in Māori.

[ywon111]

I actually have a big dataset with people's ethnicity and Maori, NZ Pākehā is the two that needs to be reformatted so it can be presented in a proper way.

[ChrisNZ · Accepted solution]

Use the TRANWRD function

[ChrisNZ]

If this fails you'll have to use K functions. Sorry I can't test as I don't have UTF8 handy. KTRANWRD doesn't exist, so you'll have to do something a bit more convoluted.

[Tom]

There is no need for KTRANWRD() as TRANWRD() already handles replaces strings with strings that have a different number of bytes.

[ywon111]

Thanks!! Threw an error but almost there I think. Any help will be much appreciated.

if Ethnic_group="Maori" then Ethnic_group="Māori";

Error:

An error occurred executing the workspace job "XXX".

Integration technologies failed to submit the code. [Error'

Failed to transcode data from U_UTF8_CE to U_LATIN1_CE encoding because it contained characters which are not supported by your SAS session encoding. Please review your encoding= and locale= SAS system options to ensure that they can accommodate the data that you want to process.

[ChrisNZ]

You use wlatin1 encoding.

This encoding does not know what character ā is. It cannot store it.

You need your SAS session to use another encoding, probably UTF8.

Encoding is a SAS startup option, and it will also change the encoding used by your SAS data sets.

[ywon111]

Is there a step by step process to add UTF8 encoding to allow other users running the code to show the macrons?

[ChrisNZ]

This is probably over cautious, but is also comprehensive https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/movefile/n06qan4j3ffr6fn11bs4q11r8r56.htm