Sanjay; Right before i saw your email I realize the error. I had set the graph elements however I forgot to actually call the styles statement in the ods output in that  I needed. ods pdf file='c:\xxx.pdf' style=Styles.newstyle proc sgrender data=HAP template=BarLineMultC; WHERE '01JAn11'D<=MONTH<intnx('month',today(),&monthminr); run; ods pdf close; Thanks again to you and Dan on this-I apologize for not getting "my nose" off the ground. Lawrence ... View more

Sanjay; My render statement is as follows- proc sgrender data=HAP template=BarLineMultC; WHERE '01JAn11'D<=MONTH<intnx('month',today(),&monthminr); run; However, please see the code I had posted above to Dan. In Dan's blog I did not see any special calls to the index in the sgrender statement. I still need to change the colors for the scatterplot outputs. Thanks. Lawrence ... View more

OK Dan- I think I am doing something wrong wrong here as the colors don't render as desired. Here is the snippet of the data set to create the index. It creates three values depending on if the rate is above,below, or the last month of interest- I essentially render the grp_colors the same values. proc sql; create table HAPG as select fac_id,rate,month, case when month='01DEC12'D then 3 when rate<=5.3 then 1 when rate>5.3 then 2  end as grp_color, case when month='01DEC12'D then 3 when rate<=5.3 then 1 when rate>5.3 then 2  end as index, case when month='01DEC12'D then left(put(rate,8.1)||'*') else left(put(rate,8.1)) end as rpt_pbl from HAPS4 ORDER BY FAC_ID,month; QUIT; Below is the template-I used wild colors just to help me learn this- The statements in green are the graphdata elements and the scatterplot element I am trying to code accordingly. Many thanks again. Lawrence proc template; define style Styles.XCL; parent=STYLES.Printer; replace GraphFonts / 'GraphDataFont' = ("arial",6pt)                       'GraphUnicodeFont' = ("arial",6pt)                          'GraphValueFont' = ("arial",6pt)                      'GraphLabelFont' = ("arial",6pt,bold)                'GraphFootnoteFont' = ("arial",6pt)                  'GraphTitleFont' = ("garamond",8pt,bold)                'GraphAnnoFont' = ("arial",10pt);  class LayoutContainer /                                                         padding = 0                                                                  borderspacing = 4                                                           borderwidth = 0                                                              frame = void                                                                 rules = none           background=white;         style Header /                                                                  font = fonts('HeadingFont')                                                  /*backgroundcolor = white */                                                  bordercolor = cxC1C1C1                                                       bordertopwidth = 0px                                                         borderleftwidth = 0px                                                        borderbottomwidth = 1px                                                      borderrightwidth = 1px;     class systemTitle, systemfooter  /             /*foreground=white*/              background = white;      style sysTitleAndFooterContainer from sysTitleAndFooterContainer /              cellspacing=0; style Graphdata1 /contrastColor=pink; style Graphdata2 /contrastColor=orange; style Graphdata3 /contrastColor=blue; /*style Graphdata3 /Color=orange;*/ end; define statgraph BarLineMultC;     begingraph;     /*entrytitle halign=right   TEXTATTRS=(size=11pt color=&COLOR1)   " "  ;      entrytitle halign=right   TEXTATTRS=(size=9pt) " "  ;      entrytitle halign=right   TEXTATTRS=(size=9pt) " "  ;*/        layout overlay / xaxisopts=(display=(line ticks tickvalues ) offsetmin=0.03 offsetmax=0.03                  timeopts=( tickvaluefitpolicy=rotatethin interval=month /*viewmin= &graphdate* viewmax='01DEC12'D*/))  yaxisopts=(LABEL=('HAP RATE PER 1000 Admits') offsetmin=0.05 offsetmax=0.05 griddisplay=on) ;            referenceline y=5.3 /lineattrs=graphdatadefault(thickness=3 color=black);        seriesplot x=month y=trendhat / lineattrs=graphdatadefault(thickness=3 color=purple) name="TREND LINE"    LEGENDLABEL="TREND LINE" ;           seriesplot x=month y=RATE / lineattrs=graphdatadefault(thickness=3 color=black) name="HAP RATE PER 1000 ADMITS"    LEGENDLABEL="HAP RATE PER 1000 ADMITS" ;                scatterplot x=month y=RATE / GROUP=grp_color index=index  includemissinggroup=false  markerattrs=(symbol=circlefilled size=23);           scatterplot x=month y=RATE /includemissinggroup=false markerattrs=(symbol=circle size=24 color=black) ;           scatterplot x=month y=RATE /discreteoffset= -0.1 includemissinggroup=false markercharacter=rpt_pbl   markercharacterattrs=(color=white weight=bold );                     discretelegend   "HAP RATE PER 1000 ADMITS"  "TREND LINE" "Prelim" /     location=outside  valign=bottom;          endlayout;      endgraph;   end;   run; ... View more

