How to Extract Data from a Single Column Summary Table

This article describes how to go from a single-column table...

...to returning only the cells you need.

Requirements

A single-column summary table.

Method 1 - Point and click

1. Click on the Calculation > Custom Code from the toolbar.

2. Click on the page to insert a calculation box.

3. While the cursor is blinking (active) in the Code panel, click on a part of a table that you'd like to extract.

4. Click on Calculate.

See Bespoke Analyses for examples and a demo of the feature.

Method 2 - By name

1. Select your table.

2. Copy the table name from General > General > Name in Properties .

3. Select Calculation > Custom Code from the toolbar.

4. In the code panel, add a line in the format of table_name[row_name]

Using our example, the code to return values from just the second row is: table.age["25 to 29"]

To instead return values from the first three rows, the code is: table.age[c("18 to 24","25 to 29","30 to 34")]

5. Click on Calculate.

6. OPTIONAL: Adjust the number of decimal places via Properties > Appearance > Appearance > Number format.

Method 3 - By index

1. Select your table.

2. Copy the table name from Properties > General > General > Name.

3. Select Calculation > Custom Code from the toolbar.

4. Go to Code panel.

5. Add a line in the format of table_name[index_number]

Using our example, the code to return the value from the second row is: table.age[2]

To instead return values from the first three rows, the code is: table.age[c(1,2,3)]

Alternatively, you can use index ranges. The code to return the first three values is: table.age[1:3]

You can even reverse this and remove the other rows instead:table.age[c(-4:-10)]

You can additionally remove the last row by using the NROW argument:

table.age[-NROW(table.age)]

6. Click on Calculate.

7. OPTIONAL: Adjust the number of decimal places via Properties > Appearance > Appearance > Number format.

Next

How to Extract Data from a Multiple Column Table

How to Extract Data from a Multiple Column Table with Multiple Statistics

How to Extract Data from a Multiple Column Table with Nested Data