Problem with Analysis 606 about achilles HOT 2 CLOSED

No, having a negative date shouldn't be a 'fatal' data problem that
prevents completion of the query.

Here's the TSQL query for analysis 606:

select 606 as analysis_id,
procedure_concept_id as stratum_1,
gender_concept_id as stratum_2,
count(count_value) as count_value,
min(count_value) as min_value,
max(count_value) as max_value,
avg(1.0_count_value) as avg_value,
stdev(count_value) as stdev_value,
max(case when p1<=0.50 then count_value else -9999 end) as median_value,
max(case when p1<=0.10 then count_value else -9999 end) as p10_value,
max(case when p1<=0.25 then count_value else -9999 end) as p25_value,
max(case when p1<=0.75 then count_value else -9999 end) as p75_value,
max(case when p1<=0.90 then count_value else -9999 end) as p90_value
from
(
select po1.procedure_concept_id,
p1.gender_concept_id,
po1.procedure_start_year - p1.year_of_birth as count_value,
1.0_(row_number() over (partition by po1.procedure_concept_id,
p1.gender_concept_id order by po1.procedure_start_year -
p1.year_of_birth))/(count(po1.procedure_start_year - p1.year_of_birth) over
(partition by po1.procedure_concept_id, p1.gender_concept_id)+1) as p1
from person p1
inner join
(select person_id, procedure_concept_id, min(year(procedure_date)) as
procedure_start_year
from procedure_occurrence
group by person_id, procedure_concept_id
) po1
on p1.person_id = po1.person_id
) t1
group by procedure_concept_id, gender_concept_id
;

Is it possible you have NULL procedure dates? that still shouldn't cause a
failure of the query but may do some other wonky things...

On Sun, Jun 15, 2014 at 4:30 PM, jduke99 [email protected] wrote:

I have run Analysis 606 several times and it does not make it to the
Results table. But I do get this ERROR in Achilles HEEL:

ERROR: Distribution of age by procedure_concept_id; min should not be
negative

Is this a "fatal" data problem then that prevents completion of the query?
I want to sleuth out the cause (assuming something to do with birthdates).
But wondering if ACHILLES could still complete output even with this error.

—
Reply to this email directly or view it on GitHub
#9.

from achilles.

Hi Jon,

Are you still having this problem? I'm unable to reproduce it. You can check whether the results are produced using the fetchAchillesAnalysisResults function:

fetchAchillesAnalysisResults(connectionDetails, "<your_results_schema>", 606)

Cheers,
Martijn

from achilles.