Data Management and Analysis Using JMP

Data Management

Joining Two JMP Data Tables

To combine the two data tables into a single data table, begin by opening both SmokingHealthcareExpenditures.jmp and SmokingDeterranceAndDemographics.jmp. The State columns in each data table must be the same list of values for the join to execute properly. In our case, both State columns contain the full name of each State (e.g., Alabama, New York, etc.) and therefore will join correctly. There are two components of a join: how many rows are retained and how the records are matched. In this instance we are choosing an inner join as it returns all rows where there is a match and also an equijoin, as the operator that is used to match the rows is equality. The two data tables will be joined by matching ...