DATA Step, Macro, Functions and more

Proc report/ ODS tagsets

Reply
Regular Learner
Posts: 1

Proc report/ ODS tagsets

 

 

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.

Super User
Posts: 17,828

Re: Proc report/ ODS tagsets

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.

Ask a Question
Discussion stats
  • 1 reply
  • 165 views
  • 0 likes
  • 2 in conversation