Hi,
i was able to output the dataset final in to test.xml without a problem. The variable comments holds free text so it may contain charcters more than 4000 etc.when i output, instead of having the comments in one single line which is hard to read for the user , i would like to see them wrapped in cell.
ods listing close;
ods tagsets.ExcelXP file="path\test.xml" options(sheet_interval='bygroup'
sheet_label=' '
embedded_titles='yes'
suppress_bylines='yes');
proc report data = final nowd;
by dsname;
column comments;
define source / flow;
run;
ods tagsets.excelxp close;
ods listing close;
Thanks in Advance
Al.