I am still looking, but one reason is that each cell with its own axis will take up too much space. So, add the ColumnAxes - EndColumnAxes block to get a single common external axis. Still, I had to add Layout Overlay around each BlockPlot. I don't know why, but at least this works. See attached code and graph. Let me know if this is what you expect. I had to un-macrofy your code to see what the errors were. ... View more

Attempting to attach the output graph. ... View more

The Density statement does not support GROUP role. In cases where you have a known number of group values, you could transpose your data into multiple columns and overlay the needed plots as shown below. You don't need the BY statement. data density; drop i; do i=1 to 100; A = 20+20*ranuni(2); B = 20+30*ranuni(3); output; end; run; /*proc print;run;*/ proc sgplot data=density; density a / legendlabel='A'; density b / legendlabel='B'; run; ... View more

If you have SAS 9.2(TS2M3), you can use the ODS Graphics Designer to create your graphs without knowing anything about SAS/GRAPH. This will also work for pre M3 version, but it is pre-production. Submit %sgdesign; in the program window to start Designer. Then, start with a graph from the gallery, and supply your data. You can add more bars or series to the graph incrementally. See this link to get started: http://support.sas.com/resources/papers/proceedings09/331-2009.pdf ... View more

Also see the programs I posted to this thread: http://support.sas.com/forums/thread.jspa?threadID=14351&tstart=0 ... View more

You seem to have 3 separate columns. With this data structure, you have a couple of options. With SAS (TS2M3), you can get the bars side by side using GTL. Else, you can get overlaid bars. See code below. The DISCRETEOFFSET option in GTL will not work for a SAS release prior to TS2M3. Side-by-side grouped bar charts are coming with SAS 9.3. data subset; input month $ sales_a sales_b sales_acum; datalines; Jan 200 300 500 Feb 300 400 700 Mar 200 400 600 ; run; proc print;run; /*--SGPLOT--*/ ods graphics / width=4in height=3in imagename='BarsSG'; proc sgplot data=work.subset; title "Budget and Sales"; vbar month/ response=sales_A nostatlabel; vbar month/ response=sales_B barwidth=0.6 nostatlabel; vline month/ response=sales_acum y2axis lineattrs=(pattern=solid thickness=4) nostatlabel; yaxis offsetmin=0; xaxis discreteorder=data; run; /*--GTL--*/ proc template; define statgraph bars; begingraph; entrytitle "Budget and Sales"; layout overlay / yaxisopts=(offsetmin=0); barchart x=month y=sales_a / discreteoffset=-0.2 barwidth=0.4 fillattrs=graphdata1 name='a'; barchart x=month y=sales_b / discreteoffset= 0.2 barwidth=0.4 fillattrs=graphdata2 name='b'; seriesplot x=month y=sales_acum / lineattrs=graphdata3(pattern=solid thickness=4) yaxis=y2 name='c'; discretelegend 'a' 'b' 'c'; endlayout; endgraph; end; run; ods graphics / width=4in height=3in imagename='BarsGTL'; proc sgrender data=work.subset template=bars; run; ... View more

Can you post the code for your data set? ... View more

Markerattrs=(symbol=circle) or markerattrs=(color=black) does work as expected. You just cannot assign a list of symbols or colors in this way. ODS Graphics automatically applies the settings from the style to the group colors, symbols and line patterns. By doing this, all graphs in your report will have consistent attributes for the same group value. These colors, marker symbols etc have been carefully chosen by GUI experts to provide maximum clarity and discriminability between different groups when using the default styles. Furthermore, there are many styles shipped by SAS for you to use. The whole idea is to create aesthetic and effective graphs out of the box without users having to spend time finding good combination of colors. Of course, if you need, you can design your own style too. If you are not using a group variable, you can change the setting of the plot by using the markerattrs=(symbol=circle, color=black) or whatever you need. If you have a graph made up of multiple scatter or series plots, one per column, you can control the color and other attributes of each plot by using this feature. In future release, there may be a way to set group colors, markers, etc in the syntax itself. ... View more

