Colleagues: Also, it's ignoring styles set in my style template. SAS note 5076 implies that this was fixed with the v1.130, 08/02/2013 version of the tagset. Am I doing anything wrong? --Adrianate /* I'm using the Excel XP tagset (Compatible with SAS 9.1.3 and above, v1.130, 08/02/2013); SAS note 5076 seems to say that this tagset fixes it; NOTE: SAS (r) Proprietary Software 9.3 (TS1M2) Licensed to CA DEPARTMENT OF TECHNOLOGY, Site 70082650. NOTE: This session is executing on the X64_7PRO platform. */ *””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””; *This is the tagset. Based on the ExcelXP tagset, but with a mod (by Cynthia) to preserve the grid lines ; *””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””; proc template; define tagset tagsets.excelxp_modxx; parent=tagsets.excelxp; define event sub_body; break /if $sub_body; set $sub_body "True"; set $body_class "_body"; put '<Style ss:ID="_body">' nl; put ' <Font ss:FontName="Gill Sans MT" ss:Size="9" />' NL; put "<Interior />" Nl; put '</Style>' nl; set $contents_class "_contents"; put '<Style ss:ID="_contents">' nl; put ' <Interior ss:Pattern="Solid" />' nl; put ' <Protection ss:Protected="1" />' nl; put '</Style>' nl; set $pages_class "_pages"; put '<Style ss:ID="_pages">' nl; put ' <Interior ss:Pattern="Solid" />' nl; put ' <Protection ss:Protected="1" />' nl; put '</Style>' nl; end; end; run; *””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””; *This is the style I'm using; *””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””; proc template; define style styles.excel_xml; parent=styles.minimal; style body/background=transparent topmargin=0.2in bottommargin=0.2in leftmargin=0.2in rightmargin=0.2in; style systemtitle/font_face='Gill Sans MT' font_size=12pt just=center verticalalign=middle cellheight=24pt ; style systemfooter/font_face='Gill Sans MT' font_size=11pt just=left verticalalign=middle cellheight=21pt; style caption/font_face='Gill Sans MT' font_size=11pt cellheight=18pt tagattr='hidden:no'; style beforecaption/font_face='Gill Sans MT' font_size=11pt cellheight=18pt tagattr='hidden:no'; style pageno/font_face='Gill Sans MT' font_size=11pt; style byline/font_face='Gill Sans MT' font_size=11pt; style notecontent/font_face='Gill Sans MT' font_size=10pt verticalalign=middle; style table/font_face='Gill Sans MT' font_size=10pt; style header/font_face='Gill Sans MT' font_size=10pt verticalalign=middle just=center bordertopwidth=1pt borderbottomwidth=1pt; style rowheader/font_face='Gill Sans MT' font_size=10pt verticalalign=bottom just=left borderbottomwidth=0pt bordertopwidth=0pt tagattr='wrap:off'; style data/font_face='Gill Sans MT' font_size=10pt verticalalign=bottom tagattr='wrap:off'; style parskip/cellheight=18pt background=transparent just=left; end; run; *””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””; *Sending the proc tabulate to the xml destination ... ; *””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””; ods listing close; ods proctitle; ods escapechar='^'; ods results off; ods tagsets.excelxp_modxx style=excel_xml file="&desktop.test.xml" options (sheet_interval='bygroup' sheet_label=' ' embedded_titles='yes' embedded_footnotes='yes' suppress_bylines='yes' skip_space='0, 0, 0, 0, 0' row_heights='21, 0, 0, 0, 0, 12, 0' row_height_fudge='6' embed_titles_once='yes' autofit_height='Yes' width_fudge='0.45'); options pageno=1; proc tabulate noseps data=sashelp.cars(where=(make<'C')) f=comma10. ; class make; class model; classlev model/style=[width=1.8 in]; var horsepower; var weight; table make=' ', model=' ', sum=' '*(horsepower weight*[style={tagattr='format:##,##0'}])/rts=40; run; ods tagsets.excelxp_modxx close; ods listing;
... View more
