Proc report/ ODS tagsets

ali6058 — Sat, 18 Jun 2016 16:19:19 GMT

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.

Re: Proc report/ ODS tagsets

Reeza — Sat, 18 Jun 2016 18:35:15 GMT

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.

topic Re: Proc report/ ODS tagsets in SAS Programming

Proc report/ ODS tagsets

Re: Proc report/ ODS tagsets