Transcript SEEING THE FOREST THROUGH THE TREES: A GRAPHICAL VIEW FOR EDITING THROUGH E-SPHERE WP 26 Work Session on Statistical Data Editing (Bonn, Germany, 25-27 September 2006) Topic.

SEEING THE FOREST
THROUGH THE TREES:
A GRAPHICAL VIEW FOR
EDITING THROUGH E-SPHERE
WP 26
Work Session on Statistical Data Editing
(Bonn, Germany, 25-27 September 2006)
Topic (v): New and Emerging Methods
Submitted by the U.S. Energy Information Administration
Overview
The problem with the editing process
 The solution being developed graphically
►”The forest”: macro view
►”The trees”: micro view
 Summary and description of work
remaining

The Problem

Two years ago implemented StEPS
► rule-based edits
► no prioritization of edit failures
► limited edit failure presentation context
■ Survey forms changes, more detailed data
► no historical data for new product edits
Review Failures in StEPS
List Failures in StEPS
Edit Review Summary in StEPS
Review and Correction in StEPS
The Solution
■ Graphical approach using SAS Insight
► user interface thru menus
► interactively creates the data sets
► displays graphs
The Forest

Bottom down—interactive instruction
booklet
►maps final data product to a reported
item
►provides catalog of available data
►resides outside of StEPS
Instruction Booklet
Part 2: Table to Survey Relationships
Surveys Comprising Table 53
Aggregates for Table 53
Within Survey Menu
The Trees: Scatter Plot Menu
The Trees: June 2004 vs June 2005
Summary




User interfaces to SAS Insight to view the data
reported easily
Context to prioritize edit failures, as well as
identify data not flagged by the edits.
Higher-level mappings from publication tables to
individual surveys provide a higher-level context
Two access points to edit: top down or bottom
up.
Work Remaining



Complete Development and train
Implement
Improve overall edit process