report - ODS EXCEL.TAGSET title statement -
i print text before show result of proc report. ods excel.tagset. title statement. title statement limited 10 titles (title1 title2,...). need more 10 textlines @ output. how can this? have sas9.2.
edit: here code example:
ods tagsets.excelxp style=sasdocprinter file=_webout options(embedded_titles='yes' embedded_footnotes='yes'); title1 'title text row1'; title2 'title text row2'; ... title10 "title text ¯o_var."; footnote1 'footnote text'; proc report data=lib.a; ... run;
given using proc report
, easiest way around may have proc report handle lines of text. in proc report
, have option of doing compute before _page_
, execute prior each time page begun - suspiciously title.
proc report nowd data=sashelp.class; columns sex name age height; define sex/group; define name/display; define age /display; define height/display; compute before _page_; line "title row 11"; line "title row 12"; endcomp; run;
depending on output destination there may row between title , proc report line, can control in destinations (ie, remove it) options if undesirable (or alternately move of title lines this).
Comments
Post a Comment