
sas中怎么把文本文件的数据输入进去
展开全部
先读, 读进去后再转换。
上代码:
libname rr "G:\temp";
data rr.test;
infile "R:\a.txt" dsd dlm='09'x truncover firstobs=2;
input month y1993 y1994 y1995 y1996 y1997 y1998 y1999 y2000;
run;
data rr.new(keep=month year quant);
set rr.test;
array y{*} y1993--y2000;
do i=1 to dim(y);
Year=input(substr(vname(y{i}),2,4),4.);
Quant=y(i);
output;
end;
run;
proc print data=rr.new;run;
上代码:
libname rr "G:\temp";
data rr.test;
infile "R:\a.txt" dsd dlm='09'x truncover firstobs=2;
input month y1993 y1994 y1995 y1996 y1997 y1998 y1999 y2000;
run;
data rr.new(keep=month year quant);
set rr.test;
array y{*} y1993--y2000;
do i=1 to dim(y);
Year=input(substr(vname(y{i}),2,4),4.);
Quant=y(i);
output;
end;
run;
proc print data=rr.new;run;
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询