Three nested it is 🙂
data out; set company_data; length fac sto pro $3;
i1 = 1; fac = scan(factory,i1);
do while (fac ne ''); i2 = 1; sto = scan(store,i2);
do while (sto ne ''); i3 = 1; pro = scan(product,i3);
do while (pro ne ''); output; i3 + 1; pro = scan(product,i3); end;
i2 + 1; sto = scan(store,i2); end;
i1 + 1; fac = scan(factory,i1); end; run;
//Fredrik
... View more