For this Assignment, you will put into practice all the concepts you explored in previous weeks, and those developed this week, to create a data analysis plan that will act as the foundation of your final Scholar-Practitioner Project.To prepare:Review this week’s Learning ResourcesSubmit your data analysis plan. Your data analysis plan should include the following supporting documents (this is very similar to statistical analysis section of your doctoral study):Your final research question(s)List of variables used to answer each research question(s) including:Variable names and descriptionsTypes of variables: independent/dependent, covariate, confounding.Levels of measurement for each variable.Your Statistical analysis plan, including:Descriptive methods you will be using to describe data.Analytic methods you will be using to answer your research question(s), including:Statistical test you will be using.Why this test is appropriate to answer your research question?Why this test is appropriate for using the list of variables you selected for your research question?How the results of this statistical test help you to answer your research question?What methods you will be using to present your findings?

User Guide
to the 2006 Natality
Public Use File
2006 Natality Detail Data Set
Contents
1. Introduction.
2. Control count of records.
3. List of data elements and locations
.
4. Record layout and definition of items and codes.
5. List of Country Codes
6. Detailed Technical Notes to the United States 2006 data – Natality
(formerly “Technical Appendix to the Vital Statistics of the
United States – Natality”).
7. Births: Final Data for 2006.
8. Control tables for items not shown in “Births: Final Data for 2006”
Introduction:
User Guide to the 2006 Natality Public Use File
Introduction
United States birth data available in this file represent all births registered in the
50 States, the District of Columbia, and New York City. The Centers for Disease Control
and Prevention’s National Center for Health Statistics (NCHS) receives these data as
electronic files, prepared from individual records processed by each registration area,
through the Vital Statistics Cooperative Program.
Birth data for the U.S. are limited to births occurring within the United States to
U.S. residents and nonresidents. Births to nonresidents of the Unites States are excluded
from all tabulations by place of residence. Births occurring to U.S. citizens outside of the
United States are not included in this file. For more detailed information on the 2006
Natality file see the Detailed Technical Notes – natality: United States, 2006.
Availability of Geographic Detail
Beginning with the 2005 data year, the U.S. micro-data natality file no longer
includes geographic detail (e.g., mother’s state of residence). Tabulations of birth data by
residence of mother for states and for counties with populations of 100,000 or more are
available using the VitalStats online data access tool described below. Certain
geographic level data may also be available upon request: See “NCHS Data Release and
Access Policy for Microdata and Compressed Vital Statistics Files, 2007,” available at:
http://www.cdc.gov/nchs/about/major/dvs/NCHS_DataRelease.htm.
The possessions file, which includes data on births occurring in Puerto Rico, the
U.S. Virgin Islands, Guam, American Samoa, and the Commonwealth of the Northern
Marianas Islands, includes limited geographic detail. Information identifying individual
possessions and counties (or their equivalent) with populations of 100,000 or more by
place of occurrence and residence are available in this file.
VitalStats
VitalStats is an online data access tool which provides access to a collection of
interactive pre-built tables, and the ability to build tables from over 100 public use birth
variables. Interactive charting and mapping tools are a key part of the system, and
provide powerful options for visualizing and manipulating tabulated data. Tabulated data
can be exported to Excel for further analysis. VitalStats is available at:
http://www.cdc.gov/nchs/VitalStats.htm.
The 1989 and 2003 Revisions of the U.S. Certificate of Live Birth
This data file includes data based on both the 1989 Revision of the U.S. Standard
Certificate of Live Birth (unrevised) and the 2003 revision of the U.S. Standard
Certificate of Live Birth in 2003 (revised). The 2003 revision is described in detail
elsewhere. (See the 2003 Revision website at:
http://www.cdc.gov/nchs/vital_certs_rev.htm). Nineteen states, California (selected
items only with full implementation in 2007), Delaware, Florida, Idaho, Kansas,
Kentucky, Nebraska, New Hampshire, New York (excluding New York City), North
Dakota, Ohio, Pennsylvania, South Carolina, South Dakota, Tennessee, Texas, Vermont,
Washington, and Wyoming, and Puerto Rico implemented the revised birth certificate as
of January 1, 2006. The 19 revised states (excluding Puerto Rico) represent 49 percent of
all U.S. births. Where comparable, revised data are combined with data from the
remaining 31 states, the District of Columbia, and New York City. (Revised data are
denoted by “R;” unrevised data are denoted by “U” in the “Rev” column of the file
layout.) Where data for the 1989 and 2003 certificate revisions are not comparable (e.g.,
educational attainment of the mother), unrevised and revised data are shown in separate
fields in the data file. Also see discussion of reporting flags. Selected items new to the
2003 Revision are included in this data file; see tables R-1- R-6. A recent report
“Expanded Health Data from the New Birth Certificate, 2005” presented 2005 data for
these items; a forthcoming report will present 2006 data for these items. (1). For further
information please contact us at [email protected] or (301) 458-4111.
Incomplete National Reporting: Selecting Reporting Areas for the 2006 natality file
The use of reporting flags
As a result of the delayed, phased transition to the 2003 Standard Certificate of Live
Birth, the 2006 natality file includes data for reporting areas that use the 2003 revision of
the U.S. Standard Certificate of Live Birth (revised) and data for reporting areas that use
the 1989 Standard Certificate of Live Birth (unrevised). Although many data items are
comparable across certificate revisions and are available for the entire United States,
many items have more limited reporting areas. For example, information on prepregnancy and gestational diabetes, a revised data item, is available for 19 States for
2006; information on amniocentesis, an unrevised item not included on the revised
certificate, is available for 31 States, the District of Columbia, and New York City.
Reporting flags were developed to help the user more readily identify reporting areas for
items with less than national reporting. The national reporting area is defined as the 50
States, the District of Columbia, and New York City; (NYC is an independent reporting
area from New York State). Reporting flags are available for most items on the file.
Positions for reporting flags are noted along with each data item in the file layout.
Translating “blanks”
In the 2006 natality file, for data items which are not common or comparable across
certificate revisions, births to residents of a revised state occurring in an unrevised state,
and births to residents in an unrevised state occurring in a revised state, are represented
by “blanks.” Blanks should be treated as “unknowns” for tabulations.
In sum, the correct use of reporting flags and translation of blanks will result in an
accurate tally of births for items with incomplete national reporting. For an example of
SAS code that may be used to incorporate the correct use of reporting flags and the
translation of blanks see below.
Example of SAS code using reporting flags (and translating blanks)
The example below is for the revised prenatal care item. Prenatal care data based on the
revised certificate are not considered comparable to data based on the unrevised
certificate, and are presented separately (see also Births: Final Data for 2006).
Accordingly, use of the reporting flag for this item will produce 2006 data for the month
prenatal care began for the 19 revised States which had implemented the revised
Certificate as of January 1, 2006.
Sample SAS program
01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
DATA work;
INFILE ‘c:nat06us.dat’ LRECL=775;
INPUT
restatus 138
precare 245-246
f_mpcb 668;
/*Exclude foreign residents*/
IF restatus NE 4;
/*Select reporting area*/
IF f_mpcb=1;
/*Convert blanks to unknown*/
IF precare=. THEN precare=99;
PROC FREQ;
TABLE precare;
RUN;
In this example, “restatus” is used to exclude births to foreign residents (this is standard
practice for all NCHS tabulations). Also in this example, blanks are represented by
numeric values SAS code = (.). However, for some items in the file, e.g., obstetric
procedures, blanks are represented by character values for which the SAS code is empty
quotes (‘ ’).
References
1. Menacker F, Martin JA. Expanded health data from the new birth certificate, 2005.
National vital statistics reports; vol 56 no 13. Hyattsville, MD: National Center for
Health Statistics.
2006 Natality
Machine / File / Data Characteristics
All Files:
Record format: Blocked, Fixed Format
Code scheme: Numeric/Alphabetic/Blank
Record length: 775
Block size: 27000
Record count:
All Births:
Record count:
By occurrence:
By residence:
To foreign residents:
United States
4,273,225
4,273,225
4,273,225
4,265,555
7,670
Possessions
56,784
56,784
56,784
56,539
245
2006 LIST OF DATA ELEMENTS AND LOCATIONS
Data Items
Locations
1. General
a) Data year
b) Resident status
15-18
138
2. Prenatal Care
a) Month began
b) Number of visits
256-257
270-271
3. Child
a) Sex
b) Number at delivery
c) Birthweight
d) Apgar score
e) Gestation
f) Month/year of birth
g) Day of week of birth
437
423
463-466
415-416
451-457
15-20
29
4. Mother
a) Age
b) Race
c) Marital status
d) Education
e) Hispanic Origin
89-93
139-144
153
155-158
148-149
5. Pregnancy History
a) Born alive, now living
b) Born alive, now dead
c) Other terminations
d) Total birth order
e) Live birth order
204-205
206-207
208-209
217
212
6. Father
a) Age
b) Race
c) Hispanic origin
184-187
188-191, 199-200
195-196
7. Other Items
a) Residence reporting flags
b) Attendant at birth
c) Place of delivery
569-773
410
42
LIST OF DATA ELEMENTS AND LOCATIONS
Data Items
8. Medical and Health Data
a) Method of delivery
b) Medical risk factors
c) Other risk factors
Tobacco
Alcohol
Weight gain during pregnancy
d) Obstetric procedures
e) Complications/characteristics of labor and/or delivery
f) Abnormal conditions of the newborn
g) Congenital anomalies
Locations
390-403
313-344
284-294
295-298
276-278
351-361
365-389
476-491
492-525
2006
Public Use –Natality File Record Layout
Position
Len
Field
Description
1-6
6
FILLER
Filler
7
1
REVISION
Revision
Reporting
Flag Position
Rev*
Values Definition
Blank
U,R
A
S
Data based on the 2003 revision of the US Standard Birth
Certificate (Revised)
Data based on the 1989 revision of the US Standard Birth
Certificate (Unrevised)
8-14
7
FILLER
Filler
15-18
4
DOB_YY
Birth Year
U,R
2006
Year of birth
19-20
2
DOB_MM
Birth Month
U,R
01
02
03
04
05
06
07
08
09
10
11
12
January
February
March
April
May
June
July
August
September
October
November
December
21-28
8
FILLER
Filler
29
1
DOB_WK
Weekday
30-31
2
OTERR
Occurrence Territory/Possession
U,R
(This item is available in the territory/possession
file only, geographic codes are not available in the
U.S. file)
Outlying Areas of the United States
*U,R
U
R
Blank
Blank
U,R
1
2
3
4
5
6
7
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
AS
GU
American Samoa
Guam
Includes data based on both the 1989 Revision of the U.S. Certificate of Live Birth (unrevised), and the 2003 Revision of
the U.S. Certificate of Live Birth (revised).
Includes data based on the 1989 Revision of the U.S. Certificate of Live Birth; excludes data based on the 2003 Revision.
Includes data based on the 2003 Revision of the U.S. Certificate of Live Birth; excludes data based on the 1989 Revision.
1
2006
Public Use –Natality File Record Layout
Position
Len
Field
Description
Reporting
Flag Position
Rev*
Values Definition
MP
PR
VI
32-36
5
FILLER
Filler
37-39
3
OCNTY
Occurrence County
U,R
(This item is available in the territory/possession
file only, geographic codes are not available in the
U.S. file)
Puerto Rico
Northern Marianas
Puerto Rico
Virgin Islands
Blank
Other Outlying Areas of the United States
021
025
031
097
113
127
999
Bayamo’n
Caguas
Carolina
Mayaguez
Ponce
San Juan
County of less than 100,000
000
999
No county level geography
County of less than 100,000
0
1
2
3
9
County of 1,000,000 or more
County of 500,000 to 1,000,000
County of 250,000 to 500,000
County of 100,000 to 250,000
County less than 100,000
40
1
OCNTYPOP
Occurrence County Pop
U,R
(This item is available in the territory/possession
file only, geographic codes are not available in the
U.S. file)
41
1
BFACIL
Birth Place
R
1
2
3
4
5
6
7
9
Blank
Hospital
Freestanding Birthing Center
Home (intended)
Home (not intended)
Home (unknown if intended)
Clinic / Doctor’s Office
Other
Unknown
Not on certificate
42
1
UBFACIL
Birth Place
U,R
1
2
Hospital
Freestanding Birthing Center
*U,R
U
R
Includes data based on both the 1989 Revision of the U.S. Certificate of Live Birth (unrevised), and the 2003 Revision of
the U.S. Certificate of Live Birth (revised).
Includes data based on the 1989 Revision of the U.S. Certificate of Live Birth; excludes data based on the 2003 Revision.
Includes data based on the 2003 Revision of the U.S. Certificate of Live Birth; excludes data based on the 1989 Revision.
2
2006
Public Use –Natality File Record Layout
Position
Len
Field
Description
Reporting
Flag Position
Rev*
Values Definition
3
4
5
9
Clinic / Doctor’s Office
Residence
Other
Unknown
43-58
16
FILLER
Filler
59
1
BFACIL3
Birth Place Recode
60-86
27
FILLER
Filler
87
1
MAGE_IMPFLG Mother’s Age Imputed

