Geo-targeting Project [14-25]
We will now map the full list of England's postcodes back to the SALES_Q1_LOC_POS table:
create table sales_q1_loc_pos2 as
select a.*, b.os_x as cust_x1, b.os_y as cust_y1
from sales_q1_loc_pos a left join all_postcode b
on a.customer_postcode = b.postcode;
Did the code fail?
Copy and run the code below to create the input data sets.
The Proc SQL step above adds two additional columns to the table: