sas如何操作excel

shiyiming

如何用sas程式新增excel中的sheet4(一般只有sheet1,sheet2,sheet3),如果要删除的话要怎么用(例如删除excel中的sheet2) .........   ....不知可不可行???

                               p.s不能用excel去操作,只能用sas语法去写

shiyiming

If you want export a sas data set  to a .xls file, you can use the PROC EXPORT.

e.m.
/*export the data set a to b.xls, and names sheet4*/
PROC EXPORT DATA=work.a
                      OUTFILE="C:\b.xls"
                      DBMS=EXCEL REPLACE;
                      SHEET="SHEET4";
RUN;

I am sorry,I don't know how to delete a given sheet which of the .xls file.

shiyiming

那请问一下~使用excel macro 可行吗

shiyiming

Yes, a user's Excel macro can be called.
i.e.:   put '[run("myMacro_newsht")]';  ** where myMacro_newsht is an Excel Macro user defined;

<!-- m --><a class="postlink" href="http://sasor.feoh.net/modules.php?name=Forums&amp;file=viewtopic&amp;p=12113&amp;sid=67e7633390b5b87c0ebb268ddc1e7373#12113">http://sasor.feoh.net/modules.php?name= ... 7373#12113</a><!-- m -->