Indeed, you are correct. Unfortunately, it does not like the ods "style" that I've applied.  Users will just have to put up with the warning message. ... View more

Thanks Cynthia, but with htm or html, the file opens in a browser. I do want it to open in Excel, preferably without the message. Since I'm filling the Excel file with proc tabulate output, ods would seem to be the easiest (or only?) option. Users will just have to put up with the warning message. ... View more

Using the XML file extension produces the same result as the xls extension. Are there any other possibilities? Thanks, Bill ... View more

does the response axis data have values outside of the 0 to 100 range? ... View more

An option that I use here is to upload the SAS dataset as a temporary Oracle table. I then have full use of it in the database environment. ... View more

In looking at the translated template specs, I've found the translation created some odd values. Please see below. How do avoid the odd value generation? Thank you, Bill 736   PROC GREPLAY NOFS TC=Template.Templt; TEMPLATE V2; LIST TEMPLATE;RUN; NOTE: Enter greplay commands or statements. V2            1 BOX UP, 1 BOX DOWN Pan Clp Color      Ll-x  Ll-y  Ul-x  Ul-y  Ur-x  Ur-y  Lr-x  Lr-y   1                 50.0   0.0 100.0 100.0 100.0 100.0  50.0724E73   2                  0.0   0.0  50.0 100.0  50.0 100.0   0.0724E73 ... View more

Thanks Cynthia; It appears that I was somewhat too generous in cutting code for posting ... I removed the style_precedence=row in attempt to eliminate the "win" that was happening. Now knowing the constraint that Proc Tabulate can only "win" in one direction now becomes the issue.  I'll have to learn how to use proc report. Thanks for the tip about MSOffice2k anf the tagsets.  I'll have to investigate that too. Thank you for your help, Bill ... View more

Thanks Cynthia; I'm a little further.  What I'm looking for is some way to have row and column banding.  I don't think that's quite possible, so I've tried to use font colour as the the vertical banding method in the example that you sent.  My changes are included below.  I'm not able to make the row bands extend across the entire row.  Please see the Capture.png file attached. I'd appreciate more of your great help. Thank you, Bill proc format; value $ctry 'GERMANY'='yellow'              other='white'; run; ods html file='c:\temp\row_bands.xls'; proc tabulate data=sashelp.prdsale f=comma8.; title '2) Changing Style for Country and Division in Bands'; title2 'The parent for DIVISION classlev is COUNTRY classlev'; title3 'The COUNTRY classlev color is determined by the STYLE override'; * this will change COUNTRY and DIVISION levels to their respective colors; class country division/ style={background=green foreground=black}; classlev country / style={background=$ctry. foreground=black}; classlev division / style=<parent>; ** this will change all PRODTYPE levels to CYAN; class prodtype / style={background=cyan foreground=black}; classlev prodtype /style=<parent>{foreground=black}; var actual /style=<parent>{foreground=black}; ** note use of style=<parent> in row dimension; table country=' '*division=' '*{style=<parent>}, 'Actual'*(sum='Total' *[style=[foreground=black]] max='Max'*[style=[foreground=green]]) box={label="Banding Row Colors for Country and Division"};* style_precedence=row; run; ods _all_ close; ... View more