Prev: SAS and ODBC dates
Next: real p values from ttest
From: Sunny on 20 Jan 2010 15:20
Hello Group,

How to get a graph in excel sheet using the below
mention macro %OdGraph. I'm able to get
it in the excel using ODS html file= .... and with proc chart for
example

ods html file="c:\temp\test.xls" style=minimal;
proc chart data=sashelp.class;
hbar age;
run;
ods html close;

But have no idea how to go about when we use proc SGPLOT and ods
graphics & Ods html style
to the specified excel location.

%macro OdGraph(dsn1=,navg=10,nodys=10,var=close);;

ods graphics on / width=720px height=480px ;

ods html style=curve image_dpi=205 ;


title " XYZ Trend's ";


proc sgplot data = alix.&dsn1;

something; ...........something;



run;

ods graphics off;
ods html close;
%mend;

%OdGraph(dsn1=test,navg=10,nodys=10,var=close);

Thanks in advance. Will appreciate your suggestion and thoughts on
this.

Sunny

 | 
Pages: 1
Prev: SAS and ODBC dates
Next: real p values from ttest