Dear All,
I have 1 more question regarding the following program. I have SAS 9.2 and 9.4.
The error bar is overlapped each other at the same date and obscures group differences. How to move one of the curves either left or right so that the error bars at the same date would not overlap?
Thanks!
data char;
input Date Rate1 RL Rate2 RU;
datalines;
0 . . . .
2 2.5 3.65 2.552 1.482
4 2.444 3.811 2.28 1.118
8 2.60 4.185 2.545 1.039
12 2.385 3.492 2.737 1.316
16 2.454 3.957 2.395 1.182
24 2.524 3.857 2.755 1.515
;
proc sgplot data=char;
xaxis label='Date' values=(0 to 24 by 4) ;
yaxis label="Rate" values=(0.1 1 10 100) min=0.1 max=100 type=log logbase=10 logstyle=logexpand minor ;
series x=Date y=Rate2 / lineattrs=(pattern=solid color=black thickness=1.5)
markers markerattrs =(size=9 color=black symbol=circle)
legendlabel='Rate2' name='Sbar';
scatter x=Date y=Rate2 / yerrorupper=RU markerattrs =(size=9 color=black symbol=circle) ;
series x=Date y=Rate1 / lineattrs=(pattern=dash color=black thickness=1.5)
markers markerattrs =(size=9 color=black symbol=x)
legendlabel='Rate1' name='Ebar';
scatter x=Date y=Rate1 / yerrorlower=RL markerattrs =(size=9 color=black symbol=x) ;
keylegend "Sbar" "Ebar"/position=topright location=inside across=1;
run;
With SAS 9.4, the easiest way would be to change your data to group structure, and use one series and one scatter with groups, with GroupDisplay=Cluster. You can adjust the Cluster width. Not sure if this is right, but you get the idea.
data charGrp;
keep date group value low high;
set char;
group='Rate1'; value=rate1; low=.; high=ru; output;
group='Rate2'; value=rate2; low=rl; high=.; output;
run;
proc sgplot data=charGrp;
xaxis label='Date' values=(0 to 24 by 4) ;
yaxis label="Rate" values=(0.1 1 10 100) min=0.1 max=100 type=log logbase=10 logstyle=logexpand minor ;
series x=Date y=value / group=group legendlabel='Rate2' name='Sbar';
scatter x=Date y=value / group=group yerrorupper=high yerrorlower=low
markerattrs =(size=9) groupdisplay=cluster clusterwidth=0.3;
keylegend "Sbar" / position=topright location=inside across=1;
run;
With SAS 9.4, the easiest way would be to change your data to group structure, and use one series and one scatter with groups, with GroupDisplay=Cluster. You can adjust the Cluster width. Not sure if this is right, but you get the idea.
data charGrp;
keep date group value low high;
set char;
group='Rate1'; value=rate1; low=.; high=ru; output;
group='Rate2'; value=rate2; low=rl; high=.; output;
run;
proc sgplot data=charGrp;
xaxis label='Date' values=(0 to 24 by 4) ;
yaxis label="Rate" values=(0.1 1 10 100) min=0.1 max=100 type=log logbase=10 logstyle=logexpand minor ;
series x=Date y=value / group=group legendlabel='Rate2' name='Sbar';
scatter x=Date y=value / group=group yerrorupper=high yerrorlower=low
markerattrs =(size=9) groupdisplay=cluster clusterwidth=0.3;
keylegend "Sbar" / position=topright location=inside across=1;
run;
thanks Sanjay !!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.