
Re: Multiple Resident Loads
Clever Anjos Jun 3, 2016 4:52 PM (in response to Linda Pembroke)LOAD *,
WeightOfAdjProb65_74 * AvgAdjProb_65to74 as WeightedCal_74,
WeightOfAdjProb75_84 * AvgAdjProb_75to84 as WeightedCal_84,
WeightOfAdjProb85_105 * AvgAdjProb_85to105 as WeightedCal_105;LOAD
Sum(If(AgeFlag=1,NUMERATOR_PCR,0)) as Age64_105Num,
Sum(AgeFlag74)/Sum(AgeFlag) as WeightOfAdjProb65_74,
Sum(AgeFlag84)/Sum(AgeFlag) as WeightOfAdjProb75_84,
Sum(AgeFlag105)/Sum(AgeFlag) as WeightOfAdjProb85_105,
Sum(If(AgeFlag74=1,[Average Probability of readmission],0))/Sum(AgeFlag74) as AvgAdjProb_65to74,
Sum(If(AgeFlag84=1,[Average Probability of readmission],0))/Sum(AgeFlag84) as AvgAdjProb_75to84,
Sum(If(AgeFlag105=1,[Average Probability of readmission],0))/Sum(AgeFlag105) as AvgAdjProb_85to105
Resident PCR_DETAILS_HEDIS2016
Where (Match (_PCR2_CalcKEY, 'PCR2Jan2017')); 
Re: Multiple Resident Loads
Sunny Talwar Jun 3, 2016 4:58 PM (in response to Linda Pembroke)Its strange that without your where clause all the fields were loaded because I would have thought that in your current state, with or without the where statement you would only get 3 field. The reason being you missed * in your preceding load to load all the fields in the subsequent load.

Re: Multiple Resident Loads
Linda Pembroke Jun 8, 2016 3:31 PM (in response to Sunny Talwar )Thank you both! Silly mistake. So, I should be able to concatenate these statements as tables for each month going forward?
