topic Re: INTERNATIONAL PHONETIC ALPHABET in SAS Programming

INTERNATIONAL PHONETIC ALPHABET

arielaor — Fri, 26 Jan 2018 05:07:27 GMT

I have to analysis a Excel file including mainly IPA (International phonetic language) characters, I am trying to import it using SAS enterprise guide, I have to analyze the variables which include IPA characters.

How can it be done?

Re: INTERNATIONAL PHONETIC ALPHABET

andreas_lds — Fri, 26 Jan 2018 07:01:39 GMT

What you should do depends largely on the SAS modules available at your site.

Import could be done by using libname-statement, proc import or the data import wizard.

To suggest something for further steps you have to explain "analyze" is detail.

Re: INTERNATIONAL PHONETIC ALPHABET

RW9 — Fri, 26 Jan 2018 09:06:29 GMT

Please review how to post a good quest. Shouting a thread title which is not a good title, and providing no detail is not going to get you any answers. Start by not writing all in UPPERCASE. Provide test data in the form of a datastep showing what you have, show what you want out, provide explanations of the logic between.

Re: INTERNATIONAL PHONETIC ALPHABET

arielaor — Fri, 26 Jan 2018 12:03:06 GMT

I tried to import to SAS the file (appended) prtest.xlsx, I used IMPORT fron SAS ENTREPISE GUIDE 7.15.

In the EXcel file Variables Target and Output include special IPA characters, in the resulting SAS DATA FILE (***.sas7bdat) all the vowel characters and other characters appear as question sign (?).

How can I make SAS ENTREPISE GUIDE read correctly into the SAS DATA FILE these special characters- this characters are part of the UNICODE encoding.

I have SAS 9.4(with UNICODE SUPPORT) for further analysis.

Re: INTERNATIONAL PHONETIC ALPHABET

RW9 — Fri, 26 Jan 2018 12:26:14 GMT

First I would check your EG setup is setup for UTF16, got to say I haven't come across those symbols before, but if they are in Unicode and your system is setup as UTF16 then it should read them ok. Did you check with your SAS/IT group?

Re: INTERNATIONAL PHONETIC ALPHABET

arielaor — Sat, 27 Jan 2018 10:50:54 GMT

My EG setup is encoding= WLATIN1 (OPTIONS statement in PROGRAM), i tried to change the encoding option but it can be done only at setup.

The windows 10 command line does not work.

In all config files in EG library i see such as loggin.config or SEguide.exe.config in the first line i find encoding=UTF-8.

How can i change the current (WLATIN1) encoding to UTF-8 or UTF-16.

Thanks,

Arie

Re: INTERNATIONAL PHONETIC ALPHABET

RW9 — Mon, 29 Jan 2018 09:41:26 GMT

You would need to speak with the IT person responsible for the system, and have them setup a UTF encoded session for you.