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 [19-25]


As mentioned, we have a total of 15 stores in London.


The marketing team would like to know the average revenue generated by each store before selecting the stores for the direct marketing campaign.

Let's find out how much revenue each store generated in the first quarter of 2017.​
proc sql;
create table stat as
select store_postcode, sum(price) as total_sales
from sales_q1_loc_pos4
group by store_postcode
order by total_sales;
quit;
Did the code fail?

Copy and run the code below to create the input data sets.

This gives you a summary of the total sales for each store:
Picture

​Management has selected the following three stores for our direct marketing campaign:
  • E7 8NW
  • N17 6QA
  • CR7 8LE
Picture

​Let's create a new table that stores the targeted stores:
proc sql;
create table target as
select distinct store_postcode
from sales_q1_loc_pos4
where store_postcode in ('E7 8NW' 'N17 6QA' 'CR7 8LE');
quit;
Picture
Next
Already a member? Go to member's area.