DSM data testing: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 19: | Line 19: | ||
=== comparing number of patients === | === comparing number of patients === | ||
430 entries in requester, but some are duplicates: . | 430 entries in requester, but some are duplicates: . | ||
SELECT [1_requester_cc].D_ID, Count([1_requester_cc].D_ID) AS CountOfD_ID | SELECT [1_requester_cc].D_ID, Count([1_requester_cc].D_ID) AS CountOfD_ID | ||
FROM 1_requester_cc | FROM 1_requester_cc | ||
| Line 25: | Line 24: | ||
HAVING (((Count([1_requester_cc].D_ID))>1)) | HAVING (((Count([1_requester_cc].D_ID))>1)) | ||
ORDER BY Count([1_requester_cc].D_ID) DESC; | ORDER BY Count([1_requester_cc].D_ID) DESC; | ||
7 D_IDs show up twice in requester. Those patients have different instances. | |||
====Query 4_1_compare==== | ====Query 4_1_compare==== | ||
| Line 31: | Line 31: | ||
383 - have results ''during'' the stay (during column = -1) | 383 - have results ''during'' the stay (during column = -1) | ||
( | (what did I mean by) | ||
No results for 40 of them. | No results for 40 of them. | ||