Hi all,

I've a hospital cases dataset having 30 columns and 70 observations. Based on the types of cases they receive everyday they have a tracker to capture the values in "Y",not available cases are in "NA", also there are blank cases like ".". Here is a sample of the dataset :
Day braintumor Fracture heartbypass Accident Stroke
1 Y NA Y Y Y
2 NA Y Y Y .
3 Y . NA . Y
4 . . . Y NA
5 Y Y . Y NA
I would require help in producing a table like mentioned below with all the categories counts(by considering only "Y" cases) for individual categories divided by the no of days to get the percentages and that has to be in a specified format(xx.xx%) as shown below. Eg: if i will calculate for 5 days as shown in my example the output should look like:

totalbraintumor 3/5 (60.00%)
total Fracture 2/5(40.00%)
total Accident 2/5(40.00%)
total Stroke 4/5(80.00%)

I'm very new to Stata almost like 1.5 months back i started to learn it and behind making this output i had learned how to create the denominator I'm struck at that point. So, any guidance would be helpful in how to approach the problem from the point where i'm stopped at.


With regards,
Sitaram