Data visualization with SAS programming

ODS EXCEL OUTPUT (GRAPHS) NOT rendering

Accepted Solution Solved
Reply
Frequent Contributor
Frequent Contributor
Posts: 133
Accepted Solution

ODS EXCEL OUTPUT (GRAPHS) NOT rendering

hello all- little stuck. 

I am running SAS  9.4 (I think TM3) off a linux server.  I am attempting to export graphs into an excel report w/o success. 

From the code below, which I borrowed off the internet, the table exports just fine, but the graph does not render within the finalized excel document although it does show in the results table. 

 

I apologize in advance if someone recognizes their code, but this is inncoculous vs PHI data that I am trying to render- 

Any suggestions welcomed.  Not sure if I should contact SAS technical support. 

 

data my_data;
input item $ 1-6 Amount Purchase_date date9.;
datalines;
ITEM A 11.8 14nov2016
ITEM B 10.5 01jul2016
ITEM C 8.8 22feb2015
ITEM D 6.8 01apr2012
ITEM E 3.9 03aug2016
ITEM F 2.3 02mar2016
;
run;

ods listing close;
ods excel file="/apps/sas/datasets/data137/NCQOS/dev/nc_qos_sandbox/data/dfrx/xxx.xlsx" style=htmlblue;

goptions gunit=pct htitle=6 ftitle="albany amt/bold"
htext=3.5 ftext="albany amt/bold" ctext=gray33;

axis1 label=none value=(justify=right);
axis2 label=('AMOUNT') order=(0 to 12 by 2) minor=none offset=(0,0);

pattern v=solid color=dodgerblue;

ods excel options(SHEET_NAME='Graph');

title1 ls=1.5 "Simple Bar Chart";
proc gchart data=my_data;
format amount dollar5.0;
hbar item / discrete type=sum sumvar=amount nostats
maxis=axis1 raxis=axis2 noframe
autoref clipref cref=graycc;
run;

ods excel options(SHEET_NAME='Data' EMBEDDED_TITLES='yes' START_AT='3,2');

title c=gray33 "Raw Data Values";
proc print data=my_data noobs label;
label purchase_date='Purchase date';
format amount dollar5.2;
format purchase_date date9.;
run;

quit;
ods excel close;


Accepted Solutions
Solution
‎05-12-2017 10:09 AM
Community Manager
Posts: 2,697

Re: ODS EXCEL OUTPUT (GRAPHS) NOT rendering

Try setting:

 

options dev=PNG; 

 

before running the GCHART step.

View solution in original post


All Replies
Grand Advisor
Posts: 17,394

Re: ODS EXCEL OUTPUT (GRAPHS) NOT rendering

Verify your SAS version, I believe ODS is experimental before T3. 

 

Proc setinit;run;

 

https://support.sas.com/resources/papers/proceedings16/SAS5642-2016.pdf

 

PS. This assumes your code works and it's just an issue getting it into the Excel report. 

And re-using code on here is fine, ideally credited but not required. Just don't say it's yours if it's not. 

 

 

Frequent Contributor
Frequent Contributor
Posts: 133

Re: ODS EXCEL OUTPUT (GRAPHS) NOT rendering

Reeza; 

 

Current version: 9.04.01M3P062415 per proc setinit;  

 

Thanks 

 

Lawrence 

 

Solution
‎05-12-2017 10:09 AM
Community Manager
Posts: 2,697

Re: ODS EXCEL OUTPUT (GRAPHS) NOT rendering

Try setting:

 

options dev=PNG; 

 

before running the GCHART step.

Frequent Contributor
Frequent Contributor
Posts: 133

Re: ODS EXCEL OUTPUT (GRAPHS) NOT rendering

Chris- 

Chicken dinner we have a winner! 

Thank you all for your quick and helpful responses! 

 

Lawrence 

Grand Advisor
Posts: 10,223

Re: ODS EXCEL OUTPUT (GRAPHS) NOT rendering

And yet another reason to move to SGPLOT.

Frequent Contributor
Frequent Contributor
Posts: 133

Re: ODS EXCEL OUTPUT (GRAPHS) NOT rendering

Totally forgot about SGPLOT. Been awhile since I  have dealt  with ODs graphics.  

Thanks -This is working much better! 

 

Lawrence 

 

 

 

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 132 views
  • 2 likes
  • 4 in conversation