1 / 17

Microcomputer Processing of Census and Surveys (using CSPro)

Microcomputer Processing of Census and Surveys (using CSPro). U.S. Census Bureau International Programs Center www.census.gov/ipc/www. Data File Design. How are data stored in the data file? What is a case? What is on a record? How many records?. Objectives:.

fritzi
Download Presentation

Microcomputer Processing of Census and Surveys (using CSPro)

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. Microcomputer Processing of Census and Surveys(using CSPro) U.S. Census Bureau International Programs Center www.census.gov/ipc/www

  2. Data File Design • How are data stored in the data file? • What is a case? • What is on a record? • How many records?

  3. Objectives: • Understand elements of a data file • Describe a field, record, and questionnaire • Describe data file structures • Learn how the CSPro data dictionary defines these elements

  4. Needed information about data file • Need identification fields • Need information / data fields • Need “SIZE” [how many characters] • Need valid values/codes

  5. Data File StructureASCII/text • ALL data on ONE record/line • Different types of data on DIFFERENT record/lines

  6. Data Processing/Data File Terminology • Item/variable/field • Record • Questionnaire (Case) • Data file

  7. Item/variable/field • Is a single piece of information • Has the attributes of: Size Type Numeric/Alphanumeric

  8. Record • a collection of related items forming a single line of information. For example: • Housing Recordcontains information about the house • Population Record Contains information about each person in the house

  9. Case/Questionnaire • all the records of all types for a processing unit such as a household

  10. A data file is • a collection of all the questionnaires (cases)

  11. CSPro Data Dictionary • Field names/labels • Field size • Field location • Field attributes • Record names • Record types • Records ID’s • Records allowed by type

  12. Questionnaire sections

  13. One Section ==> One record

  14. From the questionnaire to the data file (one record type)

  15. From the questionnaire to the data file (What are the data?)

  16. From the questionnaire to the data file (Where are the data?)

  17. Data Dictionary describes the data file

More Related