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;
