About cdorger

cdorger · ‎03-02-2020

Mike, Just curious, but why choose clockwise as the direction of time instead of counter-clockwise? Convention is to have things turn counter-clockwise. Clocks are an anomaly.

cdorger · ‎06-20-2019

Dan, thanks for this suggestion, it worked really well. I was constructing my plot with the GTL so I used the LEGENDITEM statement with the DISCRETELEGEND statement rather than LEGENDITEM/KEYLEGEND as in Sanjay's blog post. It allowed the ability to place markers and text even with a default legend suppressed. And even with the lattice layout, I was able to place it exactly where I wanted, it works with UNICODE text, get an opaque background, a box around it...everything the client wanted! I browsed Sanjay's posts but also found a short, simple example in the SAS® 9.4 Graph Template Language: Reference, Fifth Edition, LEGENDITEM statement: https://documentation.sas.com/?docsetId=grstatgraph&docsetTarget=p0ltl3z1z97jldn14vccmjnrhg2n.htm&docsetVersion=9.4&locale=en#p0fbudelp8ptnan1q4bqonlwzn0o

cdorger · ‎06-18-2019

Is there a way to place a marker symbol on a graph using the Graph Template language analogous to the SAS/Graph annotate facility function="SYMBOL"? I want to make a custom legend for a plot and I am using a LAYOUT GRIDDED to place two rows: "<65 Years" and ">=65 Years". I want to place the markers used on the graph before this text. I know you can use DRAWOVAL and BEGINPOLYGON to create shapes but this is complicated and does not look exactly like the marker symbols. Is there a font that would give me access to the markers I use in the plot so that I can place them as a single character? I am using version 9.4. This works but is awkward and the triangle does not look exactly like the filledtriangle plot marker: *Draw the symbol/text for the first line of the legend; drawoval x=89 y=90 width=5 height=5 /xspace=graphpercent yspace=graphpercent anchor=left widthunit=pixel heightunit=pixel display=(fill) fillattrs=(color=darkblue) transparency=0; drawtext "<65 Years" / xspace=graphpercent yspace=graphpercent anchor=left width=15 widthunit=percent x=90 y=90; *Draw the symbol/text for the second line of the legend; beginpolygon x=&x0 y=&y0 / xspace=graphpercent yspace=graphpercent transparency=0 display=(fill) fillattrs=(color=darkred); draw x=&x1 y=&y0; draw x=&x2 y=&y1; endpolygon; drawtext {unicode "2265"x} "65 Years" / xspace=graphpercent yspace=graphpercent anchor=left width=15 widthunit=percent x=90 y=87;

cdorger · ‎07-20-2018

Jeff, your solution worked great...until I tried it on the data for which I am creating the plot. These counts are 2 orders of magnitude greater than those in the cars dataset and I had the problem where the next major tick mark would show up and the height of the initial bar would not line up with the 100% tick. This seems to happen if the initial bar height is more than about 70% of the way from the last major tick value. I made a small modification to the first 3 steps of the program I posted so you (or anyone else) can see the effect of increasing the counts. (See the SAS code below.) A multiplier value of 111 increases the counts from 428 to 47508 and a 50,000 tick value is put on the y-axis. But...I discovered the THRESHOLDMAX= option for LINEAROPTS=() and setting that to 0 suppresses the last major tick value so your post is ACCEPTED AS A SOLUTION! Thanks! ***Increase values of counts with arbitrary multiplier for testing different ranges on graph; %let multiplier=111; ***Open SASHELP dataset; data cars; set sashelp.cars; retain w &multiplier; run; ***count number of vehicles, store in macro var; proc sql; select &multiplier*count(*) AS NCars INTO :IBV from cars; quit; ***count cars by Vehicle type; proc freq data=cars; tables type / out=vtype(keep=type count percent rename=(type=vehtype)); weight w; run;

cdorger · ‎07-19-2018

