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.
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.