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...
Picture
Data for Coding Exercises


The next six exercises will be based on the Airbnb rental data below.

Copy and run the code from the yellow box.

The code above creates four tables:
  • ​HOST
  • PROPERTY
  • RENTEALDATA
  • GUEST

The HOST table contains the information about a list of Airbnb hosts. It contains data such as the host’s name, ID, property, age and income.

The PROPERTY table contains the information about the properties on the Airbnb listings. It has each  property’s neighborhood, number of bedrooms and price per night.

RENTALDATA is the largest table among the four. It has the rental data for the month of January in 2016. 

The GUEST table contains the information about the guests who rented a property during the month of January in the Toronto area.

Review each table carefully and understand how the data is stored in each table.
Next
Already a member? Go to member's area.