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.
Stack Table into 1 Variate
When converting a sheet that is a two or more way table or a Tabbed Table
to a vector sheet, this option appears. If it is selected, then all the data values in the table (after removing
margins) and put into a single variate column, and then factors indexing the tables values
are created with unique names based on the original classifying factors. The variate name is
also a unique name based on the table name. If the sheet is part of a tabbed book, then
all the data from the sheets is put into the vector sheet. This uses the VTABLE
directive to create the new columns and the FSPREADSHEET directive
to display the new vector sheet. If this is selected the next option appears.
Close Sheet on Conversion
If this option is selected, when the stack table option above is selected, then the old table
spreadsheet used to create the new vector spreadsheet will be closed.
See Also
Convert Column
Convert Multiple Columns
Spreadsheet Column Menu
Create Tabbed Table
VTABLE directive
FSPREADSHEET directive
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