Import multi language Excel file in SAS using proc import

anandsasbi — Sat, 17 Jun 2017 11:37:19 GMT

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.

Re: Import multi language Excel file in SAS using proc import

Ksharp — Sat, 17 Jun 2017 13:10:51 GMT

Try DBMS=XLSX or DBMS=EXCEL.

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

Re: Import multi language Excel file in SAS using proc import

anandsasbi — Mon, 19 Jun 2017 03:49:32 GMT

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

topic Re: Import multi language Excel file in SAS using proc import in SAS Enterprise Guide

Import multi language Excel file in SAS using proc import

Re: Import multi language Excel file in SAS using proc import

Re: Import multi language Excel file in SAS using proc import