Create a Table

To create a table, do the following:

Select the Dictionary [Dicts] tab to make the dictionary file structure visible.

Expand the tree until the item(s) you wish to use for row or column variable(s) appears on the tree.

Drag the desired dictionary item and drop it in the table window. Where you drop it on the table will determine whether it is used as a row or column variable. For a row item drop it on the left side below the generated "Table nn". For a column drop it on the top but a little below the generated "Table nn". If you imagine a diagonal line connecting the top-left corner of the table window to the bottom-right corner, dictionary items dropped below and to the left of the line will become row variables and items dropped above and to the right of the line will become row variables.

This can be repeated with additional items. The key to placement for additional items is whether they are dropped next to or on top of existing items. This is indicated by the "+" or "x" displayed with the item while it is being dragged.

Dragging an Item to Add in the Columns

An item dropped next to an existing item is indicated by the "+" while dragging.

Result of Adding an Item in the Columns

The dropped item will be appended to the existing item, e.g., Total, Male, Female followed by Total, Literate, Illiterate.

Dragging an Item to Cross in the Columns

An item dropped on top of an existing item is indicated by the "x" while dragging.

Result of Crossing an Item in the Columns

The dropped item will be crossed with the existing item to make sub-groupings, e.g., Total, Literate, Illiterate under Total, Male and Female.

To delete a row/column variable, left-click on one of its value names, then drag and drop it back on the dictionary tree. In the 'x' example above, if "Sex" is deleted, then "Literacy" will also be deleted. However, "Literacy" can be deleted without affecting "Sex".

The rows/columns that are created when you add an item to a table come directly from the value set defined in the dictionary for that item. If you would like to have different rows/columns created for a particular item, you can either modify the value set in the dictionary or create an additional value set for the item and use the new value set instead. To use a different value set, rather than dragging the item itself onto the table, drag the value set instead. For items with more than one value set, the value sets appear underneath the item in the dictionary tree. For more information see Implications of Data Dictionary Value Sets.

Optional Definitions

• Define the universe for the table.

• Define the area for the table.

• Select the value Item or constant you want to tabulate.

• Select the weight Item or constant

• Add percentages.

When two variables are selected for the same dimension (row or column), the first one selected becomes the independent variable and the second one becomes the dependent variable. (See the discussion on row/column variables for more details.)