Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What the heck is wrong with my table script.

Status
Not open for further replies.

SUGNLNK

Technical User
Nov 25, 2009
1
US
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%.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top