Sentry Page Protection
Geo-targeting Project [14-25]
We will now map the full list of England's postcodes back to the SALES_Q1_LOC_POS table: proc sql; 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; quit; 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:
|