I've developed a report grouped on a distinct patient MRN. I go through all records (at the detail level) for each patient and report whether or not they have ever had a certain diagnosis and/or a certain procedure. This logic all works fine.
The problem I'm having is creating a cross tab (2 x 2 table) for an odds ratio. If they have a and b, if they have a not b, b not a, neither a nor b.
The cross tab only seems to work at the individual record level, in spite of my formulaes and groupings. All the grouping are unavailable.
As a later refinement I will be showing the detail level to the user (if needed) and will be selecting time frames for the diagnoses and procedures to occur. So I need to keep this capacity.
I think canned cross tabs can't do this, any other ideas?
Thanks
The problem I'm having is creating a cross tab (2 x 2 table) for an odds ratio. If they have a and b, if they have a not b, b not a, neither a nor b.
The cross tab only seems to work at the individual record level, in spite of my formulaes and groupings. All the grouping are unavailable.
As a later refinement I will be showing the detail level to the user (if needed) and will be selecting time frames for the diagnoses and procedures to occur. So I need to keep this capacity.
I think canned cross tabs can't do this, any other ideas?
Thanks