Help using Base SAS procedures

encoding non-English characters

Reply
Occasional Contributor
Posts: 5

encoding non-English characters

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.

Super User
Posts: 10,778

Re: encoding non-English characters

Use NotePad++ open data.csv and check the correct encoding at south east corner .
Ask a Question
Discussion stats
  • 1 reply
  • 92 views
  • 0 likes
  • 2 in conversation