Hi,
Thanks in advance for your help.
I seek your great help on this issue. I have created charts/graphs using SAS EG 7.1. Below the code I was using to create graphs etc.
I am using ODS Excel to export the graph to excel. The Graph not copied to excel if I set graph format to "ActiveX/Java" but its being copied to excel If i change the graph format to "JPEG". But the graph is not clear as expected if i use JPEG format.
Appreciate if you suggest any other alternate for this. Thanks.
libname mylib 'M:\data\sandbox';
ods excel file="M:\Test2.xlsx"
;
data anno1;
length function style color $8 text $20;
retain xsys '5' ysys '5' when 'a' color 'white';
function='move';x=48;y=2.2;line =1;output;
function='draw';x=50;y=2.2;line=1;output;
function='label';color ='black';x=43.3;y=2.2;position='6';size=.9;text="KS";output;
function='move';x=55.5;y=2.2;line =37;output;
function='draw';x=57;y=2.2;line=37;output;
function='move';color='black';x=38.7;y=1;size=.9;line =1;output;
function='symbol';color='white';x=64.5;y=0;position='6';size=3;text="cube";line =0;output;
function='label';color ='black';x=55;y=2.2;position='6';size=.9;text="Accuracy Ratio";output;
run;
goptions cback= white;
symbol1 i=hilot v=none c=black h=0 W=0;
symbol2 i=none v=cube c=red h=0 w=0 pointlabel=none ;
symbol3 i=JOIN h=9pt v=DOT CV=blue CO=blue LINE=1 w=1 CI=blue pointlabel=none;
symbol4 i=JOIN h=5pt v=NONE CV=black CO=black LINE=37 w=2 CI=black pointlabel=none;
Legend1
LABEL=( FONT='Arial' HEIGHT=8pt JUSTIFY=center " ")
VALUE=(FONT='Arial' HEIGHT=8pt "Threshold" " " " " " " );
;
PROC GPLOT DATA=mylib.test ;
PLOT
BOUND1*calc_poolv
AR*calc_poolv
KS * calc_poolv
tresh*calc_poolv
/ overlay haxis=axis2 vaxis=axis1 LEGEND=LEGEND1 anno=anno1;
;
;RUN;
ods excel close;
Can you use SGPLOT ? It produces better graphics.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.