- data result;
- set base_data;
- summary_qty = scan(compress(summary,,'S'),1,';');
- summary_amt= scan(compress(summary,,'S'),2,';');
- qty = compress(summary_qty,,'dk') + 0;
- amt = compress(summary_amt,'.','dk') + 0;
- run;