发帖
雷达卡
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.
京公网安备 11010802022788号
