## Introduction

This article describes how to go from multiple tables with more than one statistic...

...to a single combined table:

## Requirements

A set of tables with *either*:

- The same row dimensions and the same number of comparable statistics when appending columns to a table.
- The same column dimensions and the same number of comparable statistics when appending rows to a table.

## Method

1. Select the first table and copy the name from **Properties > GENERAL > Name**.

2. Repeat step 1 for the second table. These names will be used in the code below.

3. Right click in the **Report** tree and select **Add R Output**.

4. In the **object inspector**, go to **Properties > R CODE**.

5. In the code field, add a line to load the *abind* R package:

`library(abind)`

6. Add a line that calls the `(abind)`

function, like the below example. In this, *new_table_name *is an arbitrary name for the combined table, *table1_name *is the name of the first table name copied in step 1, above, and *table2_name *is the name of the second table from step 2. To combine tables over rows, set `along = 1`

. (For columns use, `along = 2`

and to combine matching tables with different statistics use, `along = 3`

.)

*new_table_name* = abind*(table1_name*, *table2_name*, along = 1)

7. Add a line that defines the name of each statistic (if different between the input tables) using the format below, where *Label1 *is the combined label to use for the first statistic in both tables, and *Label2 *is for the second statistic.

`dimnames(`

*new_table_name*)[[3]] = c("*label1*","*label2*")

8. Add a line that references the *new_table_name* set in step 6:

`new_table_name`

The complete code to generate the example above is:

#call library of functions needed

library(abind)

#combine tables

new.table = abind(table.preferences, table.satisfaction, along = 1)

#name statistics

dimnames(new.table)[[3]] = c("Score","Sample Size")

#call final table

new.table

## See Also

How to Relabel Rows and Columns of Tables using R in Q

How to Perform Mathematical Calculations Using R

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

## Comments

0 comments

Article is closed for comments.