方法太多了,提供两个思路
1:按一个记录读进去,然后while kscan按空格分隔输出,最后将数据库按ID倒序 输出;
2:直接按空格分别读进去,然后倒序输出;
大概写了下,仅作参考
data demo(drop=words);
infile datalines dlm=",";
length words $ 100;
input words $;
i=1;
do while (kscan(words,i,' ' )^='');
word=kscan(words,i,' ');
output;
i+1;
end;
datalines;
how are you now fine
;
proc sort data=demo out=want (keep=word);
by descending i;
run;