Personal tools
You are here: Home Software Packages SAS Handy SAS programs Verify missing values are in a dataset

Verify missing values are in a dataset

Check for missing numeric values in a dataset.

Assuming the number of missing values are few, but you want to verify they exist and what record contains the missing the following code should work:

libname xyz "Directory or path name here";
DATA _NULL_;
  set xyz.yourdata;
  file "Missing.values.list";
  if NMISS(of _NUMERIC_) gt 0 then
     put "Missing value found in observation " _N_;
run;
Document Actions

Copyright ©2008, The Pennsylvania State University | Privacy and Legal Statements
Contact the Help Site Administrator | Last modified Aug 13, 2008 | Weblion Partner