Preparing Your Data

 

Menu location: Data

• GENERATING
  • Workbooks and worksheets
  • Link to Microsoft Excel
  • Mark data as missing
  • Fill with a series of numbers
  • Fill with random numbers
    
    
• CLEANING AND ENCODING
  • Clear missing data
  • Search for and replace data
  • Convert text to numbers
  • Convert two date or time variables to a time-interval variable
  • Categorise a continuous variable into categories
  • Extract a subset of data
    
    
• TRANSFORMING AND DERIVING
  • Transform a continuous variable (log etc.)
  • Apply a formula or function
  • Convert between different units of measurement
  • Normal scores
  • Standardization
  • Anthropometric standardization (growth charts)
  • Derive differences, means or slopes of pairs of variables
  • Ranks
    
    
• ORGANIZING
  • Sort data range within worksheet
  • Create sorted variables
  • Rotate blocks of data

  • Combine variables into a data variable plus an identifier variable

  • Split a data variable by an identifier variable
  • Create a set of binary dummy variables to represent a variable with more than two categories
  • Extract a subset of data
  • Tabulate count variables into tables
  • Detabulate tables into count variables
  • Expand a set of unique observations and counts
  • Contract a set of observations into unique values and counts

 

See also: Crosstabs and Frequencies in the Analysis menu.