ods tagsets.excelxp-error

Ronein — Wed, 27 Nov 2019 09:32:04 GMT

Hello

I am using to create XML file (export from SAS).

I am trying to open the result file from excel but I get an error "Problems came in the following areas during load: table"

In SAS log there is no error.

data class_tbl;
set sashelp.class;
if sex='M' then weight=.;
run;


ods _all_ close; 
ods tagsets.excelxp 
file="/My path/example.xml"
style=sasweb
options(embedded_titles='yes'
sheet_interval='none' 
width_fudge='0.75' 
sheet_name="shoes"
default_column_width="10");

ods tagsets.excelxp options(embedded_titles='yes' 
sheet_interval='none'
sheet_name="class");
title "Title - Class";

proc report data=class_tbl nowd nowindows ;
define weight / display 
style(column)=[tagattr='type:Number format:#,##0.00'];
define height / display 
style(column)=[tagattr='type:Number format:#,##0.00'];
define age / display 
style(column)=[tagattr='type:Number format:#,##0.00'];
compute weight;
if weight gt 0 then do;
call define(_col_,'style','style={foreground=black background=white}');
end;
else do;
call define(_col_,'style','style={foreground=white background=white}');
end;
endcomp;
run;

title;

ods tagsets.excelxp close;
ods listing;

Re: ods tagsets.excelxp-error

Kurt_Bremser — Wed, 27 Nov 2019 12:53:50 GMT

Might be an Excel problem. The file opens well in LibreOffice Calc.

topic Re: ods tagsets.excelxp-error in SAS Programming

ods tagsets.excelxp-error

Re: ods tagsets.excelxp-error