How to Extract Data from a Single Column Summary Table

Introduction

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 Insert a Calculation  > Custom Code.

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

3. While the cursor is blinking (active) in the R CODE box at the top of the screen, click on a part of a table that you'd like to extract.

4. Click on Calculate in the Object Inspector.

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.

3. Select Insert a Calculation > Custom Code.

4. In the code editor 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 in the Object Inspector.

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

 

Method 3 - By index

1. Select your table.

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

3. Select Insert a Calculation > Custom Code.

4. Go to Data > R CODE in the object inspector.

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 in the Object Inspector.

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

 

See also

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