Desktop productivity for business analysts and programmers

Import multi language Excel file in SAS using proc import

Accepted Solution Solved
Reply
Contributor
Posts: 35
Accepted Solution

Import multi language Excel file in SAS using proc import

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.


Accepted Solutions
Solution
‎06-18-2017 11:47 PM
Grand Advisor
Posts: 9,576

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

Try DBMS=XLSX or DBMS=EXCEL.

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

View solution in original post


All Replies
Solution
‎06-18-2017 11:47 PM
Grand Advisor
Posts: 9,576

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

Try DBMS=XLSX or DBMS=EXCEL.

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

Contributor
Posts: 35

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

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 145 views
  • 0 likes
  • 2 in conversation