06-17-2017 07:37 AM
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”
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.
Need further help from the community? Please ask a new question.