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 &macro_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

Popular posts from this blog

plot - Remove Objects from Legend When You Have Also Used Fit, Matlab -

java - Why does my date parsing return a weird date? -

Need help in packaging app using TideSDK on Windows -