Help information for presentation formats and other functions

Presentation form	File type	Icon on table page	Software
Show table on screen	-	-	Presents selected material in a table on screen
PC-Axis file	.px		PC-Axis
Excel file	.xls		Excel
Table as text file	.txt		Word processor
Relational table as text file	.scb		Relational table that can be used in a local database system. See description below

Delimited file	.prn	Spreadsheet software, see description below
dBase file	.dbf	dBase and other systems using dBase files
Show table with alternative layout	-	Toggle between alternative table layouts. If the option to remove zero lines is used the result will be shown in table layout 1
Show graph	.px	Show the selected table as a graph. As default a bar chart is shown. On the graph page you can select another type under Settings. Read more
Show map	.px	The map software in SSD. Map can only be made if the geographic variable is the first variable in the table

text Text file, txt, can be customised as shown below:

Save file. Select line length, page length och margin. Press the button
Line length: Page length: Margin:	(One line on an A4 page contains approximately 80 characters) (One A4 page contains approximately 70 lines)
If the indicated line length is too small to contain the stub and one column, the file will be created without page break. The table is limited to max 30 columns and 500 rows.

prn Delimited file, prn, can be customised as shown below:

Save file. Select file type and delimiter. Press the button

If you select the file format option PRN with heading or without heading, the table will be converted with and without table heading accordingly. All textual fields are quoted and delimited from next field using optional delimiters as tabulation sign, comma, blank or a semicolon. The table cells are not quoted, but are delimited using the selected delimiter option.

text Relational table as text file:

The file with the relational table contains column headings but not a table title. It is tabulator delimited.

dbf dBase file can be customised as shown below:

Save file. Select file format and press the button

If the file is to be used in a map program it is best to select table layout and place the geographic variable first in the table

Other functions:

Pivot clockwise		Option to turn the table around clockwise
Pivot anti-clockwise		Option to turn the table around anti-clockwise
Pivot manually		Manual pivot option
Remove zero rows		Suppress lines containing only zeros. This is possible for tables that contain maximum 3 variables in the stub. If the table has more than one variable in stub the first level might be shown after removal of lines with zeros. For best result change the table so that it only contains one variable in stub. The result is shown in table layout 1.
Sum variable		Summing all values for a selected variable
Print		Print the table.
Sort		Sort the table columns by the values in the table cells in selected column, or in alphabetical order in text columns.
Help		Help information on this page

pivot Manual pivot option can be customised as shown below:

Change layout:

Select row or column for each variable and order number within row/column. Then press the button

Summing variables can be customised as shown below:

Sum variable. Select one variable and press the button

New Value Name:

Top of page
Last updated:2009-01-30