To see your changes in a graph, use the following: ods listing style=styles.mydefault; proc sgrender data=sashelp.class template=testsymbols; run; The marker symbols you have defined will automatically be used for the first 3 values of the group variable. Since you have not derived your elements, they will only have markers, and not colors. Use this code to see the legend with all values of age: define statgraph testSymbols; begingraph; layout Overlay; scatterPlot y=height x=weight / group=age name='s'; discretelegend 's'; endlayout; endgraph; ... View more

Symbol values should be strings: proc template; define style Styles.MyDefault; parent=Styles.Default; style GraphData1 / MarkerSymbol='DIAMOND'; style GraphData2 / MarkerSymbol='CROSS'; style GraphData3 / MarkerSymbol='CIRCLE'; end; run; Also, it is preferred to derive each style element from the parent, and change the attributes needed: style GraphData3 from GraphData3 / You need to remove the following option in the scatterplot statement: Markerattrs=(symbol=MyDefault). Lastly, to create the graph, you need: proc sgrender data=foo template=testSymbols; run; ... View more

Posting a program with special characters like < or > or / causes problems to how the message shows up in the viewer. You can use the appropriate HTML escape characters for these special characters, as I have use here. The / (forward slash) for the statement options is really needed. Here is a link to the full list of HTML escape characters: http://www.theukwebdesigncompany.com/articles/entity-escape-characters.php ... View more

Can you attach an image to indicate what you want? ... View more

You want the line to span the data and preferably keep the 45 degree slope. Since you are open to using GTL, that is the best way for a SGPLOT (single-cell) type graph. Run the SGPLOT procedure and extract the GTL code using the option TMPLOUT='filename'. This will give you the necessary GTL code to create the same graph. Then, add a LINEPARM within the LAYOUT OVERLAY. See the Reference Doc for the LINEPARM statement. You need to provide a point and slope. These values can come from columns in your data set. The line created will span the full data. Also, replace the LAYOUT OVERLAY with a LAYOUT OVERLAYEQUATED. This will allow you to have equated axes, and retain your 45 degree angle for same data on X & Y. Please also see the Reference Doc for the syntax. You can add the LINEPARM in the same way to get the SGPANEL (Classification Panel) type graph. Add it in the LAYOUT PROTOTYPE statement. However, you cannot created a DATALATTICE of equated plots. And, you can only use this with the basic plot statemets like Scatter, Series, Bar, etc. To do the same for ScatterPlotMatrix, you will need to unroll it yourself and use a LAYOUT LATTICE, and populate each cell. Here you can add a LINEPARM and use a LAYOUT OVERLAYEQUATED. ... View more

Documentation for Style Editor can be found in the SAS Help and Documentation: - SAS Products - SAS/GRAPH - SAS/GRAPH 9.2 ODS Graphics Designer User's Guide: - Changinfg Appearance of a Graph - Customizing Graph Styles. ... View more

The solution Cynthia has provided is one of the right answers. Since one of the motivations for Designer is to avoid such coding, there is, "hidden" deep inside Designer, an early version of a GRAPH STYLE EDITOR. In Designer, Click Tools->Style Editor. It will bring up the Graph Style Editor GUI. Starting with the current style (usually LISTING) as parent you can derive a new style. Once inside the Style Editor, you can change this initial parent style to another one. Now, you can change the various color, marker, pattern, etc attributes for each of the style elements using the GUI. If you don't know the name of the element, click on the graphs on the right, and it will take you to the right one. Click the title, or background, or a bar, marker, etc. Make your changes, and save the style as a user custom style (give it a different name). You cannot overwrite a SAS supplied style. Now, back in your graph, click Format->Style-> and select your new style. It may be in "More Styles" in the Custom Styles list. It is called a "Graph Style Editor" because it only allows you to change the style elements that are applicable to the graph, not other things like tables, etc. You can also export a generated style (File->Export Style) to a .sas file for use with your code. Note, for SAS 9.2M3, this contains the full definition, even if you have only made a few changes. This will be fixed in the next release. ... View more