Proc report/ ODS tagsets

[ali6058]

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.

[Reeza]

In general, if there's a feature for tagsets you need you can look it up in the paper/link below and it will tell you where to find information.

http://www.sas.com/events/cm/867226/ExcelXPPaperIndex.pdf

In this case you're looking for the AUTOFIT_HEIGHT option. See the paper index and corresponding paper for details and an example if required.