Since visits contains the number of following columns, do this:
data testing;
infile datalines missover dlm=',' dsd;
input id $ visits @;
do i = 1 to visits;
input unitpurchased @;
if unitpurchased = . then unitpurchased = 0;
output;
end;
drop visits i;
datalines;
C005,3,15,,39
D2356,4,11,,,5
A323,3,10,15,20
F123,1,
run;
Edit: added the dsd option.
... View more
