Dear all,
I am trying to output to XLSX by using ODS EXCEL. I want to output multiple tabs, and there are multiple proc in each tab. here is my program:
ods excel file="c:\temp\temp.xlsx" options(sheet_interval="none" sheet_name="sheet 1");
ods graphics / height=400 width=800 noborder;
proc sgplot data=sashelp.cars;
histogram msrp;
run;
proc print data=sashelp.class;
run;
ods excel options(sheet_interval="none" sheet_name="sheet 2");
proc sgplot data=sashelp.cars;
histogram msrp;
run;
proc print data=sashelp.class;
run;
ods excel close;
Even I specify two different sheet names, but since I use sheet_interval="none", so all the proc were output to "sheet 1" only.
Is there any way to solve this issus?
Thanks!!
... View more
My output is quite simple: I have a .txt which is output from SAS by using JAVAMETA. and then a html file like this: <html> <head> <title>********</title> </head> <body> <applet code="com.sas.graphics.applets.metaview.MetaViewApplet.class" archive="file:///C:/Program Files/SASHome/SASGraphJavaApplets/9.4/sas.graph.metaviewapplet.jar" width="1200" height="600" align="TOP"> <param name="BackgroundColor" value="#EEEEEE"> <param name="ZoomControlEnabled" value="false"> <param name="SlideShowControlEnabled" value="false"> <param name="Metacodes" value="j001-001.txt"> <param name="MetacodesLabel" value="001-001"> </applet> </body> </html>
... View more
This is just an example. Actually in my own program, JAVAMETA is for the interactive features in my html output, for example, I want to use tips, and can enlarge the graph, etc. My program worked very well under SAS 9.3 and IE 8. Currently I have SAS 9.4 and Windows 10, and the progam is not working. I am not sure what's the issue.
... View more
I am working on some html graphics outputs, the simple program I copy from SAS is like that: proc sort data= sashelp.prdsale out=prdsummary; by year quarter; run; goptions reset=all device=javameta ftext="Trebuchet" htext=1.5 hby=2; ods listing close; ods html; proc gchart data=prdsummary; by year quarter; hbar country / sumvar=actual subgroup=product sum; run; quit; ods html close; I wa able to get the output, a htm file. But when I clicked on that htm file and tried to open it in my IE, the error message show up: "Sorry, your browser does not support the applet tag. cannot be displayed. Sorry, there was a problem with the Graph control or plug-in in your browser. cannot be displayed." What's the reason for this error? What should I do with my IE? Many Thanks!!
... View more