Clinical Trial SAS programmer need import lots of multiple sheet excel file. This macro help to import them to reduce your time.
Summary table were widely used, such as clinical trial field ADAE table. This kind od table
need calculate 1) counts of elements in column a group by a(subtotal), column b group by a and b; 2) counts of elements in column b group by b(subtotal), column a/b without group by (total)
In the sample code we will calculate 4 times to get the number mentioned above.