topic Re: Adding a macron (e.g. café) in SAS Programming

Adding a macron (e.g. ā)

ywon111 — Thu, 28 Oct 2021 06:34:15 GMT

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;

Re: Adding a macron (e.g. café)

ChrisNZ — Wed, 27 Oct 2021 04:47:13 GMT

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

Re: Adding a macron (e.g. café)

ChrisNZ — Wed, 27 Oct 2021 04:49:06 GMT

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

Re: Adding a macron (e.g. café)

ywon111 — Wed, 27 Oct 2021 06:20:37 GMT

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.

Re: Adding a macron (e.g. café)

ChrisNZ — Wed, 27 Oct 2021 06:50:21 GMT

Use the TRANWRD function

Re: Adding a macron (e.g. café)

ChrisNZ — Wed, 27 Oct 2021 07:00:30 GMT

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.

Re: Adding a macron (e.g. café)

Tom — Wed, 27 Oct 2021 12:48:27 GMT

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

Re: Adding a macron (e.g. café)

ywon111 — Wed, 27 Oct 2021 23:14:25 GMT

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.

Re: Adding a macron (e.g. café)

ChrisNZ — Thu, 28 Oct 2021 02:22:25 GMT

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.

Re: Adding a macron (e.g. café)

ywon111 — Fri, 29 Oct 2021 06:02:15 GMT

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

Re: Adding a macron (e.g. café)

ChrisNZ — Fri, 29 Oct 2021 08:07:51 GMT

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