Hi everybody, I want to create a waterfall chart that shows how counts drop as you move through the category plotted on the x-axis. But it would also be nice to see percentages on a second y-axis at the right. I have been able to jury-rig this somewhat by overlaying 2 waterfallchart plots where the first one draws no bars and then using offsetmax= option for the y2axis. But getting the 100% tick to line up exactly with the total number of counts has been tricky and takes some trial and error. Is there a way to do this in the manner of columndatarange=unionall option in the layout lattice statement? ***Open SASHELP dataset; data cars; set sashelp.cars; run; ***count number of vehicles, store in macro var; proc sql; select count(*) AS NCars INTO :IBV from cars; quit; ***count cars by Vehicle type; proc freq data=cars; tables type / out=vtype(keep=type count percent rename=(type=vehtype)); run; ***Sort from greatest to least ; proc sort data=vtype; by descending count; run; ***Create numeric plotting xvar and format data for formatting discrete x axis; data vtype2(keep=x vehtype count percent) f1(keep=start label fmtname TYPE); set vtype end=lastline; retain fmtname 'discax' TYPE 'N'; x=_N_; count=-count; percent=-percent; start=x; label=vehtype; if not lastline then do; output vtype2; output f1; end; run; ***Look at data for plot; proc print data=vtype2; run; ***Create format for X-axis; proc format cntlin=f1; run; ***Figure out what max tick value on y1 axis should be; %let ymax=450; ***Compute offsetmax for Percent axis (Y2axis); data _NULL_; call symput('OSM',put(&ymax/&totcars - 1,best4.)); run; %put *********&OSM*************; ***Create template for overlaying waterfall chart with numbers on left axis and percent on right; proc template; define statgraph wfal1; nmvar MAXY "max y axis value" OSM "OffSet Max" IBV "Init Bar Value"; begingraph; entrytitle 'Waterfall of Models by Vehicle Type'; layout overlay / xaxisopts=(label="Restriction" discreteopts=( tickvaluefitpolicy=split tickvaluesplitchar="*" ) ) yaxisopts=(label="Number of Vehicles" offsetmax=0 linearopts=( viewmin=0 viewmax=MAXY ) ) y2axisopts=(label="Percent of Vehicles" griddisplay=on offsetmax=.05 linearopts=(viewmin=0 viewmax=100) ) ; *end LAYOUT OVERLAY stmt; *Percent on right side; waterfallchart category=x response=percent / yaxis=y2 finalbartickvalue="" initialbartickvalue="" datatransparency=1 initialbarvalue=100 stat=sum ; *numbers on left side; waterfallchart category=x response=count / yaxis=y finalbartickvalue="All Other" initialbartickvalue="All Vehicles" initialbarvalue=IBV barlabel=TRUE fillattrs=(color=GRAYC9) initialbarattrs=(color=GRAYC9) finalbarattrs=(color=GRAYC9) stat=sum ; endlayout; endgraph; end; *define; run; %let MAXY=450; *** *** *** *** *** *** *** *** *** Options for HTML output *** *** *** *** *** *** *** *** *** *** *** ; options orientation=landscape topmargin=0.5in bottommargin=0.5in leftmargin=0.5in rightmargin=0.5in; ods _all_ close; ods noproctitle; ods graphics on / border=off height=600px width=800px reset=index(1) /* causes SAS to overwrite output images */ ; ods html body="waterFallTest.html" path="<path>/SAS_output/"(url=none) ; proc sgrender data=vtype2 template=wfal1; format x discax.; run; ods html close; ods graphics off; ods listing; options orientation=portrait; Quit; ********************************************** END PROGRAM ************************************************;

Online Status	Offline
Date Last Visited	‎03-15-2021 04:01 PM

Re: 3 Steps to Building an Air Temperature Circle Graph

Re: Placing graph marker symbols in a custom legend

Placing graph marker symbols in a custom legend

Re: GTL waterfall chart aligning count and percent y-axes

GTL waterfall chart aligning count and percent y-axes

Re: 3 Steps to Building an Air Temperature Circle Graph

Re: Placing graph marker symbols in a custom legend

Placing graph marker symbols in a custom legend

Re: GTL waterfall chart aligning count and percent y-axes

GTL waterfall chart aligning count and percent y-axes