We will look at the volumes sold and the sales generated for each configuration to decide which configuration to promote:
proc sql;
create table config as
select configuration, count(*) as num_sold, sum(price) as total_sales
from sales_q1_loc_pos4
group by configuration
order by total_sales desc;
quit;
Did the code fail?
Copy and run the code below to create the input data sets.
The configurations are sorted by total revenue generated in descending order:
