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.