hengda 发表于 2010-1-29 21:50
例如我现在有一些数据想读入data
1232&12
dasf&
fdas1&asdf1&
我想读入的效果是按&分行
结果如下：
1232&
12dasf&
fdas1&
asdf1&
如何用sas读入？谢谢

xiaosanmao 发表于 2010-1-30 14:47
抄袭一下
data t1;
retain y ;
infile cards;
input;
n=length(_infile_) - length(compress(_infile_,'&'));
do i = 1 to n;
x=compress(catt(y,scan(_infile_,i,'&'),'&'),.);
output;
end;
y=scan(_infile_,n+1,'&');
cards;
1232&12
dasf&
fdas1&asdf1&
;
proc print; run;

bobguy 发表于 2010-1-30 22:44

xiaosanmao 发表于 2010-1-30 14:47
抄袭一下
data t1;
retain y ;
infile cards;
input;
n=length(_infile_) - length(compress(_infile_,'&'));
do i = 1 to n;
x=compress(catt(y,scan(_infile_,i,'&'),'&'),.);
output;
end;
y=scan(_infile_,n+1,'&');
cards;
1232&12
dasf&
fdas1&asdf1&
;
proc print; run;

Change
retain y ;   -----> retain y ' ';

There is an important point here.