01-26-2018 12:07 AM
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?
01-26-2018 02:01 AM
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.
01-26-2018 04:06 AM
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.
01-26-2018 07:03 AM
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.
01-26-2018 07:26 AM
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?
01-27-2018 05:50 AM
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.