Good morning, I'm having a problem that the X axis color is not as defined in PNG output. As you can see in the attachments,  the X axis color is grey in the SAS output which is the color I want, but in the PNG output it is still black. Could someone help me with it? Thanks.   Here is my code: data anno; drawspace = 'GraphPercent'; function = 'Rectangle'; cornerradius=0.1; linestyleelement='GraphAxisLines'; TRANSPARENCY=0.5; Border=NOborder; retain x1 y1 50 height width 100 widthunit 'Percent'; run; ods graphics on/reset IMAGENAME ="&sheet.." IMAGEFMT =PNG width=8in height=2in; goptions device=png gsfname=graphout; PROC SGPLOT DATA = T1&sheet. sganno=anno dattrmap=attrmap noborder; Scatter Y=NAME X = MY2R/markerAttrs=(size=6mM) group=MY2 attrid=MY2 datalabel=MY2R DATALABELATTRS=(size=8.5pt Family=ArialNarrow weight=bold COLOR=White) DATALABELPOS=CENTER transparency=0.1; XAXIS DISPLAY=(NOTICKS) TICKVALUEFORMAT=data VALUEATTRS=(color=grey) label=' '; YAXIS DISPLAY=(NOTICKS noline) LABEL = ' ' labelattrs=(color=White) valueattrs=(size=12pt Family=Arial color=black) GRID gridattrs=(color=WhiteSmoke) MINORGRIDATTRS=(color=green pattern=longdash thickness=2); keylegend 'Percent'/noborder; title "&sheet."; run; ... View more

I need to create a dot plot with border and the border must have rounded corners instead of regular corners. Could someone please help me with it? Thanks. Here is my code: PROC SGPLOT DATA = temp1 dattrmap=attrmap border; Scatter Y=NAME X = MY1R/markerAttrs=(COLOR=purple size=6MM symbol=CIRCLEFILLED) datalabel=MY1R DATALABELATTRS=(size=9pt weight=bold COLOR=White) DATALABELPOS=CENTER transparency=0.1; Scatter Y=NAME X = MY2R/markerAttrs=(COLOR=purple size=6MM symbol=CIRCLEFILLED) datalabel=MY2R DATALABELATTRS=(size=9pt weight=bold COLOR=White) DATALABELPOS=CENTER transparency=0.1; XAXIS DISPLAY=(NOTICKS) label=' '; YAXIS DISPLAY=(NOTICKS noline) LABEL = ' ' labelattrs=(color=White) valueattrs=(size=12pt Family=Arial color=black) GRID gridattrs=(color=WhiteSmoke) MINORGRIDATTRS=(color=green pattern=longdash thickness=2); run; ... View more

I'm working on multiple graphs (around 100) and have used SGPLot  to produce graphs. So now my question is how can I output all the graphs into one excel and in different work sheets. Here is my code: %macro subdat; %do z = 1 %to 10; %let sheet=%scan(&sheets.,&z); proc import datafile="&path.\test.xls" out=T&sheet. dbms=xls replace; sheet="&sheet."; getnames=yes; run; ods listing close; ods graphics / width=14in height=8in; ods excel file="&outpath.\tables.xlsx" options(SHEET_NAME="&sheet." embedded_titles="yes" embed_titles_once="yes" );   PROC SGPLOT DATA = T&sheet. dattrmap=attrmap noborder; SERIES Y = PPS_NAME X = Performance_Goal/LINEATTRS=(COLOR=firebrick thickness=3) CURVELABEL="Performance Goal=&Target." CURVELABELPOS=end CURVELabelattrs=(size=8pt weight=bold color=firebrick); Scatter Y=PPS_NAME X = MY0R/markerAttrs=(COLOR=gainsboro size=6mM symbol=CIRCLEFILLED) attrid=MY0R; Scatter Y=PPS_NAME X = MY1R/markerAttrs=(size=6mM) group=ALL_PPS attrid=ALL_PPS datalabel=MY1R DATALABELATTRS=(size=9pt Family=ArialNarrow weight=bold COLOR=White) DATALABELPOS=CENTER transparency=0.1 discreteoffset=0.12; Scatter Y=PPS_NAME X = MY2R/markerAttrs=(size=6mM) group=Met_AIT attrid=Met_T datalabel=MY2R DATALABELATTRS=(size=9pt Family=ArialNarrow weight=bold COLOR=White) DATALABELPOS=CENTER transparency=0.1 discreteoffset=0.12; XAXIS  label=' '; YAXIS  LABEL = ' ' labelattrs=(color=White) valueattrs=(size=8pt Family=Arial color=black ) GRID gridattrs=(color=WhiteSmoke) MINORGRIDATTRS=(color=green pattern=longdash thickness=2); keylegend 'Percent'/noborder; title "&sheet."; run; Ods excel close; %end; %mend subdat; %subdat;   Thanks for your help! ... View more

I need to create a plot with MY2R values in the symbol center. But even I used DATALABELPOS=CENTER, all the data labels shift to right and not in the center. Could someone please help me with it? Thanks.    Here is my code: PROC SGPLOT DATA = temp1 dattrmap=attrmap noborder; Scatter Y=NAME X = MY2R/markerAttrs=(COLOR=purple size=6MM symbol=CIRCLEFILLED)  datalabel=MY2R DATALABELATTRS=(size=9pt weight=bold COLOR=White) DATALABELPOS=CENTER transparency=0.1;   XAXIS DISPLAY=(NOTICKS) label=' ' labelattrs=(size=8pt color=Black) values=(60 to 100 by 20) valueattrs=(size=8pt Family=Arial color=black);  run; ... View more