Data visualization with SAS programming

Trying to put percentage in the right vertical axis.

Reply
Learner
Posts: 1

Trying to put percentage in the right vertical axis.

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

Sin título.png

 

 
Super User
Posts: 19,080

Re: Trying to put percentage in the right vertical axis.

Probably. Post your code. Including sample data to allow us to replicate your graph would help, use the SASHELP datasets if necessary.
PROC Star
Posts: 1,672

Re: Trying to put percentage in the right vertical axis.

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/...)

 

Capture.PNG

Ask a Question
Discussion stats
  • 2 replies
  • 107 views
  • 2 likes
  • 3 in conversation