topic Re: PROC SGPLOT - Set decimal places for marks on Y axis in New SAS User

PROC SGPLOT - Set decimal places for marks on Y axis

_maldini_ — Wed, 01 Jun 2022 19:25:14 GMT

I'm outputting percentages from a proc freq to a new dataset and then using proc sgplot to plot the column percentages over time. SAS documentation seems to suggest I should use the PCTNDEC= option, but I can't figure out where to put it.

Is this the best option to use and what line should I put it on?

proc sgplot data=freqout ;
   where ever_told_mi=1;

   series x=year y=pct_row 
   
   / lineattrs=(thickness=2px) markers DATALABEL=pct_row group=cann_use_status;

   xaxis 
   label = "Time in 2-year intervals"
   values=(2009-2010 to 2017-2018);
  
   yaxis 
   label = "Percentage Reporting Prior MI"
   values=(0 to 100 by 10);
 	
   format 
   ever_told_mi yes_nofmt.
   cann_use_status cann_use_statusfmt.;
 
run;

Thanks!

Re: PROC SGPLOT - Set decimal places for marks on Y axis

ballardw — Wed, 01 Jun 2022 20:29:45 GMT

If the YAXIS definition is getting the values you want and just want to display values such as 10.0 then all you should need is to assign an appropriate format to the Y variable labels with the VALUESFORMAT= option on the Yaxis statement.

It would help if you could describe exactly what sort of values you want.

The PCTNDEC procedure option only applies to plots that calculate their own percentages such as VBAR or HBAR and would not apply to Series

Example that forces the Yaxis tickmarks to display 3 decimals (though they will typically be 000 because of the default rules SAS uses to create tick mark values)

Proc sgplot data=sashelp.class;
   scatter x=height y=weight;
   yaxis valuesformat=f8.3;
run;

Or if you have specific decimals in mind place them in the VALUES list:

Proc sgplot data=sashelp.class;
   scatter x=height y=weight;
   yaxis values=(60.5 93.7 110.9);
   
run;

Re: PROC SGPLOT - Set decimal places for marks on Y axis

_maldini_ — Wed, 01 Jun 2022 20:53:19 GMT

Sorry for not being more clear...The VALUESFORMAT= option formats the decimal places on the axis, which I also wanted. I was wanting to format the values of the Y variable and your response jogged my memory. I just need to format the Y variable. Duh.

Thanks!