What Syntax Can Be Used to Create Case Selection/Verification/Recode Conditions (or to Calculate Variable Values Using Spreadsheet Formulas)?
Recoding variable values, performing case selection for analyses, or verifying quality of data involve a comparison of conditions or values encountered in the spreadsheet with conditions specified by an expression to determine a further action for each case (i.e., respectively assigning a new variable value, including the case in an analysis, or verifying that the data associated with a case are correct). Assigning variable values via a spreadsheet formula involves case-by-case calculation of values for a variable based directly on the values of other spreadsheet variables and/or parameters not included in the spreadsheet. For data transformations more extensive or more complex than can be accomplished using the variable recode and spreadsheet formula facilities provided, use the STATISTICA Visual Basic language.
