Hi, I have a proc report preceded by 2 tiles(title1& title2). I have a background color for titles. There seems to be a small space between the 2titles. I am trying to eliminate this using the SystemTitleAndFooterContainerand TitleAndNoteContainer class of the style I am using. Did not work. Below is my proc template and proc report.                                                                                                                                                                                                                           proc template;     define style duals;         parent=    styles.plateau;         style GraphColors from graphcolors /             "gdata1"=cx3230b2             "gdata2"=cxb2309e                        "gcdata1" = cx000000             "gcdata2" = red             "gcdata3" = cx000000             "gramp3cend" = cxaa081b                                                          "gramp3cneutral" = cx000000                                                      "gramp3cstart" = cx1ba808;         style GraphFonts from GraphFonts                                                                  "Fonts used in graph styles" /              'GraphTitleFont' = (", ",8pt,bold)             'GraphLabelFont' = (", ",8pt)             'GraphValueFont' = (", ",8pt)             'GraphDataFont' = (", ",7pt)             'GraphAxisFont' = (", ",6pt)         ;         class table, header, data/             /*backgroundcolor=white             */             color=black             fontfamily=" Arial, Verdana"             fontsize=8pt ;         class body/             backgroundcolor=white             color=black             fontfamily=" Arial, Verdana"             fontsize=8pt             borderstyle=none pagebreakhtml=_undef_;         class SystemTitleAndFooterContainer /             padding=1             rules = NONE       frame = VOID       width = 100%       padding = 0       borderspacing = 0         backgroundcolor=#f5f5f5       borderwidth = 0 cellspacing=0 ;    class TitleAndNoteContainer /       rules = NONE       frame = VOID       width = 100% backgroundcolor=#f5f5f5       padding = 0       borderspacing = 0       borderwidth = 0;     class systemtitle/            fontfamily=" Arial, Verdana"                      backgroundcolor=#f5f5f5            fontweight=bold            fontsize=8pt borderwidth=0   ;     end; run; %let _ODSSTYLE=duals; %let _ODSOPTIONS=body=_webout (title=''); %let _ODSDEST=tagsets.htmlpanel; %let _ODSOPTIONS=options(  embedded_titles = 'yes'  /*bylabels='no' *panelborder='1'*/); %stpbegin; ods tagsets.htmlpanel event=row_panel(start)  ; ods tagsets.htmlpanel event=column_panel(start); title1 'General Production'; title2 "As of %sysfunc(date(),worddate.)"; proc report data=sashelp.cars ; run; ... View more

Using proc template to create an overlayed barchart. Ran into this issue when using a picture format. The barchart does not seem to recognize the user created picture format. proc format;     picture date5_ (default=6) other='%0d %A' (datatype=date); data _byDate;     set _byDate;     ASA=AnswerWaitTimeToHalf/CallsHandledtoHalf;   AHT=HandledCallsTimeToHalf/CallsHandledToHalf     ;     CallsHandled=CallsHandledtoHalf/ TotalCalls;     AdandonRate=AbandonedCalled/TotalCalls; format date date5_.; run; proc template;     define statgraph dualhist;         begingraph;             entrytitle "Total Calls vs Handled";             layout overlay / xaxisopts=(label="Day");                 /* Total Calls*/                 barchart x=date y=TotalCalls/ orient=vertical ;                 endlayout;         endgraph;     end; run; proc sgrender data=_byDate template=dualhist; run; ... View more

This is a general datastep questions and I am not sure which section is goes under. As of 9.2 you are able to create a reference to a java class, created by the user, in the datastep. I was wondering of any practical uses for this? Will it replace the hash object? Has anyone used this succesfully? ... View more

This is a general datastep questions and I am not sure which section is goes under. As of 9.2 you are able to create a reference to a java class, created by the user, in the datastep. I was wondering of any practical uses for this? Will it replace the hash object? Has anyone used this succesfully? ... View more

Hello, I am trying to have a stored procedure in IDP download an Excel report to the clients machine. This spreadsheet includes sgplot graphs. The stored procedure uses these headers : data _null_; rc = stpsrv_header('Content-type','application/vnd.ms-excel'); rc = stpsrv_header('Content-disposition',"inline"); run; ods listing close; ods markup body=_webout tagset=tagsets.msoffice2k; /*proc sgplot here */ /*proc report here*/ ods markup close; It creates the sheet with the proc report info but the charts just have place holders. Anyone run into this? ... View more