Survey data analysis
I have a dataset that has a similar format to the below:
Hospital PatientID Diagnosis Needed Medication
A 2 Sepsis Yes
A 5 Influenza Yes
B 12 Cough No
C 22 Influenza Yes
The actual data set has about 3000 pts, 50 hospitals and 150 variables to report on.
I need to generate individual summary reports for each hospital using counts of catagorical data (Yes/No). I need to then take the number of 'Yes' counts (numerator) and divide by the number of patients in that hospital (denominator) to report a percent.
I can easily do the calculation in my stats program, but would prefer to use Filemaker since it can generate visually pleasing reports.
I'm pretty sure these calculations are not difficult in Filemaker, but since I'm under a deadline I thought I would post to the forum to ask about the syntax.
Thanks for your assistance,