1 / 9

SAS Enterprise Guide project for editing and imputation

This work session discusses the development and outline of a SAS Enterprise Guide project for statistical data editing and imputation, with a focus on international collaboration and processing tools. The project includes the implementation of selective editing methods and editing tools. Contact: saara.oinonen@stat.fi.

seths
Download Presentation

SAS Enterprise Guide project for editing and imputation

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. SAS Enterprise Guide project for editing and imputation Work Session on Statistical Data Editing: International collaboration and processing tools Paris, France, 28-30 April 2014 Saara Oinonen, Statistics Finland

  2. Contents • Background: Editing projects and guidelines for editing • Development of SAS Enterprise Guide project for editing and imputation • Outline of SAS Enterprise Guide project for editing and imputation • Future development UNECE April 2014 France, Saara Oinonen

  3. Background • StatFi has focused on developing editing methods for past five years and in future • Project 1 surveyed editing practices at StatFi and researched international development (2009-2011) → Process model for editing and imputation • Project 2 implements process model, selective editing methods and editing tools for four pilot statistics (2012-2014)→ SAS EG project for editing and imputation • Project 3 will implement SAS EG guide for editing and imputation for all statistics suitable for selective editing methods (2014-2015) • Two software were chosen for implementing: • SELEKT from Statistics Sweden for selective editing • BANFF from Statistics Canada for e.g. error localization and imputation UNECE April 2014 France, Saara Oinonen

  4. Development of SAS EG project for editing and imputation • Basis for implementing selective editing methods was the process model for editing and imputation • All editing features in one program • Piloting statistics had suggestions for editing tool • Easy to use, no programming • Priorisaton of units subjected for manual editing • Flexibility on parameter selection etc. • SELEKT and BANFF were incorporated in one SAS EG project • Additional macro programs and parametrisation provide continuous generic program for editing and imputation… UNECE April 2014 France, Saara Oinonen

  5. Linked programs Run whole project Information notes Run one Process flow Run one program Datasets created by a program Run parts of one program UNECE April 2014 France, Saara Oinonen

  6. SAS EG project for editing and imputation UIR = User input reguired→ parameter definitions • Macro programs: • DEF: parameter definitions • PRE: data preparations • MAC: macros for e.g. indicator calculation • BAN: BANFF • SEL: SELEKT Process Flow includes info notes and macro programs UNECE April 2014 France, Saara Oinonen

  7. SAS EG Project for editing and imputation • Parsed programs and codes for different purposes → editing process becomes easier to understand • Different types of macro programs: • Defining (DEF): parameter definitions, UIR • Preparing (PRE): Data alterations, no UIR • Executive (MAC, BAN, SEL): Produces results or priorisation of units, no UIR • Linked programs and hierarchical levels • Executive programs can be run independently and they can be omitted → suitable for all statistics which need editing • Blocks or modules can be separated for lighter operations UNECE April 2014 France, Saara Oinonen

  8. Results from SAS EG project SELEKT UNECE April 2014 France, Saara Oinonen

  9. Development proceeds • Imputations methods, further parametrisation • Manuals, study material, demo • Concept library and methodology bank: Database of terms and method wiki available for everyone • User interface Thank you for your attention! Contact: saara.oinonen@stat.fi UNECE April 2014 France, Saara Oinonen

More Related