Appendix B: General SAS Content and Programs

B.1 Calculating the Number of Records with at Least One Missing Value

B.2 The SAS Power and Sample Size Application

B.1 Calculating the Number of Records with at Least One Missing Value

The following code has been used to create the effective number of non-missing observations for various missing percentages and number of variables in Table 4.1.

*** 1. Define Parameters;
%let prob_min = 0;     *** Minimum Probability;
%let prob_max = 0.3;   *** Maximum Probability;
%let prob_by  = 0.01;  *** By value for probabilities;
%let nvars = 100;      *** Maximum number of variables;
*** 2. Loop in a dataset over probabilities and number of 
       variables. Use the PROBBNML function to calculate
 probabilities from the binomial ...

Get Data Quality for Analytics Using SAS now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.