s*******2 发帖数: 791 | 1 1.用ODS 或者 Proc Export,只知道怎么创建一个ExcelBook.有什么方法可以创建多个
Tab吗?例如有什么options? 或者file format?
2.我有一组SAS数据要输出到Excel.希望按照变量A的数值(A=1001, A=1002, A=1003,..
.),为每一个可能的A值输出一个sheet在这个Excel book。也就是说如果A有10个值,
这个ExcelBook就含有10 个Tabs。怎么实现?谁能给我一个Macro?
谢谢 | g*******y 发帖数: 380 | 2 I suppose "the tab" you mentioned is worksheet in Excel workbook.
You can search "sas export to excel multiple sheets". | p********a 发帖数: 5352 | 3 *-> Macro to Combine Worksheets;
%macro many2one(in=,out=);
options noxwait;
x erase "&out";
options xwait;
data _null_;
file "c:\temp\class.vbs";
put 'Set XL = CreateObject("Excel.Application")' /
'XL.Visible=True';
%let n=1;
%let from=%scan(&in,&n," ");
%do %while("&from" ne "");
%let fromwb=%scan(&from,1,"!");
%let fromws=%scan(&from,2,"!");
put "XL.Workbooks.Open ""&fromwb""";
%if &n=1 %then
put "XL.ActiveWorkbook.SaveAs ""&out"", -4143"%str(;);
%else %do;
put "XL.Workbooks(""%scan(&fromwb,- | y****n 发帖数: 46 | 4 you can use proc print instead of proc report.
ods tagsets.ExcelXP file="&dir\reports\outputs\Clinical Review Listing.xls"
style=printer options(DEFAULT_COLUMN_WIDTH="10");
ods tagsets.ExcelXP options(sheet_name='Demography' );
proc report data=dmg_medhist_therapy nowd split="*";
column CTR1N SID1A SBJINI1A DOB1D AGEDRV1N ETH2C SEX1C RCE5C ACTPRB1C
HISCND1A TYPCHY2C;
define CTR1N/order ;
run;
ods tagsets.ExcelXP options(sheet_name='Vital Signs' );
proc report data=vsn nowd center split=" |
|