Sentry Page Protection
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; if cust_x = . then cust_x = cust_x1; if cust_y = . then cust_y = cust_y1; drop cust_x1 cust_y1; run; Did the code fail?
Copy and run the code below to create the input data sets. 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. |