1

Chris Jiang

Royal Bank of Canada

The Data Explorer in SAS EG 5.1

2

In the new Data Explorer, we can

•Obtain basic statistics and charts quickly for all columns in a data set.

•Create different views of our data by choosing select columns, creating filters, etc.

•Add a data exploration view to a project.

Background

3

Quick Stats

Data view list

Tools

4

Tools

5

Quick Stats

Quick Stats

6

Quick Stats

7

Quick StatsScatter Plot Matrix

8

Quick Stats-Select StatisticsFor each type of variable, we are able to select stats that we are interested

in. For example, the percentiles and standard deviation of Currency.

9

We can filter the dataset to get different views. We’d like to see

Sport Shoe in Western Europe.

Filter Datasets

10

Filter Datasets

11

Statistics of a filtered dataset

.

12

Thank you!