SAS Users

The new Data Pane in SAS Visual Analytics – It’s painless!

In this blog post, I’ll take a look at the data pane, how it displays data from your active data source, and a few tasks that you might want to perform, such as viewing measure details, changing data item properties, and creating geographic data items, hierarchies, and custom categories. In a future blog, I’ll look at creating filters, new calculated data items, and calculated aggregations.

In the SAS Visual Analytics interface, you can display the Data pane by clicking the Data icon on the left menu.

SAS Tutorials and Materials, SAS Visual Analytics

Measure details

SAS Tutorials and Materials, SAS Visual Analytics

You can view data item properties and make these changes:

  • The name of a data item.
  • The Classification of Measure or Category data item.
  • The format of a Measure or Date/Time/Datetime data item.
  • The aggregation of a Measure data item.
  • Note: User-defined formats for Category data items are honored, but cannot be changed. The user-defined format must be available to the CAS server where the data is loaded.

SAS Tutorials and Materials, SAS Visual Analytics

A Measure classification can be changed to Category or Geography. A Category classification can be changed to Geography. Date and Tim classifications cannot be changed.

SAS Tutorials and Materials, SAS Visual Analytics

You can modify the aggregation for a Measure data item:

SAS Tutorials and Materials, SAS Visual Analytics

You can modify measure formats:

SAS Tutorials and Materials, SAS Visual Analytics

  • You can expand to display available Duration and Currency formats.
  • Over thirty different Currency formats are available for local or international currency. (Example: $56,790 or USD56,789)

SAS Tutorials and Materials, SAS Visual Analytics

Geography data items identity a geographic region or location, and are typically used to visualize data on a geographic map.

  • You can create geography data items by using predefined geography classifications such as countries or states.
  • You can create a custom geographic classification by providing latitude and longitude coordinates in your data source.
  • For predefined classifications, the values of your category data items must match the lookup values documented here.

SAS Tutorials and Materials, SAS Visual Analytics

Designating a Geography data item:

SAS Tutorials and Materials, SAS Visual Analytics

Designating a custom Geography data item:

SAS Tutorials and Materials, SAS Visual Analytics

A hierarchy enables you to add drill-down functionality to a report.

  • A hierarchy can display information from general to specific.
  • You can create category, date/datetime, or geography hierarchies.
  • Not all report objects support all types of hierarchies.

SAS Tutorials and Materials, SAS Visual Analytics SAS Tutorials and Materials, SAS Visual Analytics

  • A custom category is a category data item which associates a set of alphanumeric values with intervals, ranges, or specific values of a data item.
  • A custom category can be based on a category or a measure data item.
  • A custom category can provide functionality in a report similar to that of a user-defined format—without having to have a format previously associated with the data item.

Example:
1-20 = ‘First group’
21-30 = ‘Second group’
31-40 = ‘Third group’

SAS Tutorials and Materials, SAS Visual Analytics SAS Tutorials and Materials, SAS Visual Analytics SAS Tutorials and Materials, SAS Visual Analytics SAS Tutorials and Materials, SAS Visual Analytics

Depending on the report object, some roles require only one value; other roles may require multiple values.

You can right-click on a data item in the Roles pane to remove the data item from a role.

SAS Tutorials and Materials, SAS Visual Analytics

Duplicating a data item can enable you to display data in two different ways.

Duplicating the Date data item with 939 different values can enable you to create a report that analyzes production on each day of the week: Monday, Tuesday, Wednesday,…

Duplicating a measure data item can enable you to use the column as a category data item in reports as well.

SAS Tutorials and Materials, SAS Visual Analytics

Note: You can only delete data items that you have created, such duplicated data items or calculated data items. Deleting a data item means that it no longer appears in the data pane.

This covers many of the basic tasks that you can complete in the new data pane. In my next blog, I’ll take a look at the visual and text editors for creating filter expressions and calculated items and aggregations in the data pane.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s