Using PROC TABULATE to Count Missing and Nonmissing Values for Numeric Variables
Instead of using PROC MEANS to count numeric missing values, you might want a more attractive table from PROC TABULATE. This, however, adds significant complications. Before writing the general purpose program, let’s first see how PROC TABULATE can provide information on your numeric variables. Program 3-6 lists the number of nonmissing and missing values and the minimum and maximum values for three numeric variables in the PATIENTS data set.
Program 3-6. Listing the Number of Nonmissing and Missing Values and the Minimum and Maximum Values for All Numeric Variables
PROC TABULATE DATA=CLEAN.PATIENTS FORMAT=8.; TITLE "Missing Values, Low and High Values for Numeric ... |
Get Cody’s Data Cleaning Techniques Using SAS® Software 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.
