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
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/...)
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.