mingfeng07 发表于 2014-11-9 22:22
特别厉害!mingfeng是高手。非常感谢mingfeng的帮助!
%macro test;
%do i=0 %to 9;
data a&i.;
infile "E:\DATA\分析师数据\AF_Forecast&i..csv" delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=4;
informat Stkcd 8. Rptdt yymmdd10. Fenddt yymmdd10. Ananm $20. Brokern $20. Feps 8. Fpe 6. ;
format Stkcd 8. Rptdt yymmdd10. Fenddt yymmdd10. Ananm 20. Brokern 20. Feps 8. Fpe 6. ;/*这个里面的空格,您有些挨在一块了,导致运行会出一点很小的问题*/
input Stkcd Rptdt Fenddt Ananm Brokern Feps Fpe ;
run;
%end;
%mend;
%test
data forecast.forecast0;
set a1-a9;
fyear=year(fenddt);byear=year(rptdt);run;