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.
... View more