Data visualization with SAS programming

ODS Excel (Export Graphs to excel)

Reply
Occasional Learner
Posts: 1

ODS Excel (Export Graphs to excel)

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;

 

Grand Advisor
Posts: 17,428

Re: ODS Excel (Export Graphs to excel)

Can you use SGPLOT ? It produces better graphics. 

Ask a Question
Discussion stats
  • 1 reply
  • 178 views
  • 0 likes
  • 2 in conversation