INTERNATIONAL PHONETIC ALPHABET

[arielaor]

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?

[andreas_lds]

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.

[RW9]

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.

[arielaor]

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.

[RW9]

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?

[arielaor]

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

[RW9]

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