topic Re: How to Align axistable display with tickvaluesequence in Graphics Programming

Another option instead of drawtext in proc template

Leo9 — Mon, 23 Mar 2020 19:11:28 GMT

Hi All,

I need to display number of subjects at each visits at the bottom of the plot for a series plot. There are three different cohorts so I need to display three lines of N (number of subjects) one for each cohort. I know the drawtext option but it requires lots of processing and playing around to get proper display. Is there any other option to do this ?

Re: Another option instead of drawtext in proc template

JeffMeyers — Mon, 23 Mar 2020 19:15:20 GMT

That is what the AXISTABLE plot was made to do. It has a CLASS option I believe to split into multiple rows and can also be colored differently if need be. You can either use a lattice layout to make a space below your chart, or you can use an INNERMARGIN block within your current layout to include it above your X-axis.

Re: Another option instead of drawtext in proc template

Rick_SAS — Mon, 23 Mar 2020 19:36:36 GMT

The Graphically Speaking blog has many posts that feature the XAXISTABLE statement. Here's one to get started:

https://blogs.sas.com/content/graphicallyspeaking/2016/07/17/graph-table-with-class/

and another that shows a variation

https://blogs.sas.com/content/graphicallyspeaking/2018/02/19/survival-plot-twist-using-sgplot-procedure/

Re: Another option instead of drawtext in proc template

Leo9 — Mon, 23 Mar 2020 20:03:36 GMT

Thank you! This works nicely. However, I want to display N for certain visits only which are displayed on x-axis. Right now I am displaying visits on x-axis at 4 week interval using tickvalue sequence. Is there any option like that with axistable to display N ?

How to Align axistable display with tickvaluesequence

Leo9 — Mon, 23 Mar 2020 20:20:57 GMT

Hi All,

I am creating a series plot where I am displaying visits in 4 week interval using tickvaluesequence option in proc template. I need to display subject of subjects at each visit for which I am using axistable plot to display. Problem is that axistable is displaying N (number of subjects) for every week instead of every 4 weeks. Is there any option to display, like tickvaluesequence within axistable to display N for selected visits ? Thanks in advance.

Re: How to Align axistable display with tickvaluesequence

Rick_SAS — Mon, 23 Mar 2020 20:37:54 GMT

The XAXISTABLE statement in PROC SGPLOT (and the AXISTABLE statement in the GTL) displays the data in the variables that you specify. For example, in SGPLOT the syntax is

xaxistable NumVisit x=Time class=Cohort;

So you should run a DATA step to aggregate the visits and store the 4-week times and totals in new variables NumVisit4 and Time4 for each cohort. Add those variable to the data set that you are plotting and specify the NumVisit4 and Time4 variables in the XAXISTABLE stmt.

Re: How to Align axistable display with tickvaluesequence

JeffMeyers — Mon, 23 Mar 2020 20:41:20 GMT

You could either do it in the data step (make a new variable that only has the values you want) or if it is as simple as taking every fourth week and your weeks are numbered sequentially you could use an EVAL function in the template:

axistable x=eval(ifn(mod(weeks,4)=0,weeks,.)) values=n_patients;

I don't know what your variables are but the above is an example of using the mod function to take the fourth week. Changing the =0 to =1, =2, or =3 will grab a different week in the four week cycle.

Re: How to Align axistable display with tickvaluesequence

Rick_SAS — Mon, 23 Mar 2020 20:52:44 GMT

That's a neat trick, but I think the OP wants to show the sum of the numbers for weeks 1-4 at the location for week 4.

Show the sum of the numbers for weeks 5-8 at the location for week 8, etc.

If so, using n_patients won't work. You have to sum the n_patients values.

Re: How to Align axistable display with tickvaluesequence

JeffMeyers — Mon, 23 Mar 2020 21:30:13 GMT

I'm not seeing anything in their post saying they want to aggregate numbers at certain time points, just that they want to pick which times they are displaying the counts. I'm reading this like someone trying to print patients-at-risk on a survival curve at certain time-points.

Re: How to Align axistable display with tickvaluesequence

Rick_SAS — Mon, 23 Mar 2020 23:08:25 GMT

Upon re-reading, I think you are probably right and I made an incorrect assumption. Sorry for the confusion. Thanks for clarifying.