Geo-targeting Project [15-25]

Geo-targeting Marketing Campaign Free Geo-targeting Project [15-25]

When CUST_X is missing, we will replace it with CUST_X1.

The same thing will be done for CUST_Y.

data sales_q1_loc_pos3;
set sales_q1_loc_pos2;</p>



<p>if cust_x = . then cust_x = cust_x1;
if cust_y = . then cust_y = cust_y1;</p>



<p>drop cust_x1 cust_y1;
run;

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



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

We will again check if there are any missing CUST_X and CUST_Y coordinates.

data sales_check;
set sales_q1_loc_pos3;
where cust_x =. or cust_y = .;
run;

It's empty! There is no record with missing CUST_X or CUST_Y fields.

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

New to site? Create an Account

Login

or

Create a Free Account

Back in mind? Login

Forgot Password?