This dialog can be used to convert either the entire spreadsheet of a vector spreadsheet to
other types.
Sheet Type
Converts the spreadsheet from one type to another. The following restrictions apply
to spreadsheet conversion:
A Vector spreadsheet containing text columns cannot be converted to any
other type.
Converting a spreadsheet to type scalar will preserve Row 1 and discard
all other rows.
Spreadsheets can only be converted to diagonal or symmetric matrix type
if they are square, i.e. have equal numbers of rows and columns.
Converting a spreadsheet to type vector will produce columns of type
variate. These can subsequently be converted to other types using the Column Attributes/Format menu.
Matrix or Table Name
You can change the name of matrices or tables by typing the new name into this
box.
Column Factor Name
You can change the name of the factor indexing the columns in a two way table
by editing its name here.
Table Type
When converting to a table, you can specify whether the new sheet is:
1 Classifying Factor - a multiple ones way tables (1 per column)
2 Classifying Factors - a single two way table with a factor indexing the columns.
In the command language, a variate or factor can be converted to a text with the
PRINT directive:
PRINT [C=TXT;IPRINT=*;SQUASH=yes] VAR
A variate or text can be converted to a factor with the GROUPS directive:
GROUPS VAR; FACTOR=FACT
GROUPS [Modify=yes] VAR "if the same structure is to be changed"
A text can be converted to a variate with a READ directive:
READ [C=TXT] VAR
In the command language, a 1 way table to variate with the
TPROJECT calculate function:
CALC VAR = TPROJECT(Table)
In the command language, a 2 way table to matrix with the
TMATRIX calculate function:
CALC MAT = TMATRIX(Table;RowFactor;ColFactor)
The EQUATE directive can
also be used to move data from one structure to another:
VARIATE [10] V[1...10]
EQUATE OLDS=Matrix; NEWS=V
MATRIX [10;4] Matrix2
EQUATE OLDS=!p(A,B,C,D); NEWS=Matrix2