Search the site...

SASCRUNCH TRAINING
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
Sentry Page Protection
Please Wait...
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.
Picture
Next
Already a member? Go to member's area.