Geo-targeting Project [14-25]

Geo-targeting Marketing Campaign Free 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.

proc import datafile = "/folders/myfolders/Geo-targeting/Data Files/Sales_Q1.csv"
out = Sales_Q1
dbms = CSV
replace
;
run;</p>



<p>proc import datafile = "/folders/myfolders/Geo-targeting/Data Files/locations.csv"
out = locations
dbms = CSV
replace
;
run;</p>



<p>proc import datafile = "/folders/myfolders/Geo-targeting/Data Files/postcode.csv"
out = postcode
dbms = CSV
replace
;
run;</p>



<p>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;</p>



<p>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;</p>



<p>filename postcode '/folders/myfolders/Geo-targeting/Data Files/open_postcode_geo.csv';</p>



<p>data all_postcode (keep=postcode os_x os_y);
infile postcode dsd firstobs=2;
input postcode : $8.
col1 : $10.
col2 : $5.
os_x os_y
col3
area : $8.;
if area = "England" and os_x^=.;
run;

The Proc SQL step above adds two additional columns to the table:

CUST_X1 and
CUST_Y1

Back to Lesson

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.

Geo-targeting Project [14-25]

New to site? Create an Account

Login

or

Create a Free Account

Back in mind? Login

Forgot Password?