I will try the indexing option, but then if I set the style Graphdata1 /Color=orange for example, then if index=1 it should correlate to orange then? I will give it a go. Thanks Lawrence ... View more

I was just reading the comments in his blog. Yes the attribute maps only applies in 9.3 unfortunately. Aaargh. I still cannot control the markercharacterattrs to my liking. Thanks. Lawrence ... View more

Sanjay; IS there a way to actually figure out what GraphData1-N style elements apply to what? In the section below, the colors are rendered, but I can't seem to control them-they come out blue,red, and green. Thanks Lawrence        layout overlay / xaxisopts=(display=(line ticks tickvalues ) offsetmin=0.03 offsetmax=0.03                  timeopts=( tickvaluefitpolicy=rotatethin interval=month /*viewmin= &graphdate* viewmax='01DEC12'D*/))  yaxisopts=(LABEL=('HAP RATE PER 1000 Admits') offsetmin=0.05 offsetmax=0.05 griddisplay=on) ;            referenceline y=5.3 /lineattrs=graphdatadefault(thickness=3 color=black);        seriesplot x=month y=trendhat / lineattrs=graphdatadefault(thickness=3 color=purple) name="TREND LINE"    LEGENDLABEL="TREND LINE" ;           seriesplot x=month y=RATE / lineattrs=graphdatadefault(thickness=3 color=black) name="xxx RATE PER 1000 ADMITS"    LEGENDLABEL="xxx  RATE PER 1000 ADMITS" ;                 scatterplot x=month y=RATE / GROUP=grp_color  includemissinggroup=false  markerattrs=(symbol=circlefilled size=23);           scatterplot x=month y=RATE /includemissinggroup=false markerattrs=(symbol=circle size=24 color=black) ;           scatterplot x=month y=RATE /discreteoffset= -0.1 includemissinggroup=false markercharacter=rpt_pbl   markercharacterattrs=(color=white weight=bold ); ... View more

Reeza; The link is interesting. However, does this apply to SAS 9.2? It seems to fail to recognize the directives for the GTL language. Thanks. Lawrence ... View more

Sanjay & Reeza- Many Thanks. I will take a look. Lawrence ... View more

Sanjay; I have been hunting around and I did notice the syntax group= does not follow the MARKERATTRS option. However I have seen it listed as a general option  listed in some of the other white papers I have seen, so is this a viable option? I have also figured out that if I list style Graphdata3 /contrastcolor=lightgreen  for example instead of color it does control the background color of the scatterplot. However when I use the group function in conjunction with a Graphdata4 element it is moot and I get a black circle again. Removing the CYCLEATTRS option on the overlay has no effect w/ or without the added graphdata elements. Thanks again for your help. Lawrence ... View more

Cynthia; Well I have to say that you beat me to the punch on the next question! I was just working my way down the chain. Thanks for looking at the code and helping out with it. That snippet of code is quite helpful to know. Yes, this is a fairly complex report (in my mind) to emulate the Excel template. I have to say that your assistance (and others at SAS) keeps me going on these projects! Thanks again- Lawrence ... View more

