1 / 20

SEEING THE FOREST THROUGH THE TREES: A GRAPHICAL VIEW FOR EDITING THROUGH E-SPHERE

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.

coulombe
Download Presentation

SEEING THE FOREST THROUGH THE TREES: A GRAPHICAL VIEW FOR EDITING THROUGH E-SPHERE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SEEINGTHE 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

  2. 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

  3. 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

  4. Review Failures in StEPS

  5. List Failures in StEPS

  6. Edit Review Summary in StEPS

  7. Review and Correction in StEPS

  8. The Solution ■ Graphical approach using SAS Insight► user interface thru menus ► interactively creates the data sets ► displays graphs

  9. The Forest • Bottom down—interactive instruction booklet ►maps final data product to a reported item►provides catalog of available data►resides outside of StEPS

  10. Instruction Booklet

  11. Part 2: Table to Survey Relationships

  12. Surveys Comprising Table 53

  13. Aggregates for Table 53

  14. Within Survey Menu

  15. The Trees: Scatter Plot Menu

  16. The Trees: June 2004 vs June 2005

  17. 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.

  18. Work Remaining • Complete Development and train • Implement • Improve overall edit process

More Related