U,R
Blank
1
Age not imputed
Age imputed
88
1
MAGE_REPFLG Reported Age of Mother Flag
U,R
Blank
1
Reported age not used
Reported age used
89-90
2
MAGER
U,R
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
10-12 years
13 years
14 years
15 years
16 years
17 years
18 years
19 years
20 years
21 years
22 years
23 years
24 years
25 years
26 years
27 years
28 years
29 years
30 years
31 years
32 years
*U,R
U
R
Blank
U,R
1
2
3
In Hospital
Not in Hospital
Unknown or Not Stated
Blank
Mother’s Single Year of Age
Includes data based on both the 1989 Revision of the U.S. Certificate of Live Birth (unrevised), and the 2003 Revision of
the U.S. Certificate of Live Birth (revised).
Includes data based on the 1989 Revision of the U.S. Certificate of Live Birth; excludes data based on the 2003 Revision.
Includes data based on the 2003 Revision of the U.S. Certificate of Live Birth; excludes data based on the 1989 Revision.
3
2006
Public Use –Natality File Record Layout
Position
Len
Field
Description
Reporting
Flag Position
Rev*
Values Definition
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
33 years
34 years
35 years
36 years
37 years
38 years
39 years
40 years
41 years
42 years
43 years
44 years
45 years
46 years
47 years
48 years
49 years
50-54 years
91-92
2
MAGER14
Mother’s Age Recode 14
U,R
01
03
04
05
06
07
08
09
10
11
12
13
14
Under 15 Years
15 years
16 years
17 years
18 years
19 years
20-24 years
25-29 years
30-34 years
35-39 years
40-44 years
45-49 years
50-54 years
93
1
MAGER9
Mother’s Age Recode 9
U,R
1
2
3
4
5
6
7
Under 15 years
15-19 years
20-24 years
25-29 years
30-34 years
35-39 years
40-44 years
*U,R
U
R
Includes data based on both the 1989 Revision of the U.S. Certificate of Live Birth (unrevised), and the 2003 Revision of
the U.S. Certificate of Live Birth (revised).
Includes data based on the 1989 Revision of the U.S. Certificate of Live Birth; excludes data based on the 2003 Revision.
Includes data based on the 2003 Revision of the U.S. Certificate of Live Birth; excludes data based on the 1989 Revision.
4
2006
Public Use –Natality File Record Layout
Position
Len
94-95
2
Field
MBCNTRY
Description
Reporting
Flag Position
Rev*
Mother’s Birth Country
R**
(This item is available in the territory/possession
file only, geographic codes are not available in the
U.S. file)
Values Definition
8
9
45-49 years
50-54 years
AA-ZZ
A complete list of countries is shown in
the Geographic Code Outline, which follows
the record layout.
** Also includes unrevised territories/possessions that use new geographic coding
96-108
13
FILLER
Filler
Blank
109-110
2
MRTERR
Mother’s Residence Territory/Possession
U,R
(This item is available in the territory/possession
file only, geographic codes are not available in the
U.S. file)
Outlying Areas of the United States
Foreign
111-113
3
FILLER
Filler
114-116
3
MRCNTY
Mother’s County of Residence
U,R
(This item is available in the territory/possession
file only, geographic codes are not available in the
U.S. file)
Puerto Rico
*U,R
U
R
AS
GU
MP
PR
VI
American Samoa
Guam
Northern Marianas
Puerto Rico
Virgin Islands
CC
CU
MX
XX
ZZ
Canada
Cuba
Mexico
Not Applicable
Not Classifiable
Blank
021
025
031
097
113
127
Bayamo’n
Caguas
Carolina
Mayaguez
Ponce
San Juan
Includes data based on both the 1989 Revision of the U.S. Certificate of Live Birth (unrevised), and the 2003 Revision of
the U.S. Certificate of Live Birth (revised).
Includes data based on the 1989 Revision of the U.S. Certificate of Live Birth; excludes data based on the 2003 Revision.
Includes data based on the 2003 Revision of the U.S. Certificate of Live Birth; excludes data based on the 1989 Revision.
5
2006
Public Use –Natality File Record Layout
Position
Len
Field
Description
Reporting
Flag Position
Rev*
Other Outlying Areas of the United States
Values Definition
999
County of less than 100,000 population
or foreign resident
000
999
No county level geography
County of less than 100,000 population
or foreign resident
117-131
15
FILLER
Filler
Blank
132
1
RCNTY_POP
Population of Residence County
U,R
(This item is available in the territory/possession
file only, geographic codes are not available in the
U.S. file)
0
1
2
3
9
Z
133-136
4
FILLER
Filler
Blank
137
1
RECTYPE
Record Type
U,R
(This item is available in the territory/possession
file only, geographic codes are not available in the
U.S. file)
1
138
1
RESTATUS
U,R
Residence Status
United States
2
1
2
3
4
Outlying Areas of the United States
1
2
*U,R
U
R
County of 1,000,000 or more
County of 500,000 to 1,000,000
County of 250,000 to 500,000
County of 100,000 to 250,000
County less than 100,000
Foreign resident
RESIDENT: Territory/Possession and county
of occurrence and residence are the same.
NONRESIDENT: Territory/Possession and county
of occurrence and residence are different.
RESIDENT: State and county of occurrence and residence
are the same.
INTRASTATE NONRESIDENT: State of occurrence and
residence are the same but county is different.
INTERSTATE NONRESIDENT: State of occurrence and
residence are different but both are one of the 50 US states
or District of Columbia.
FOREIGN RESIDENT: The state of residence is not one of
the 50 US states or District of Columbia.
RESIDENT: State and county of
occurrence and residence are the same. (Unique to Guam,
all US residents are considered residents of Guam and thus
are assigned 1.)
INTRATERRITORY NONRESIDENT: Territory of occurrence and
residence are the same but county is different.
Includes data based on both the 1989 Revision of the U.S. Certificate of Live Birth (unrevised), and the 2003 Revision of
the U.S. Certificate of Live Birth (revised).
Includes data based on the 1989 Revision of the U.S. Certificate of Live Birth; excludes data based on the 2003 Revision.
Includes data based on the 2003 Revision of the U.S. Certificate of Live Birth; excludes data based on the 1989 Revision.
6
2006
Public Use –Natality File Record Layout
Position
Len
Field
Description
Reporting
Flag Position
Rev*
Values Definition
2
3
139-140
2
MBRACE
Mother’s Bridged Race
R**
Includes only states reporting multiple race. Codes
01-14 used for individuals reporting only one race.
Codes 21-24 used for individuals reporting more than
one race that have been bridged to a single race.
Code 24 also used for individuals reporting
more than one Asian/Pacific Islander group;
see “Technical Appendix.”
** Also includes unrevised states that report multiple
race.
141-142
2
MRACE
U
R
01
02
03
04
05
06
07
08
09
10
11
12
13
14
21
22
23
24
Blank
White – single race
Black – single race
American Indian / Alaskan Native – single race
Asian Indian – single race
Chinese – single race
Filipino – single race
Japanese – single race
Korean – single race
Vietnamese � …
Purchase answer to see full
attachment