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


Remember, the (x, y) coordinates for the customers addresses are taken from the POSTCODE table.

In the postcode table, there are only 834 records.
Picture

London is huge and there are much more than just 834 postcodes in the city.

In addition, certain customers might live outside London, and their address is not captured in the POSTCODE table.

This is why some of the customers' (x, y) coordinates are missing.


​In order to fix this, we will have to download the complete list of postcodes in the UK.
​
The data can be found here.

Scroll down and click on the ‘open_postcode_geo.csv.zip’ file:
Picture

For your convenience, we have already saved the file in the Data Files folder:
Picture
Next
Already a member? Go to member's area.