请问如何将多个数据集导出至同一Excel文件的多个Sheet？

Just ask a question:
I use proc export to do the job. it works fine. A problem is that the number of sheets(tabs) in one .xls file cannot be more than 269 or so. Beyond that, the file won't accpet more tabs.
But that should not be a problem if we don't use SAS to export multiple sheets(tabs), right?
Does anyone know how to resolve this issue?
Thanks, Jingju

jingju11 发表于 2013-5-24 01:44
Just ask a question:
I use proc export to do the job. it works fine. A problem is that the number o ...

嗯，应该就是proc export的问题
要不试试DDE？这东西直接操作Excel，应该受SAS限制较少
但是我用这玩艺会经常死机
后来就不用了

there's no limit on the # of worksheets allowed per excel file as long as you have enough memory to open it.
And I do prefer 可~乐's DATA step approach rather than many PROC EXPORT steps.
Basically, both methods use the SAS/ACCESS interface to PC files, but the DATA steps establishes connection for once only and thus more efficient.
I could be wrong.

邓贵大 发表于 2013-5-24 10:00
there's no limit on the # of worksheets allowed per excel file as long as you have enough memory to  ...

Thanks for all replies.
I don't prefer to DDE since I am running SAS in server.
I may lose some efficiency as you suggest. On the other hand, I am not very concerned about the efficiency in this situation. In my job, about 150,000 records were distributed to 6 files with many tabs (about 1,200) using proc export, which takes me less than 5 minutes. I use data step to drive proc export. the code is very clear and simple.
Jingju

好東西

好多高人啊

謝謝分享

高人啊

学习了。都是高人，这个要学习。

可~乐 发表于 2013-5-22 15:40

如本身class1 class2存在于那个excel里面，如何replace呀