想自己定制一个输出 excel目录

我找到了例子，但不能运行可能是SAS版本，excel版本的问题，有没有其他方式输出excel的程序，能定制的，现在的问题是无法合并单元格

proc odstable name=Base.Template.Table store=mystore;

cellstyle _row_ in (16) as {BackgroundColor=Palegreen },
_row_ in (15) as {BorderBottomStyle=Solid },
_row_ in (14) as {BackgroundColor=Limegreen },
mod(_row_,2) as {Background=Honeydew},
_col_ = 1 as {Width=1.2in BorderLeftColor=Black},
_col_ = 2 as {Width=2in},
_col_ = 3 as {Width=.6in},
_col_ = 4 as {Width=.5in},
_col_ = 5 as {Width=.9in};
run;
ods path (prepend) Mystore;

既然都用DDE了，可以直接用DDE去改所有格式，抛个砖
  put %unquote(%str(%'[select("r&row_startno.c&col_startno.:r&row_endno.c&col_endno.")]%'));
  put '[format.font("arial",10,false,false,false,false,1,false,false)]';

其中r&row_startno.c&col_startno.:r&row_endno.c&col_endno.是你需要修改格式的的区域

忘了你还有个merge，select后用put '[alignment(7)]';  理论上可行。