Arrow is not in the right place using HIGHCAP in SGPLOT

dkosovsky — Thu, 22 Jun 2023 10:57:20 GMT

Hello all!

would very much appreciate your help with SGPLOT and HIGHCAP statement.

I have monthly usage data for 2 patients:

data usage;

infile datalines ;

input ptid:$8. Usage:$10. month:32. year:32. start:32. end:32. highcap:$20. idname $8.;

datalines;

1 >=75% 8 2018 0 1 null 1

1 >=75% 9 2018 1 2 null blank

1 >=75% 10 2018 2 3 null blank

1 >=75% 11 2018 3 4 null blank

1 >=75% 12 2018 4 5 null blank

2 >=75% 7 2018 0 9 FilledArrow 2

2 >=75% 8 2018 1 9 FilledArrow blank

2 >=75% 9 2018 2 9 FilledArrow blank

2 >=75% 10 2018 3 9 FilledArrow blank

2 >=75% 11 2018 4 9 FilledArrow blank

2 50%-75% 12 2018 5 9 FilledArrow blank

2 50%-75% 1 2019 6 9 FilledArrow blank

2 >=75% 2 2019 7 9 FilledArrow blank

2 >=75% 3 2019 8 9 FilledArrow blank

;

data usage;

set usage;

if highcap='null' then highcap='';

if idname='blank' then idname='';

run;

I created a horizontal plot using SGPLOT, with colors marking the usage categories (red=low, orange=medium/low, yellow=medium, green=high) and I would like an arrow to mark the ongoing patient. I use the following code:

proc sgplot data=usage dattrmap=attrmap ;
highlow y=Ptid low=start high=end / type=bar group=Usage
lineattrs=(color=black pattern=solid) barwidth=1
lowlabel=idname highcap=highcap attrid=Usage_Rang labelattrs=(color=black size=8) ;
keylegend / title='Usage ' valueattrs=(size=8pt) titleattrs=(size=8pt);
scatter y=Ptid x=start / markerattrs=(size=0) ;
xaxis grid label = 'Treatment duration (Months)' offsetmax=0.02 values=(0 to 36 by 3);
yaxis grid display=(noticks novalues nolabel) discreteorder=data;

footnote1 j=c HEIGHT=10pt FONT='Arial' '"Arrow-heads" denote Patient On Therapy';
run;

but in output it seems like the arrow is at the beginning of the line, not at the end of it.

any thoughts about why is this happening and how to fix it?

any advice would be highly appreciated!

Re: Arrow is not in the right place using HIGHCAP in SGPLOT

SASJedi — Thu, 29 Jun 2023 18:10:39 GMT

This is an exact duplicate of you other post. I'm going to lock this one and leave the other open so that the answers will all be in one place. https://communities.sas.com/t5/SAS-Programming/Arrow-in-not-at-the-end-of-the-bar-with-SPGLOT-and-HIGHCAP/m-p/881889

topic Re: Arrow is not in the right place using HIGHCAP in SGPLOT in SAS Programming

Arrow is not in the right place using HIGHCAP in SGPLOT

Re: Arrow is not in the right place using HIGHCAP in SGPLOT