DF_qcsbyfield — Tabulate and summarize queries by category
DF_qcsbyfield
{study}
[-P # #~#]
[-S # #~#]
[-F # #~#]
[-v # #~#]
[-c # #~#]
[-u i|e]
[-s 0|1|2|3|4|5|6]
[-t 1|2|3|4|5|6|30~99]
[-D string]
[-n #]
[-r filename]
DF_qcsbyfield tabulates the number of queries, of each category, for each field in the database.
The output from DF_qcsbyfield is a table where each row is a unique data field and plate number combination (the rows are sorted by increasing plate number and by increasing field number within plate). The columns have the following appearance and meaning:
PLATE(1) FIELD DESCRIPTION(2) TOTAL(3) MISS(4) RANG(5) CONS(6) LEGI(7) FAXN(8) OTHR(9) USER(10)
|
Plate number. Rows are sorted by increasing plate number independent
of the selection order specified by | |
|
The field number and descriptive label. Rows are sorted by increasing field
number within plate number.
The text of the descriptive label is the same text required by
| |
|
The total number of queries. | |
|
The total number of queries that have a category of missing. | |
|
The total number of queries that have a category of illegal. | |
|
The total number of queries that have a category of inconsistent. | |
|
The total number of queries that have a category of illegible. | |
|
The total number of queries that have a category of fax noise. | |
|
The total number of queries that have a category of other. | |
|
The total number of queries that have any user-defined category. |
Rows where the values in each tabulated column equal 0 are always omitted from the output.
-P # #~# | Select queries for specified plates |
-S # #~# | Select queries for specified sequence/visit numbers |
-F # #~# | Select queries for specified field numbers |
-v # #~# | Select queries that are at specified validation levels |
-c # #~# | Select queries for specified sites |
-u i|e | Select queries by their usage category from the coded list:
|
-s 0|1|2|3|4|5|6 | Select queries by one status code from the list:
|
-t 1|2|3|4|5|6|30~99 | Select queries by one category from the list:
|
-D string | Select queries containing
string in the variable description.
The description string must exactly match
(with case sensitivity) the entire string (or a sub-string) of
the query description label.
If the match string contains embedded spaces, it must be enclosed
in ", e.g. -D "Prior Rx".
|
-n # | Select only data fields which have
# or more queries |
-r filename | Write each selected case to the named DRF.
If filename
does not start with /,
it is created relative to the study drf
directory.
|
Example 2.126. Tabulate external queries on plates 3 through 7 and 10
-P 3~7 10 -u e
DF_qcsbyfield: Queries on Selected Data Fields. DFstudy 253. Jul 06,2016 10:23
PLATE FIELD DESCRIPTION TOTAL MISS RANG CONS LEGI FAXN OTHR USER
3 8. Patient Initials 3: 0 0 0 0 0 2 1
4 8. Patient Initials 2: 0 0 0 0 0 2 0
5 8. Patient Initials 11: 0 0 0 0 0 9 2
5 10. Reading 1 systolic BP 1: 1 0 0 0 0 0 0
5 11. Reading 1 diastolic BP 1: 1 0 0 0 0 0 0
5 12. Reading 2 systolic BP 1: 1 0 0 0 0 0 0
5 13. Reading 2 diastolic BP 1: 1 0 0 0 0 0 0
5 16. Weight in lbs 5: 1 0 0 0 0 0 4
5 19. Returned Med. Code # 1: 1 0 0 0 0 0 0
5 23. New Bottle Med. Code # 2: 1 0 0 0 0 1 0
7 8. Patient Initials 5: 0 0 0 0 0 3 2
7 10. 1. complete entire study 1: 1 0 0 0 0 0 0
10 8. Patient Initials 1: 0 0 0 0 0 1 0
Example 2.127. Tabulate fields which have 5 or more queries
-n 5
DF_qcsbyfield: Queries on Selected Data Fields. DFstudy 253. Dec 04,2015 09:12
PLATE FIELD DESCRIPTION TOTAL MISS RANG CONS LEGI FAXN OTHR USER
2 8. Patient Initials 5: 0 0 0 0 0 5 0
2 11. Date of Birth 5: 4 0 1 0 0 0 0
2 19. Date if First Follow-up 6: 6 0 0 0 0 0 0
5 8. Patient Initials 11: 0 0 0 0 0 9 2
Example 2.128. Tabulate queries for fields with "BP" in their description
-D BP
DF_qcsbyfield: Queries on Selected Data Fields. DFstudy 253. Aug 11,2016 14:25
PLATE FIELD DESCRIPTION TOTAL MISS RANG CONS LEGI FAXN OTHR USER
1 29. 3. Taking BP medication 2: 2 0 0 0 0 0 0
5 10. Reading 1 systolic BP 1: 1 0 0 0 0 0 0
5 11. Reading 1 diastolic BP 1: 1 0 0 0 0 0 0
5 12. Reading 2 systolic BP 1: 1 0 0 0 0 0 0
5 13. Reading 2 diastolic BP 2: 1 0 0 0 0 0 1