Data Preparation for Analytics Using SAS

Chapter 11

Considerations for Data Marts

 

11.1 Introduction

11.2 Types and Roles of Variables in a Data Mart

11.3 Derived Variables

11.4 Variable Criteria

 

11.1  Introduction

In Chapters 6–10 we discussed possible data models and data structures for our data mart. Before we move to the creation of derived variables and coding examples we will examine definitions and properties of variables in a data mart. We will look at attribute scales, variable types, and variable roles. And we will see different ways that derived variables can be created.

11.2  Types and Roles of Variables in a Data Mart

Variables are usually represented by the columns of a table and are the basis for analysis. In this section we will define variables in order to reference ...