proc import out=ex
datafile="E:\need help.xls"
replace;
sheet="raw_data";
run;
data ex1;
set ex;
i=1;
do while(1=1);
gene1=scan(gene,i,';');
group1=scan(mini_group,i,';');
i+1;
if gene1="" then leave;
output;
end;
keep id gene1 group1;
run;
proc sort data=ex1 noduplicate;
by id gene1 group1;
run;