List
Data Recode
Data Recode refers to reassigning values to numbers, such as replacing the number 1 with 5, recoding individuals aged 18–30 as 1, or categorizing data into two groups based on the mean (e.g., values below the mean are recoded as 1, while values above the mean are recoded as 2). SPSSAU supports the following functions:
Recode a single or multiple titles with numerical values
Recode a single or multiple titles based on defined ranges
Automatically group data into categories for a single or multiple titles
Overwrite the original data (or generate a new title)
Automatically synchronize title labels after recode
SPSSAU Operations
Select 'title.' You can use ctrl or shift to select multiple titles for batch recode.
Numerical Recode: Replace specific numbers with desired values.
Range Recode: For example, recode under 18 as 1, 18–30 as 2, and above 30 as 3, as shown in the picture below:
Data Format
Note:
Range recode follows a closed interval rule, meaning both endpoints are included. If a value appears multiple times, its first occurrence determines its recode. For instance, in the example above, 18 appears twice, but it is recoded as 1.
Automatic Grouping is as follows:
- SPSSAU provides four methods: three-group division using the 27th and 73rd percentiles (Below the 27th percentile → 1; Between the 27th and 73rd percentiles → 2; Above the 73rd percentile → 3).
- Two-group division using the 50th percentile as the cutoff: Below median → 1; Above median → 2.
- Two-group division using the mean as the cutoff: Below mean → 1; Above mean → 2.
- Four-group division using the 25th, 50th, and 75th percentiles: Below the 25th percentile → 1; Between the 25th and 50th percentiles → 2; Between the 50th and 75th percentiles → 3; Above the 75th percentile → 4.
- Automatic grouping is a quick processing tool and can be fully replaced by range recode. When using automatic grouping, a new title will be generated for identification.
Descriptions for 'Overwrite' and 'Label Synchronization' are as follows:
| Parameter | Description |
|---|---|
| Overwrite | If selected, numerical recode and range recode will directly replace the original data. If not selected, a new title will be created with a name like 'New_****'. |
| Label Synchronization | If selected, title labels will be automatically synchronized. For example, if the original data had 1 = Male, and 1 is now recoded as 2, the label Male will also be applied to 2 in the new title. |