Hi all,   Probably a simple question for experienced ODS people.  I have a template that is a modification of styles.rtf.  See below (I took out a bunch of font stuff). I'm getting titles starting on the second page.  How do I get them to start on the first page?     I'm using  ods tagsets.rtf file="xx.rtf" options(continue_tag='ON') style=bodydoc10; title1 j=l "&tt1"; title2 j=l "&tt2"; ;   Here's the code for the style:   proc template; edit styles.rtf as styles.bodydoc10; style pageno from pageno / font=fonts("StrongFont") TopMargin=0.5in RightMargin=0.75in pretext="Page " posttext=" of ^{lastpage} "; replace Body from Document / bottommargin = _undef_ topmargin = _undef_ rightmargin = _undef_ leftmargin = _undef_; style table from container / cellpadding=2 cellspacing=2 borderwidth=2 rules = cols frame = box background = _undef_; style header / posttext="^R/RTF'\brdrb\brdrhair\BRDRCF1'" background=white font_face="Courrier New"; style rowheader from header ; style color_list "Colors used in the default style" / 'link' = black 'bgH' = white 'fg' = black 'bg' = white; style table from output/ background = _undef_ frame=hsides rules=groups cellpadding = 2pt cellspacing = 0pt borderwidth = 1pt; style byline from bylinecontainer / font_size=7.5 ; /* Controls by var fontsize for by lines(wilcoxon).*/ end; run;   Thanks!! ... View more

Hi all,   I keep getting this warning  WARNING: Failed to scan text length or time type for column xxx   I'm using the Excel libname and reading the file with the data step.  I have already checked the registry and TypeGuessRows=0.   I read the same file repeatedly and get this message for the same column every time.  I tried forcing a length:  set ln."Tabname$"n (dbsastype = (xxx= 'char(500)')); but that doesn't work.      There's no problem with the data.  I just don't want to see this message in the log.   V9.2.    Anyone have any suggestions?     Thanks. ... View more

Hi all,   Here's a weird situation.  I have an excel file that has named ranges.  When I read the original using... libname spec excel "<original location>\&currentspec" mixed = yes access=readonly; ...I can see the named ranges in the SPEC libname. But when I copy the file with...  %sysexec copy "<original location>\&currentspec" "<new location>\&currentspec"; ...I can see the ranges when I open the copy in Excel but can't see them when I read the file with the same libname statement as above.    libname spec excel "<new location>\&currentspec" mixed = yes access=readonly;   Thoughts?      ... View more