Trying to put percentage in the right vertical axis.

[ldavidr]

Good day! So I'm learning to use SAS and I've been all day trying to put percentages in the y axis, but the right one. My current graph already uses reflines but I want to replace the reflines for a percentage scale from 0 to 100% in 10 by 10. Is there a way to do it?

I'm on SAS 9.3

[Reeza]

Probably. Post your code. Including sample data to allow us to replicate your graph would help, use the SASHELP datasets if necessary.

[ChrisNZ]

Like this?

      
proc summary data=SASHELP.PRDSAL2 ;
  where YEAR eq 1995;
  class MONYR;
  var ACTUAL PREDICT;
  output out=SUMMARY  sum=;
run;

data PLOT;
  if _N_=1 then set SUMMARY(where=(MONYR eq .) rename=(ACTUAL=TOTAL) );
  set SUMMARY(where=(MONYR ne .) );
  retain TOTAL;
  PCT+ACTUAL/TOTAL;
  format PCT percent10.1;
run;

proc sgplot data=PLOT; 
  vbar monyr / response=ACTUAL ;
  vline monyr / response=PCT y2axis;
run;

(modified from https://communities.sas.com/t5/SAS-GRAPH-and-ODS-Graphics/using-second-y2axis-with-proc-sgplot-vbar/...)