Search the site...

SASCRUNCH TRAINING
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
Sentry Page Protection
Please Wait...
Geo-targeting Project [23-25]


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:
Picture
Next
Already a member? Go to member's area.