w*********y 发帖数: 7895 | 1 我最近在练习SAS PROGRAMMING, 但是碰到这个难题. OUTPUT总是
不对. 加了 DLM=','后完全不对, 只用MISSING的话, DAYS那一个
基本是MISSING. 大家帮我看看吧. 谢谢大家了.
data kids;
infile datalines dlm=',' missover;
input subj origin $ sex $ grade $ type $ missingdays @;
do until (missingdays=.);
output;
input days @;
end;
input;
datalines;
1 A M F0 SL 2,11,14
2 A M F0 AL 5,5,13,20,22
;
run; | y****n 发帖数: 46 | 2 I don't know if this is what you want.
data kids;
length temp_days $100;
infile datalines dlm=' ' truncover;
input subj origin $ sex $ grade $ type $ temp_days $;
wn=countw(temp_days,',');
do rec=1 to wn;
days=input(scan(temp_days,rec),best.);
output;
end;
drop temp_days wn;
datalines;
1 A M F0 SL 2,11,14
2 A M F0 AL 5,5,13,20,22
run; |
|