Chapter 19

Multiple Categorical Observations per Subject

 

19.1 Introduction

19.2 Absolute and Relative Frequencies of Categories

19.3 Concatenating Absolute and Relative Frequencies

19.4 Calculating Total and Distinct Counts of the Categories

19.5 Using ODS to Create Different Percent Variables

19.6 Business Interpretation of Percentage Variables

19.7 Other Methods

 

19.1  Introduction

General

In this chapter we will deal with the case where we have a one-to-many relationship between a subject table and either a table with repeated measurements or a table that holds data from an underlying hierarchy. We will investigate methods of preparing the data for a one-row-per-subject table.

With interval data for certain types of analysis, it can ...

Get Data Preparation for Analytics Using SAS now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.