Sentry Page Protection

Please Wait...

Geo-targeting Project [10-25]

---

We will then join the POSTCODE table with the SALES_Q1_LOC table.

The code below creates a new table called SALES_Q1_LOC_POC.

proc sql;
create table sales_q1_loc_pos as
select a.*, b.os_x as cust_x, b.os_y as cust_y
from sales_q1_loc a left join postcode b
on a.customer_postcode = b.postcode;
quit;

Did the code fail because the input data sets don't exist?

Copy and run the code below to create the input data sets.

proc import datafile = "/folders/myfolders/Geo-targeting/Data Files/Sales_Q1.csv" out = Sales_Q1 dbms = CSV replace ; run; proc import datafile = "/folders/myfolders/Geo-targeting/Data Files/locations.csv" out = locations dbms = CSV replace ; run; proc import datafile = "/folders/myfolders/Geo-targeting/Data Files/postcode.csv" out = postcode dbms = CSV replace ; run; proc sql; create table sales_q1_loc as select a.*, b.os_x as store_x, b.os_y as store_y from sales_q1 a, locations b where a.store_postcode = b.postcode; quit;

The SALES_Q1_LOC_POS table contains the eight columns from the SALES_Q1_LOC table:

• Configuration
• Customer_postcode
• Store_postcode
• Month
• Tran_date
• Price
• STORE_X
• STORE_Y

It also contains two additional columns from the POSTCODE table:

• CUST_X
• CUST_Y

The CUST_X and CUST_Y columns are the easting and northing coordinates for the customers' addresses.

Next