I am trying to create a report to send out to a group of medical centers that details each record that is missing 1 of 31 variables. I have a group of 30+ database managers.
The report might look like this, with the participating medical center, the record id from the database, the variable of interest, and a variable that details the date. The report would output (for each medical center) all the records missing variable1, then all the records missing variable2, and so forth.
Medical Center One
recordid variable1 date
recordid variable2 date
Thoughts on how to efficiently create this?
Thanks in advance,
Donald Likosky
The report might look like this, with the participating medical center, the record id from the database, the variable of interest, and a variable that details the date. The report would output (for each medical center) all the records missing variable1, then all the records missing variable2, and so forth.
Medical Center One
recordid variable1 date
recordid variable2 date
Thoughts on how to efficiently create this?
Thanks in advance,
Donald Likosky
Comment