StaCrossTab.SortOutputVariables
Sort the variables in the output by the values of the crosstab column.
SVB Example
Unstacking a dataset:
Option Explicit Option Base 1 Sub Main Dim S1 As Spreadsheet Set S1 = Spreadsheets.Open(Path & "\Examples\Datasets\Cat Clinic Patient Info.sta") S1.Visible = True Dim obj2 As New StaCrossTab obj2.SkipMissing = True obj2.PreCreateVariables = True obj2.PreserveRelativeVariableOrder = True obj2.SortOutputVariables = True Dim S2 As Spreadsheet 'Unstack (split) the GENDER variable, so that its codes 'are now separate variables. Set S2 = obj2.Tabulate(S1, "1", "2", "3", scXTabAggSeparateVariables, scXTabMIDFirst, False, False, "", "", "", "", "", "", 4000) S2.Visible = True End Sub
Copyright © 2020. Cloud Software Group, Inc. All Rights Reserved.