Thank you everyone for your help. I got the box plots to alternate colors by assigning the colors based on the treatment and then using the cboxfill=(color variable name) as described above. ... View more

Here is an example of how to use ODS PDF directly to put multiple graphs on a page. I did one example using SGPLOT and the other using GCHART: /* SG Procedure example */ ods pdf columns=2 startpage=no; proc sort data=sashelp.prdsale out=temp; by product; run; Title "Department Sales by Product"; proc sgplot data=temp; by product; hbar quarter / response=actual; run; ods pdf close; /* GCHART example */ goptions reset=all hsize=3.5in vsize=2.5in; ods pdf columns=2 startpage=no; proc sort data=sashelp.prdsale out=temp; by product; run; Title "Department Sales by Product"; proc gchart data=temp; by product; hbar quarter / sumvar=actual discrete nostat; run; ods pdf close; ... View more

Hi Risk. I have the sas code below. The goal is to find those treatment combinations are responsible for the interaction in the data, and write a report that summarizes all of the information in the data. My attempts; There is interaction between polymers and additives,also days significant. My problem is to find those treatment combinations responsible for interaction. Can I use polynomial contrasts or assume c1 to be the control and use equal spacing to calculate t-statistic and use fisher's or Bon LSD? But the problem is that the additives are on the same level. I looked confused um! B A DAY TS B A DAY TS B A DAY TS Mylar c1 1 9.2 Nylon c1 1 8.2 Peth c1 1 9.2 Mylar c2 1 8.7 Nylon c2 1 7.7 Peth c2 1 13.4 Mylar c3 1 9.1 Nylon c3 1 11.4 Peth c3 1 9.7 Mylar c4 1 12.4 Nylon c4 1 8.1 Peth c4 1 9.1 Mylar c5 1 10.5 Nylon c5 1 9.5 Peth c5 1 8.5 Mylar c1 2 8.2 Nylon c1 2 7.2 Peth c1 2 8.4 Mylar c2 2 8.7 Nylon c2 2 7.7 Peth c2 2 12.5 Mylar c3 2 8.8 Nylon c3 2 10.5 Peth c3 2 9.1 Mylar c4 2 11.5 Nylon c4 2 7.8 Peth c4 2 9.1 Mylar c5 2 10.6 Nylon c5 2 9.6 Peth c5 2 8.9 Mylar c1 3 8.4 Nylon c1 3 7.4 Peth c1 3 8.2 Mylar c2 3 8.3 Nylon c2 3 7.8 Peth c2 3 8.5 Mylar c3 3 8.7 Nylon c3 3 7.3 Peth c3 3 8.8 Mylar c4 3 8.5 Nylon c4 3 7.7 Peth c4 3 8.1 Mylar c5 3 8.8 Nylon c5 3 7.1 Peth c5 3 8.3 Obtain a complete analysis of the data that includes finding those treatment combinations are responsible for the interaction in the data, and write a report that summarizes what you believe to be all of the information in the data. data ribbon; input days polymers $ additives $ TS; cards; 1 mylar c1 9.2 1 mylar c2 8.7 1 mylar c3 9.1 1 mylar c4 12.4 1 mylar c5 10.5 1 peth c1 9.2 1 peth c2 13.4 1 peth c3 9.7 1 peth c4 9.1 1 peth c5 8.5 1 nylon c1 8.2 1 nylon c2 7.7 1 nylon c3 11.4 1 nylon c4 8.1 1 nylon c5 9.5 2 mylar c1 8.2 2 mylar c2 8.7 2 mylar c3 8.8 2 mylar c4 11.5 2 mylar c5 10.6 2 peth c1 8.4 2 peth c2 12.5 2 peth c3 9.1 2 peth c4 9.1 2 peth c5 8.9 2 nylon c1 7.2 2 nylon c2 7.7 2 nylon c3 10.5 2 nylon c4 7.8 2 nylon c5 9.6 3 mylar c1 8.4 3 mylar c2 8.3 3 mylar c3 8.7 3 mylar c4 8.5 3 mylar c5 8.8 3 peth c1 8.2 3 peth c2 8.5 3 peth c3 8.8 3 peth c4 8.1 3 peth c5 8.3 3 nylon c1 7.4 3 nylon c2 7.8 3 nylon c3 7.3 3 nylon c4 7.7 3 nylon c5 7.1 ; proc GLM data =ribbon; Class days polymers additives; model TS= days polymers| additives; Lsmeans days polymers | additives/pdiff stderr; run; quit; ... View more

Hi Art, Thank you for your links. I did take the plunge and worked a bit with annotate. I used one of your documents that I found online. It was very clearly written and very helpful. I am sure that as I move forward I will have more questions, but meanwhile thanks for your help. Natanya ... View more

Brilliant! Thanks so much for your help and attention. ... View more

Hi: As Scott suggests, searching the forum archives is a great idea, since there have been many previous forum postings on this topic. Basically, Excel does not respect SAS formats for leading zeroes -- even if the number is a character value in the SAS end of things, if Excel detects numbers, it applies a General number format to the cell which strips any leading zeroes. This is Microsoft behavior and the only way to impact the behavior is to send a Microsoft format from SAS to Excel. You can either use a format to tell Excel that the number is a character variable or you can use a format to just put leading zeroes into the number. With HTML-based destinations, the HTMLSTYLE= style attribute is the way you would send a Microsoft format from SAS to Excel. These two previous forum postings show how to use HTMLSTYLE: http://support.sas.com/forums/thread.jspa?messageID=41019ꀻ http://support.sas.com/forums/thread.jspa?messageID=8753∱ Do note that in SAS 9, you may want to use ODS MSOFFICE2K instead of ODS HTML -- because MSOFFICE2K uses Microsoft flavor of HTML tags and Excel is "happier" rendering those tags instead of ODS HTML tags which are HTML 4.0 tags (and Excel doesn't like those tags as well). cynthia ... View more