We will now generate the list of postcodes that are within 4.5 km of the three stores that we selected.
The code below finds all the postcodes that are within 4.5 km of the stores:
proc sql; create table target_postcode as select a.*, round(((b.os_x - a.os_x)**2 + (b.os_y - a.os_y)**2) **0.5, 1) as dist from all_postcode a, locations b where b.postcode in (select store_postcode from target) and calculated dist <= 4500; quit;
Did the code fail?
Copy and run the code below to create the input data sets.
There are 42408 postcodes that fall within the range of 4.5 km from the selected stores: