I’m getting unexpected results from running CohortMethod and was wondering if you could point me in the right direction.
Here is what I have done:
I created three cohorts using Circe. Here they are on ohdsi.org if helpful:
Target - http://www.ohdsi.org/web/circe/#/814
Comparator - http://www.ohdsi.org/web/circe/#/815
Outcome - http://www.ohdsi.org/web/circe/#/816
I confirmed that all three cohorts generated patients from my local CDM. I then ran some manual SQL joins to ensure that there is overlap in patients between my target / comparator cohorts and outcome cohort.
I moved these three cohorts to a dedicated table and set up the CM configuration as described in the SingleStudy vignette, using the appropriate cohort_definition_ids for my targetId, comparatorId, and outcomeId.
Things run swimmingly for a while, then I get what appears to be empty result set (i.e., no outcomes found).
Constructing treatment and comparator cohorts
Executing multiple queries. This could take a while
|==================================================================================================================================| 100%
Analysis took 0.822 secs
Fetching data from server
Loading took 2.56 secs
Constructing default covariates
|==================================================================================================================================| 100%
Analysis took 9.72 hours
Done
Fetching data from server
Loading took 4.11 mins
Removing redundant covariates
Normalizing covariates
Constructing outcomes
Executing multiple queries. This could take a while
|==================================================================================================================================| 100%
Analysis took 6.27 secs
Done
Fetching data from server
Loading took 0.306 secs
Error in UseMethod("open") :
no applicable method for 'open' applied to an object of class "data.frame"
In addition: Warning message:
In lowLevelQuerySql.ffdf(connection, sql) :
Data has zero rows, returning an empty data frame
What puzzles me is why the result set would be empty when I have confirmed patients do indeed appear in the outcome group. I assume I have done something incorrectly in my configuration. Has any one else had this problem?
I am happy to post my configuration but didn’t want to bomb people’s inboxes.
Thanks
Jon