VALIDATEDATA

VALIDATEDATA is available in the Data Preparation option.

The VALIDATEDATA procedure identifies suspicious and invalid cases, variables, and data values in the active dataset.

VALIDATEDATA       [VARIABLES=varlist]
                   [ID=varlist]
                   [CROSSVARRULES=rulelist]
 [/VARCHECKS       [STATUS={ON**}]
                           {OFF }
                   [PCTMISSING={70**   }]
                               {number } 
                   [PCTEQUAL={95**  }]
                             {number}
                   [PCTUNEQUAL={90**  }]
                               {number}   
                   [CV={0.001**}]
                       {number }
                   [STDDEV={0**   }]]
                           {number}
 [/IDCHECKS        [INCOMPLETE**] [DUPLICATE**] [NONE]]
 [/CASECHECKS      [REPORTEMPTY={YES**}] [SCOPE={ANALYSISVARS}]]
                                {NO   }         {ALLVARS     } 
 [/RULESUMMARIES   [BYVARIABLE**] [BYRULE] [NONE]]
 [/CASEREPORT      DISPLAY={YES**}
                           {NO   }         
                   [MINVIOLATIONS={1**    }]    
                                  {integer}
                   [CASELIMIT={FIRSTN({500**  })}]]
                                      {integer}  
                              {NONE             } 
 [/SAVE            [EMPTYCASE[(varname)]]
                   [INCOMPLETEID[(varname)]]
                   [DUPLICATEID[(varname)]]
                   [RULEVIOLATIONS[(varname)]]]

** Default if the subcommand or keyword is omitted.

This command reads the active dataset and causes execution of any pending commands. See the topic Command Order for more information.

Syntax for the VALIDATEDATA command can be generated from the Validate Data dialog.

Release History

Release 14.0

• Command introduced.

Example

VALIDATEDATA VARIABLES=ALL.