Cleaning and Encoding Data

 

Menu location: Data_Cleaning and Encoding.

 

• CLEAR MISSING (clear the missing data from a specified range)
• REPLACE (search for numbers or text meeting given criteria and replace them with specified numbers or text)
• TEXT TO NUMBERS (convert text to numbers)
• DATE TIME INTERVAL (convert two date or time variables into an interval between them)
• CATEGORISE (convert a continuous variable into categories, for example fifths based on quintiles)
• EXTRACT (search and optionally replace a block of data and extract the results into a new block)