Ballardw, Thank you so much, once I saw your yaxistable statement the proverbial light bulb turned on. Besides adding that statement I had to move my PROC FREQ statement above the SGPLOT procedure. Complete working code is below. Note that I XX'd out some title info and changed variable names to remove identifiable data, though this has no effect on the code logic. Very happy with the result, thanks again. DATA PLOT; %LET REP_VAL=1 ; %LET YEAR_DT= %SYSFUNC(YEAR("&SYSDATE"D)); %LET PREVMTH= %SYSFUNC( PUTN( %SYSFUNC( DATE() )-10, MONNAME10. )); SET PDB.APITOT; REP_MTH=MONTH(DDD) ; IF REP_MTH=&REP_VAL ; ODS LISTING CLOSE; ODS GRAPHICS ON/ MAXOBS=20000000 WIDTH=15.5IN HEIGHT=25IN ; ODS NOPTITLE; ODS PDF FILE=OUTPDF NOTOC; PROC FREQ DATA=PLOT ORDER=FREQ NOPRINT ; TABLES TESTVAR/OUT=OUTPUT OUTCUM; WEIGHT COUNT; PROC SGPLOT DATA=OUTPUT; HBAR TESTVAR / RESPONSE=COUNT CATEGORYORDER=RESPDESC DATALABELATTRS=(SIZE=6PT COLOR=BLUE) STAT=SUM DATALABELPOS=LEFT DATALABEL ; YAXIS LABEL='SERVICE NAME' VALUEATTRS=(COLOR=GREEN SIZE=8PT) ; XAXIS LABEL='API MONTHLY TOTAL' VALUEATTRS=(COLOR=GREEN SIZE=10PT) ; YAXISTABLE PERCENT CUM_FREQ CUM_PCT/ LOCATION=INSIDE POSITION=RIGHT ; TITLE "XXXXXXXX MONTHLY SUMMARY" ; TITLE2 "TOTAL BY XXXX XXXX PRODUCTION PLEX"; TITLE3 "&PREVMTH &YEAR_DT" ; TITLE4 "DATA SOURCE: XXXXXXX RECORDS" ; FORMAT COUNT CUM_FREQ COMMA12. PERCENT CUM_PCT 5.2 ; LABEL PERCENT='PERCENT OF TOTAL' CUM_FREQ='CUMULATIVE FREQUENCY' ; RUN ; ODS PDF CLOSE ; ODS LISTING ;
... View more
