As you can see in the code below, I am creating score bands for data. I am then creating separate tables to dissect the data by their relative score band. These tables are then combined and used to create a table of percent totals. The issue I am having is that the separate score bands are not cumulative and thus not providing cumulative percent totals. For example, the '0.95' score band is only pulling in the rows of data that have a score of 0.95 it is not pulling in the 0.98 nor 0.99 scoreband data. I am not sure where the error lies in the code or what could be done differently to arrive at the result I am wanting. Please help. data b_&i.; set a1_&i.; if score >=0.99 then scoreband = '0.99 '; else if score >=0.98 then scoreband = '0.98 '; else if score >=0.95 then scoreband = '0.95 '; else scoreband = '0.94-'; run; proc sql; create table s_&i. as select Scoring_Sample_Date, description, count(distinct(field)) as Greater_Than_or_Equal_To_99 from b_&i. where scoreband = '0.99' group by Scoring_Sample_Date, Description; Run; proc sql; create table s1_&i. as select Scoring_Sample_Date, description, count(distinct(field)) as Greater_Than_or_Equal_To_98 from b_&i. where scoreband = '0.98' group by Scoring_Sample_Date, Description; run; proc sql; create table s2_&i. as select Scoring_Sample_Date, description, count(distinct(field)) as Greater_Than_or_Equal_To_95 from b_&i. where scoreband = '0.95' group by Scoring_Sample_Date, Description; proc sql; create table s3_&i. as select Scoring_Sample_Date, description, count(distinct(field)) as total from b_&i. group by Scoring_Sample_Date, Description; data c_&i.; merge s_&i. s1_&i. s2_&i. s3_&i.; by Scoring_Sample_Date description; run; data d_&i.; set c_&i.; Perc_99 = Greater_Than_or_Equal_To_99/total; format Perc_99 percent7.1; Perc_98 = Greater_Than_or_Equal_To_98/total;format Perc_98 percent7.1; Perc_95 = Greater_Than_or_Equal_To_95/total;format Perc_95 percent7.1; run; proc sql; create table f_&i. as select Scoring_Sample_Date, description, perc_99, perc_98, perc_95 from d_&i.; Thank you, Austin Harris
... View more