RSUBMIT;
OPTIONS COMPRESS=yes;
LIBNAME FDCA 'FDCA2010$DISK:[ADCANFINAL.PROD]';
LIBNAME Ronia 'EVAL_QA:[R_CHAAR]';
PROC SQL;
create table work.aoql as
select a.lco, a.aa, sum(input(b.aa_totalrecs,1.)) as samplesize,
sum(input(a.criterrct, 1.)) as add_criterr,
sum(input(a.noncriterrct, 1.)) as add_noncriterr,
sum(input(b.aa_criterr,1.)) as ad_criterrsum,
sum(input(b.aa_noncriterr,1.)) as ad_noncriterrsum
from fdca.address as a
inner join fdca.aa as b
on a.lco=b.lco and
a.case_dqc='Y'
where a.lco in ('3052','3054') and a.aa in ('001133', '000504', '004215', '001847', '00145')
;
quit;
proc print data=work.aoql(obs=70); run;
ENDRSUBMIT;
Trying to get to this table somehow......urgh
Address Canvassing DQC Algorithm
# of HUs in AA
(x)
DQC Sample
Allowable Critical Errors
Critical AOQL
Allowable
Noncritical Errors
Noncritical
AOQL
x <= 50
50< x <=100
100< x <=150
150< x <=175
175< x <=200
200< x <=275
275< x <=500
500< x <=1000
x > 1000
The weighted average AOQL over all AA sizes for critical errors is X%, and the weighted average AOQL for noncritical errors is X%.
OPTIONS COMPRESS=yes;
LIBNAME FDCA 'FDCA2010$DISK:[ADCANFINAL.PROD]';
LIBNAME Ronia 'EVAL_QA:[R_CHAAR]';
PROC SQL;
create table work.aoql as
select a.lco, a.aa, sum(input(b.aa_totalrecs,1.)) as samplesize,
sum(input(a.criterrct, 1.)) as add_criterr,
sum(input(a.noncriterrct, 1.)) as add_noncriterr,
sum(input(b.aa_criterr,1.)) as ad_criterrsum,
sum(input(b.aa_noncriterr,1.)) as ad_noncriterrsum
from fdca.address as a
inner join fdca.aa as b
on a.lco=b.lco and
a.case_dqc='Y'
where a.lco in ('3052','3054') and a.aa in ('001133', '000504', '004215', '001847', '00145')
;
quit;
proc print data=work.aoql(obs=70); run;
ENDRSUBMIT;
Trying to get to this table somehow......urgh
Address Canvassing DQC Algorithm
# of HUs in AA
(x)
DQC Sample
Allowable Critical Errors
Critical AOQL
Allowable
Noncritical Errors
Noncritical
AOQL
x <= 50
50< x <=100
100< x <=150
150< x <=175
175< x <=200
200< x <=275
275< x <=500
500< x <=1000
x > 1000
The weighted average AOQL over all AA sizes for critical errors is X%, and the weighted average AOQL for noncritical errors is X%.