Cynthia; Thanks for the tip on the "placeholder" issue-I knew I was close, but was off on the syntax. I do like your idea on splitting the report-it may get a little complicated as I have another "report" in there in that I had used Proc Report to fake a report header at the top that connects through to other pages in the report. Duly noted on attempting to muck with the gridlines. I will leave as is. Code is below and is only for one page (of 6) of entire report. Thanks for your assistance once again! Lawrence ods escapechar="\"; ods listing gpath="P:\" ; ods graphics on/reset=all antialias=on width=9in height=5in border=no; options  nodate nonumber center leftmargin=.25in rightmargin=.25in topmargin=.05in bottommargin=.15in orientation=landscape; symbol v = dot ; ods pdf file='P:\xxx JULY 2012a.pdf'  style=Styles.XCL dpi=300; ods pdf anchor='menu'; proc report data=b nowd spanrows NOCENTER STYLE(column)={background=white borderbottomcolor=white borderleftcolor=white bordertopcolor=white borderrightcolor=white fontsize=0pt cellpadding=0pt cellspacing=0pt} STYLE(header)={ cellspacing=0pt cellpadding=0pt color=white background=blue borderbottomcolor=black borderbottomwidth=1pt  borderleftcolor=black borderleftwidth=1pt bordertopcolor=black bordertopwidth=1pt borderrightcolor=black borderrightwidth=1pt}; columns a b c d e; define a/'Report Menu' STYLE(Header)= {URL="#menu"}; define b /'Scorecard' STYLE(Header)= {URL="#score"}; define c /'Trend Charts' STYLE(Header)= {URL="#trend"}; define d /'Control Charts' STYLE(Header)= {URL="#control"}; define e /'Definitions' STYLE(Header)= {URL="#definitions"}; run; ods pdf text="\S={leftmargin=1.5in preimage='T:\Hospital Reporting Team\Inp Quality Analytic Team\HA-CDI\HA-CDI Dashboard\TEMPLATE\xxx.bmp'  font_size=7 font_weight=bold}  xxx"; ods pdf startpage=no; proc report data=measuresIII  headline headskip nowd spanrows style(report)={font_size=6pt cellpadding=1pt cellspacing=1pt} style(column) = {font = ("arial",6.0pt) just=center} ;; columns fac_id color colorstar pctchange COLORSCHEME ('PROCESS' ("\{style[foreground=white]Placeholder}"  ComplianceHHa,ComplianceHH complianceISOa,complianceISO DOT_1000a,DOT_1000 complianceATPa,complianceATP)) _emp ('OUTCOME'('1 Month' numa,num /*lastmoa,lastmo*/)  ('3 Months' lastmoa3,lastmo3)  ('12 Months' numa12,num12 lastmoa12,lastmo12)) ; define _emp/' ' style={width=.3% background=white color=white}; DEFINE colorstar/' '  style(header)={background=white} noprint analysis; DEFINE color/' ' noprint analysis; DEFINE FAC_ID/group 'STUDY PERIOD---->'  order format=$code. style(header)={background=white} style(column)={LINKCOLOR=black background=white color=black}; DEFINE numa/ACROSS ' '  style(header)={background=white}; DEFINE num/"MAY12" center  style(header)={background=yellow}; DEFINE lastmoa/ACROSS ' '  style(header)={background=white}; DEFINE lastmo/ "MAY12" center   style(header)={background=yellow}; DEFINE numa3/ACROSS ' '  style(header)={background=white}; DEFINE num3/"MAR12/to/MAY12" center   style(header)={background=yellow}; DEFINE lastmoa3/ACROSS ' ' style(header)={background=white}; DEFINE lastmo3/"MAR12/to/MAY12*" center style(header)={background=yellow}; DEFINE numa12 /ACROSS ' ' style(header)={background=white}; DEFINE num12/ "JUN11/to/MAY12" center  style(header)={background=yellow} ; DEFINE lastmoa12/Across ' ' style(header)={background=white}; DEFINE lastmo12/"JUN11/to/MAY12" center   style(header)={background=yellow}; DEFINE pctchange/' ' noprint analysis;  DEFINE ComplianceHHa /across ' ' style(header)={background=white}; DEFINE ComplianceHH /"Q2 2012" style(header)={background=yellow} format=percent10. style(column)=[background=sigf. color=sigg.]; DEFINE complianceISOa /across ' ' style(header)={background=white}; DEFINE complianceISO /"&DATEMACRO" style(header)={background=yellow} format=percent10. style(column)=[background=sigb. color=sigc.]; DEFINE DOT_1000a /across ' ' style(header)={background=white}; DEFINE DOT_1000 /"&DATEMACRO" style(header)={background=yellow}; DEFINE complianceATPa /across ' ' style(header)={background=white}; DEFINE complianceATP /"&DATEMACRO" style(header)={background=yellow} format=percent10. style(column)={background=sigd. color=sige.}; DEFINE colorscheme/ analysis noprint; compute COMPLIANCEATP;        if colorscheme.sum=0 then call define(_COL_,'style','style={background=lightgray color=lightgray}');        /*else if FACILITY in ('ZZC','ZTO')  then call define(_ROW_,'style','style={background=lightgray color=black}');        else if FACILITY in ('ZTO')  then call define(_ROW_,'style','style={background=lightgray color=black }');*/ endcomp; compute lastmo3; if fac_id not in ('ZZC','AAZ','ZTO') and pctchange.sum=1 then call define(_COL_,'style','style={preimage="T:\Hospital Reporting Team\Inp Quality Analytic Team\HA-CDI\HA-CDI Dashboard\FORMATS\green_arrow.bmp"}'); if fac_id not in ('ZZC','AAZ','ZTO') and pctchange.sum=0 then call define(_COL_,'style','style={preimage="T:\Hospital Reporting Team\Inp Quality Analytic Team\HA-CDI\HA-CDI Dashboard\FORMATS\red_arrow.bmp"}'); endcomp; compute num; if colorstar.sum=1 then call define(_COL_,'style','style={background=white preimage="T:\Hospital Reporting Team\Inp Quality Analytic Team\HA-CDI\HA-CDI Dashboard\FORMATS\greenstar.bmp"}'); if fac_id not in ('ZZC','ZTO') and colorstar.sum=0 then call define(_COL_,'style','style={background=white preimage="T:\Hospital Reporting Team\Inp Quality Analytic Team\HA-CDI\HA-CDI Dashboard\FORMATS\blank.bmp"}'); if fac_id in ('ZZC','ZTO')  then call define(_COL_,'style','style={color=lightgray}'); *if fac_id in ('AAZ')  then call define(_COL_,'style','style={color=white}'); endcomp; compute fac_id;        /*urlstring=compress("#"||fac_id);*/      /* IF fac_id NOT IN ('AAZ','ZZC') then call define(_COL_,'url',urlstring) ;*/       if fac_id in ('ZTO')  then call define(_ROW_,'style','style={background=lightgray color=black}');        if fac_id in ('ZTO')  then call define(_COL_,'style','style={background=lightgray color=black}');       if fac_id in ('ZZC')  then call define(_ROW_,'style','style={background=lightgray color=black}');       if fac_id in ('AAZ')  then call define(_ROW_,'style','style={background=white color=black  FONTWEIGHT=bold}');       *IF fac_id in ('ZTO') then line ' '; endcomp; compute lastmo12; if fac_id not in ('ZZC','AAZ','ZTO') and color.sum=1  then call define(_COL_,'style','style={background=blue color=white}'); if fac_id not in ('ZZC','AAZ','ZTO') and color.sum=0  then call define(_COL_,'style','style={background=red color=black}'); endcomp; compute _emp; if fac_id in ('ZTO','ZZC','AAZ')  then call define(_COL_,'style','style={background=lightgray color=lightgray}'); endcomp; run; ods pdf close; ... View more