libname EXL excel "W:\Data Integrity\Projects\Walgreens Power Project\New Version\Output\Walgreens Power Impact Assessment template.xls"
ver=2002 SCAN_TEXTSIZE=NO;
proc datasets lib=EXL;
delete Crestor_Input;
delete 'Crestor_Input$'n;
run;
data EXL.'Crestor_Input'n;
  set ratio_Crestor;
run;
run;

libname EXL clear;

**********************
我想把SAS dataset 导出到excel 模板里面，用excel 2003 的模板就上面的程序就okay了， 但是我现在有个excel2007的模板，如果直接跑上面的程序 模板后缀改成xlsx 就报错了（程序及错误如下）， 有什么好的办法能实现将其直接输出的.xlsx 里面哪？请各位指点下，谢谢！

libname EXL excel "W:\Zhehong\Walgreens 90 day supply\Template_Rxsize.xlsx"
ver=2002 SCAN_TEXTSIZE=NO;
proc datasets lib=EXL;
  delete RXSIZE;
delete 'RXSIZE$'n;
run;
data EXL.'RXSIZE'n;
  set FINAL_YOY;
run;
libname EXL clear;

82   libname EXLX excel "W:\Zhehong\Walgreens 90 day supply\Template_Rxsize.xlsx"
83   ver=2002 SCAN_TEXTSIZE=NO;
ERROR: ERROR: File extension xlsx has conflict with the version specified.
ERROR: Error in the LIBNAME statement.
84
85   proc datasets lib=EXLX;
ERROR: Libname EXLX is not assigned.
86     delete RXSIZE;
87     delete 'RXSIZE$'n;
88   run;
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
NOTE: The SAS System stopped processing this step because of errors.