topic Re: customizing x-axis using proc sgplot in SAS Programming

customizing x-axis using proc sgplot

UcheOkoro — Fri, 08 Apr 2022 15:45:34 GMT

Hello,

I am plotting trends in odds ratio using proc sglot but the x-axis will not display all the years. I used "values" and "displayvalues" but they do not seem to work.

Please, kindly assist.

Thank you.

proc sgplot data=Females ;
format Health_cost_health_insur typeFmt.;
   scatter y=Odds_ratio x=Year  /group=Health_cost_health_insur yerrorlower=LL yerrorupper=UL markerattrs=(symbol=diamondfilled);
   refline 0 / axis=y;
   	title 'Cherry-Picking Violation by Provider Designation';
      xaxis grid
  values=(2013 2014 2015 2016 2017 2018 2019)
Valuesdisplay=("2013" "2014" "2015" "2016" "2017" "2018" "2019" );;
   yaxis grid  discreteorder=data ;
  xaxis display=ALL  INTERVAL= Year;
   keylegend  / title="Health Coverage Status"  location=outside; 
    		title 'Trend in Health Coverage and Health Cost in Females Compared to Males';
 xaxis label="Year";
 yaxis label="Adjusted Odds Ratio";
        run;

Re: customizing x-axis using proc sgplot

ballardw — Fri, 08 Apr 2022 15:51:22 GMT

You have two XAXIS statements. When there are multiple axis statements affecting the same axis only the LAST one seems to be applied.

Combine the two into a single XAXIS and I think your problem will be fixed.

You really only the the VALUESDISPLAY to show something quite different than the formatted value. It might make sense if you were doing something like:

   xaxis grid
  values=(2013 2014 2015 2016 2017 2018 2019)
Valuesdisplay=("Baseline" "2014" "2015" "Intervention" "2017" "2018" "Evaluation" );

with something simple like year I would normally not bother with Valuesdisplay

Re: customizing x-axis using proc sgplot

UcheOkoro — Fri, 08 Apr 2022 16:04:47 GMT

Thank you so much! I am most grateful.