XLSX engine

Ronein — Mon, 16 Jun 2025 05:49:24 GMT

Hello

I am using sas engine to export data set into XLSX file.

I get warning :

WARNING: Some character data was lost during transcoding data

This char is written in Hebrew

What should I do?

Note- when i am using proc export it is working 100% well wit no warnings

%include '!RSMEHOME/SASCode/SHARECode/Libname.sas';
proc export data=Sheets_info_tbl
outfile="/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/Bakara_General_Fields/Only_833_703_noKSH_noPepper/Bakara.xlsx"
DBMS=xlsx replace;
sheet='POP';
run;
proc export data=r_r.BakaraFields_Part1Report_A 
outfile="/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/Bakara_General_Fields/Only_833_703_noKSH_noPepper/Bakara.xlsx"
DBMS=xlsx replace;
sheet='P1_833_703_noKSH';
run;
proc export data=r_r.BakaraFields_Part2Report_A 
outfile="/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/Bakara_General_Fields/Only_833_703_noKSH_noPepper/Bakara.xlsx"
DBMS=xlsx replace;
sheet='P2_833_703_noKSH';
run;

As I sais when use XLSX engine I get warning and cannot open the XLSX file

libname myxl xlsx  "/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/Bakara_General_Fields/Only_833_703_noKSH_noPepper/Bakara.xlsx";
data myxl.POP; /**SHEET1--POP**/
set Sheets_info_tbl;
run;
data myxl.P1_833_703_noKSH; /**SHEET2--P1_833_703_noKSH**/
set ttt1;
run;
data myxl.P2_833_703_noKSH; /**P2_833_703_noKSH**/
set ttt2;
run;

Re: XLSX engine

Kurt_Bremser — Mon, 16 Jun 2025 07:14:03 GMT

Which encoding does your SAS session use?

Re: XLSX engine

Ksharp — Mon, 16 Jun 2025 08:10:27 GMT

Try EXCEL engine.

libname myxl excel  "c:\temp\temp1.xlsx" ;
data myxl.class;
set sashelp.class;
run;

topic Re: XLSX engine in SAS Programming

XLSX engine

Re: XLSX engine

Re: XLSX engine