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 (5-10)

Jessica has decided to invest in a property in one of the three neighborhoods below:
  • Dufferin Grove (83)
  • Broadview North (57)
  • Trinity-Bellwoods (81)

Task 1:

Ideally, she'd like to invest in a neighborhood that has fewer competitors. The lower the number of the properties in the neighborhood, the better.

Write a Proc SQL step to compute the number of properties in each of the three neighborhoods above. Which neighborhood has the lowest number of listings?

Task 2:

In addition, she'd like to invest in the neighborhood where the average rating is below 4. 

Write a Proc SQL step to compute the average rating for each of the three neighborhoods.

Is there any neighborhood where the average rating is above 4?
Next
Already a member? Go to member's area.