Import multi language Excel file in SAS using proc import

[anandsasbi]

I have multiple excel file as source. Some source file having data in Semi Chinese & traditional Chinese language.

I am using below proc import code for import excel file (.xls) . For English version file it working fine but same code not working for Semi Chinese & traditional Chinese , Output coming in unreadable format. I have also selected server U8 ( In my case it is GridSASApp_U8).

%let Sheetname = “Testdata”;

Proc Import out = work.Test1

DATAFILE = “/GridPath/Source/External_trad_chinese_sample.xls”

DBMS=XLS REPLACE;

SHEET=&Sheetname.;

Run;

I am using SAS EG 6.1 (32-bit)

I am able to read this Chinese version file through wizard ( File  -> Import data) using server GridSASApp_U8 but I can’t use code which Auto generated by “Import data” because  Auto generated code using Dataline in  Infile statement under data step .

I have to change file location & file name based on condition.

Could you please suggest me that what change require in proc Import code in order to import multi language file under GridSASApp_U8 server.

[Ksharp · Accepted solution]

Try DBMS=XLSX or DBMS=EXCEL.

XLS would not work on Chinese,Japanese,Korean.... these double byte  character .

[anandsasbi]

Thanks for your reply, Now it's working after change Excel file xls to xlsx .