Geo-targeting Project [6-25]

If you haven't imported the two files, you can run the code below to import them again.

Remember: you must specify the unique location path of the Geomarketing folder in the code:

*Example: %let path = /home/kisumsam/Geomarketing ;
%let path = <folder location path>;

%macro import ();
OPTIONS VALIDVARNAME=V7;
proc import datafile = "&path/Test File.csv"
out = test
dbms = CSV
replace
;
run; 

proc import datafile = "&path/sales_q1.csv"
 out = Sales_Q1
 dbms = CSV
 replace
 ;
run;

proc import datafile = "&path/Locations.csv"
 out = locations
 dbms = CSV
 replace
 ;
run;

proc import datafile = "&path/postcode.csv"
 out = postcode
 dbms = CSV
 replace
 ;
run;

filename postcode "&path/open_postcode_geo.csv";

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;

proc import datafile = "&path/computers.csv"
 out = computers
 dbms = CSV
 replace
 ;
run;

%mend;

%import();