Features Validation Compare Pricing Blog Cite Download

Between importing a dataset and running an analysis sits a step almost every applied paper glosses over: data preparation. Are your Likert items typed as ordinal or scale? Did you remember to reverse-code the three negatively-worded items in the rumination scale? Did you collapse the age variable into meaningful bands?

AnalyVa handles all of these inside a single Data → Variable View panel — one that will feel familiar if you have ever used SPSS.

Getting to the Data view

Step 1 — Click Data in the top toolbar. Once your dataset is imported, the Data button (rightmost cluster, next to Export) opens a full-screen data browser.

The Data button highlighted in the top toolbar

Step 2 — Switch to Variable View. The Data browser has two tabs: Data View (rows and cells, like a spreadsheet) and Variable View (one row per variable, listing type, label, values, missing-value codes).

The Variable View tab in the Data browser

Every subsequent operation in this post happens in Variable View.

Task 1 — Change the type of a single variable

By default, AnalyVa infers types from the imported data (numeric → Scale, text → Nominal, etc.). To change a variable’s type:

Step 3 — Click the Type dropdown for the row you want to change. You will see three options: Scale (Numeric), Nominal (Categorical), and Ordinal.

The Type dropdown open on a single row

Step 4 — Pick the appropriate type. As a quick reminder:

Most survey scale items are technically ordinal, but many analyses treat them as scale in practice. Pick the type that matches the analysis you plan to run.

The variable's new type applied

Step 5 — The change is instant. No Save button, no confirmation dialog. AnalyVa applies the type change immediately.

The updated Variable View

Step 6 — Sanity-check downstream. Every row shows a small type-icon on the left of the Type dropdown — scale, nominal, or ordinal. Scan the column to catch any variables still typed wrong.

The Variable View listing all typed variables

Task 2 — Change the type of many variables at once

If you just imported a 60-item questionnaire, changing types one row at a time is tedious. AnalyVa has a bulk-change mode.

Step 7 — Tick the checkbox on each row you want to change. The leftmost column is a selection checkbox. Ticked rows highlight red.

Multiple rows selected for bulk change

Step 8 — Pick the new type from Change selected to and click Apply. At the top of the Variable View, next to the Select all checkbox, a dropdown appears with — pick type —. Choose Scale, Nominal, or Ordinal. A counter tells you how many rows the change will affect (here: 11 selected). Click Apply and every selected row updates at once.

Bulk type-change to Ordinal with 11 variables selected

Task 3 — Reverse-code a scale

Well-designed questionnaires often include negatively-worded items to catch inattentive respondents. Before analysing the scale, those items must be reverse-coded — a 5 on a 5-point Likert flips to 1, a 4 flips to 2, and so on.

Step 9 — Confirm the recoding applied. The header shows a confirmation like “11 variables set to ordinal” so you know the previous step succeeded.

Confirmation that the bulk change was applied

Step 10 — Return to the main workspace. Close the Data view or press Esc. The sidebar now shows every variable in the dataset.

Back on the main workspace with the variables listed

Step 11 — Open Transform → Recode into Same Variables. The Transform menu at the top of the app holds every data-manipulation command. Recode into Same Variables rewrites values in place — useful for reverse-coding. Recode into Different Variables creates a new column with the recoded values — safer when you want to keep the original.

Transform menu with Recode into Same Variables highlighted

Step 12 — The Recode dialog opens. Select the variables you want to reverse-code (Cmd/Ctrl-click for multiple, or Shift-click for a range).

The Recode dialog with variables to recode listed

Step 13 — Tick Reverse code — or write the rules manually. Two ways to reverse-code:

The Recode rules box with the Reverse code checkbox

Step 14 — Click OK. The recode is applied in place. Back in Data View you can spot-check that the values flipped correctly.

Recode applied — values flipped in place

Step 15 — Recompute any composite scores. If you already built mean/sum composites from the raw items via Transform → Compute Variable, they are now stale. Delete the old composites and recompute them so the reverse-coded values propagate. This is the single most common data-prep bug — the reverse-code runs but downstream composites still reflect the un-reversed values.

Data view after the recode

The order that matters

For any dataset arriving fresh from a survey platform, the safest sequence is:

  1. Import the data.
  2. Fix variable types in Variable View (bulk-change if possible).
  3. Reverse-code any negatively-worded items via Recode into Same Variables + the Reverse code checkbox.
  4. Compute composite scores with Transform → Compute Variable.
  5. Only then run analyses on the composites.

Skip a step and every downstream result inherits the mistake.

Get one guide like this a week

Plus the free PLS-SEM Reporting Checklist as a welcome gift. Unsubscribe anytime.

One email at a time. Unsubscribe in one click. No spam, ever.

← All posts