Preparing the Data File

  1. To restructure the data from variables to cases, from the menus choose:

    Data > Restructure...

  2. You want to restructure variables into cases, so simply click Next in the Restructure Data Wizard Welcome dialog box.
    Figure 1. Number of variable groups dialog box
    Number of variable groups dialog box
  3. Since both weights and triglyceride levels are measured, select More than one in step 2 of the Restructure Data Wizard.
  4. Click Next.
    Figure 2. Number of Variable Groups dialog box
    Number of Variable Groups dialog box
  5. In the Case Group Identification group, select Use selected variable from the dropdown list and select Patient ID as the identification variable.
  6. In the Variables to Be Transposed group, type trigly as the first target variable and select Triglyceride through Final triglyceride as the variables to be transposed.
  7. In the Variables to Be Transposed group, select trans2 from the dropdown list, type weight as the second target variable and select Weight through Final weight as the variables to be transposed.
  8. Select Age in years and Gender as fixed variables.
  9. Click Next.
  10. You want to create just one index variable, so simply click Next in the Variables to Cases: Create Index Variables.
    Figure 3. Create One Index Variable dialog box
    Create One Index Variable dialog box
  11. In the edit fields, in step 5 of the wizard, type time as the variable name and Measurements as the variable label.
  12. Click Finish.

Next