You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Feature Extraction calculates the occurrence of Covariates in relation to target cohort_start_date. Is it possible to add a parameter that allows it to switch from cohort_start_date to cohort_end_date
Specifically: in the various SQL's in Feature Extraction, the SQL is something like this
ON @domain_start_date <= DATEADD(DAY, time_period.end_day, cohort.cohort_start_date)
AND @domain_end_date >= DATEADD(DAY, time_period.start_day, cohort.cohort_start_date)
or
ON covariate_cohort.cohort_start_date <= DATEADD(DAY, time_period.end_day, cohort.cohort_start_date)
WHERE covariate_cohort.cohort_end_date >= DATEADD(DAY, time_period.start_day, cohort.cohort_start_date)
Can we introduce a switch that now changes cohort.cohort_start_date to cohort.cohort_end_date
Use Case: An easy use case is to understand the characteristics of a person at some time-window of discontinuation from continuous drug treatment era, such as what happened at the time periods in relation to stopping a statin therapy. One way we can calculate this is today is to build a cohort using custom SQL where cohort_start_date is drug_era_end_date, as standard tools like Atlas cannot index a cohort based on end of a drug_era. But, if FE can calculate covariates based on cohort_end_date, then we can start thinking of cohort_end_date diagnostics.
cohort_end_date characterization/diagnostics may help answer questions like
what was the visit context at around the time of exit
What were the events at around the time of exit (new diagnosis, new treatments)
We can also compare the characteristics of cohort on cohort_start_date to characteristics on cohort_end_date.
Feature Extraction calculates the occurrence of Covariates in relation to target cohort_start_date. Is it possible to add a parameter that allows it to switch from cohort_start_date to cohort_end_date
Specifically: in the various SQL's in Feature Extraction, the SQL is something like this
or
Can we introduce a switch that now changes cohort.cohort_start_date to cohort.cohort_end_date
Use Case: An easy use case is to understand the characteristics of a person at some time-window of discontinuation from continuous drug treatment era, such as what happened at the time periods in relation to stopping a statin therapy. One way we can calculate this is today is to build a cohort using custom SQL where cohort_start_date is drug_era_end_date, as standard tools like Atlas cannot index a cohort based on end of a drug_era. But, if FE can calculate covariates based on cohort_end_date, then we can start thinking of cohort_end_date diagnostics.
cohort_end_date characterization/diagnostics may help answer questions like
Related to OHDSI/CohortDiagnostics#298
The text was updated successfully, but these errors were encountered: