我觉得这问题最好先用Excel把数据分列,也就是把两列变成6列!
就你说的我编程如下:
data a;
length id_worker $ 20.;
input id_company $ id_worker;
cards;
1 a2,a3,a4,a5,a6
;
data result(drop=id_worker i);
set a;
do i=1 to 5;
id_w=scan(id_worker,i,',');
output;
end;
proc print data=result;
run;