encoding non-English characters

SAS_AMUH — Tue, 26 Jun 2018 04:07:03 GMT

I am relatively new to the SAS studio.

I have the CSV file that I wanted to import in SAS, which contains Japanese characters.

Without the encoding, the Japanese characters become garbled like this "�".

The below programming code worked for one of the dataset. However, when I tried this for another dataset, some of the columns remained garbled, when all the other columns encoded successfully into the proper Japanese characters.

FILENAME REFFILE '/folders/myfolders/JADE/data.csv' encoding='shift-JIS' ;
PROC IMPORT DATAFILE=REFFILE
DBMS=CSV
OUT=WORK.data replace;
GETNAMES=YES ;
RUN ;

I would really appreciate it if anyone could please help me solve this problem.

Re: encoding non-English characters

Ksharp — Wed, 27 Jun 2018 02:59:19 GMT

Use NotePad++ open data.csv and check the correct encoding at south east corner .

topic encoding non-English characters in SAS Procedures

encoding non-English characters

Re: encoding non-English characters