某个文件夹里有编号连续的excel表格(现券买卖双边报价1-21),用如下程序导入,结果出现:宏 QUOTE 已被指定了保留名称、将编译哑宏、宏函数名后没有找到期望的左括号三个错误,忘高手指正:
%macro import;
PROC IMPORT OUT= WORK.quote&i
DATAFILE= "E:\Data\现券买卖双边报价\现券买卖双边报价&i..xls"
DBMS=EXCEL REPLACE;
RANGE="CBDDUALBID$";
GETNAMES=NO;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
run;
%mend import;
%macro quote;
%do i=1 %to 21;
%import;
%end;
%mend quote;
%quote;