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...
Exercise


Restaurant Spending Promotion

​In addition to the Sephora promotion, your company has also decided to launch a restaurant-spending promotion.

Use your xyz credit card at your favourite restaurants 5 times this month and receive a $20 McDonald's coupon!

Below are the tasks for this project:
  1. Calculate how many customers made at least three restaurant transactions in January. The MCC codes for restaurant spending are 5812 and 5813.
    ​
  2. We'd like to raise the restaurant spending of customers who have not used our credit card in a restaurant often. Build a target base with the following criteria:

    - Customers who have had less than three restaurant transaction in January, and
    - Customers who have an income greater than $80,000.

  3. Finalize the target base by excluding:
    - Do-not-call customers and
    - Inactive customers and
    - Customers who have not given consent to receive marketing messages, and
    - Customers who have received our marketing promotion at least six times in January.

  4. Set aside 10% of the customer base as a control group. (Note: use the Ranuni function with seed=100 when creating the control group.)

  5. Create the leads in a text file and save it in the shared folder.

  6. Review the spending in February and conclude whether or not the promotion was effective.



​Submit your program below:
Fill out my online form.
Already a member? Go to member's area.