Setup|Express Tables from Variable Data

In Setup|Express Tables from Variable Data, you can create tables from variables in your variable type data file or edit existing tables in your job file. Upon initial entry into the Express Tables from Variable Data dialog box, WinCross displays the number of variables and number of cases in the open data file and the number of tables in the open job file.

Find a variable

Find Next

Find a table

Find Next

Scan data when creating tables

Note: If you limit the number of cases scanned when creating tables, if the Compute and display the frequency report automatically option is selected and Scan all cases is enabled, all cases may still be scanned. It is best to deselect the Compute and display the frequency report automatically option if you want to limit the number of cases being scanned.

 

Use glossary transformations

Selecting variables

Note: Table options for tables created using the Create n Table(s), Create One Table with n Rows or Create One Table Using Net Logic options are assigned from the Preferences section of your job file. Table options for tables created using the Summary of Means or Summary of Frequencies options, use a default set of the most commonly used table options for these types of tables.

 

Creating tables with the "Scan data when creating tables" option selected

Note: If the variables selected have different Code Values, you will receive a message "The variables that were selected for netting are not identical to one another in their structure. Do you still want to create a net table?". This message is informational only and does not prevent you from creating the net table.

Q.2 Agreement with the following statement: I consider myself an outdoors person^

Q2_1 (1-4)^HR

Q.2 Agreement with the following statement: I wish the parks were open for longer hours^  

Q2_2 (1-4)^HR

Q.2 Agreement with the following statement: I wish all of the local parks in Arizona had after school programs for kids^

Q2_3 (1-4)^HR

Q.2 Agreement with the following statement: I trust that the Arizona Parks and Recreation staff are well-trained^

Q2_4 (1-4)^HR

Q.2 Agreement with the following statement: I consider myself an outdoors person^

Q2_1 (1,2)^1

Q.2 Agreement with the following statement: I wish the parks were open for longer hours^

Q2_2 (1,2)^2

Q.2 Agreement with the following statement: I wish all of the local parks in Arizona had after school programs for kids^

Q2_3 (1,2)^3

Q.2 Agreement with the following statement: I trust that the Arizona Parks and Recreation staff are well-trained^

Q2_4 (1,2)^4

 

The first set of rows is created with the Hide row option specified. The second set of rows is created with the percentaging row specified. The percentaging row is a numeric value that represents the sequence number of the row being used for percentaging. For example, the row logic ^Q2_1 (1,2)^1 is using row 1 of this table as the percentaging base for this row. Variables can be non-contiguous by selecting the Ctrl key when selecting variables from the list. This option is especially useful for top and bottom box summary tables.

 

Note: Enable the Show job file definition view check box to display the Job file definition window.

Creating tables with the "Scan data when creating tables" option NOT selected

Note: When the variables selected have different Code Values, you will receive a message "The variables that were selected for netting are not identical to one another in their structure. Do you still want to create a net table?". This message is informational only and does not prevent you from creating the net table.

Q.2 Agreement with the following statement: I consider myself an outdoors person^

Q2_1 (1-4)^HR

Q.2 Agreement with the following statement: I wish the parks were open for longer hours^  

Q2_2 (1-4)^HR

Q.2 Agreement with the following statement: I wish all of the local parks in Arizona had after school programs for kids^

Q2_3 (1-4)^HR

Q.2 Agreement with the following statement: I trust that the Arizona Parks and Recreation staff are well-trained^

Q2_4 (1-4)^HR

Q.2 Agreement with the following statement: I consider myself an outdoors person^

Q2_1 (1,2)^1

Q.2 Agreement with the following statement: I wish the parks were open for longer hours^

Q2_2 (1,2)^2

Q.2 Agreement with the following statement: I wish all of the local parks in Arizona had after school programs for kids^

Q2_3 (1,2)^3

Q.2 Agreement with the following statement: I trust that the Arizona Parks and Recreation staff are well-trained^

Q2_4 (1,2)^4

 

The first set of rows is created with the Hide row option specified. The second set of rows is created with the percentaging row specified. The percentaging row is a numeric value that represents the sequence number of the row being used for percentaging. For example, the row logic ^Q2_1 (1,2)^1 is using row 1 of this table as the percentaging base for this row. Variables can be non-contiguous by selecting the Ctrl key when selecting variables from the list. This option is especially useful for top and bottom box summary tables.

 

Note: Enable the Show job file definition view check box to display the Job file definition window.

Tables

Note: Changes saved using the Save Changes option are permanently saved to your job file, so use this option with care.

Related topics:

Setup Menu

Setup Tables

Add Frequency Row