SAS中文论坛

标题: sas如何操作excel [打印本页]

作者: shiyiming 时间: 2006-9-4 23:10
标题: sas如何操作excel
如何用sas程式新增excel中的sheet4(一般只有sheet1,sheet2,sheet3),如果要删除的话要怎么用(例如删除excel中的sheet2) ......... ....不知可不可行???

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

作者: shiyiming 时间: 2006-9-5 14:13
标题: How to export a sas data set to a .xls file
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 时间: 2006-9-5 17:39
标题: excel macro
那请问一下~使用excel macro 可行吗

作者: shiyiming 时间: 2006-9-5 22:56
标题: using FILENAME DDE
Yes, a user's Excel macro can be called.
i.e.: put '[run("myMacro_newsht")]'; ** where myMacro_newsht is an Excel Macro user defined;

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

欢迎光临 SAS中文论坛 (http://mysas.net/forum/)