Proc Tabulate to automate report

I have to use proc tabulate to create the report that I am attaching in the reply to this message. I don't care if it is 3 different tables I just need the code to reflect the report.

The final result does not have to be in EXCEL. I attached the excel dataset, to this message, because that it what we will always be using to create the report. I am not certain how to pull only values from a variable that I need. A little more about the dataset. All TB "contacts" are listed by the StateCaseNo. Repeated StateCaseNo means that is the same contact for one TB case. The purpose of the report is to use the contact's datasheet, which I have attached, to make a report showing how many contacts, how many cases, how many contacts got the disease (disease status is listed in the DispositionClass_Desc variable; blanks indicate not infected), how many contact got the infection (once again, it's listed in DispositionClass_Desc), how many started treatment (I'm assuming we could tell this by looking a started treatment date variable), and how many completed treatment (i used the therapy_stop_reason variable). The "others" variable on the report are referring to kids ages 2 and under. I do not know how to get the table to format like the report I attached on my initial post. I was going to use the Therapy_Stop_Reason variable for the middle table of the report. The last table calculates rates using the same variables from the 1st table. This is the part where I have no idea what to do. The (b1/a1),% next to the numbers in the table I am not concerned about. I am really just wanting the calculation rates. Please let me know if I cleared this up a little or if it is still vague. I have copied and pasted the first few lines of the dataset below. The enitre dataset is attached. Thank you!

I forgot to put the code I already have. I have attached it above. My code is printing out the first two tables (the best I could get it to mimic the report). The last table is computing variables that I do not know how to do.

If my question seems too vague...I am mostly concerned with how to compute the variables in the third table printed on the ARPE report.

Or add the label in a data set or label statement in proc tabulate to clean up the code.

I can't tell quickly from the example data how the number of contacts per case would be derived. For a single call to Tabulate you would want to have a variable in the data that has the count per contact appear ONCE for whatever a "Case" may be in this context.