Scientific Data DocumentationDental Visit Data, 1987
This compressed file contains 2 data sets for the NMES 1987 dental visit data:DATA SRC DATA PURCHASE AND USE AGREEMENTIndividual identifiers have been removed from the micro-data tapes available from the Agency for Health Care Policy and Research through NTIS. Nevertheless, under sections 308(d) and 903(c) of the Public Health Service Act (42 U.S.C. 242m and 42 U.S.C. 299 a-1), data collected by the Agency for Health Care Policy and Research may not be used for any purpose other than the purpose for which it was supplied. The information on the micro-data tapes available for purchase was supplied to the Agency for statis and health services research. It is necessary, therefore, that the indiviual such micro-data tapes sign the following assurance: The undersigned gives assurance that individual elementary unit data on the micro-data tapes being ordered will be used solely for statistical summaries and health services research.BACKGROUND This documentation describes one in a series of public use tapes issued by the Agency for Health Care Policy and Research with data from the National Medical Expenditure Survey. This survey provides extensive information on health expenditures by or on behalf of families and individuals, the financing of these expenditures, and each person's use of services. The National Medical Expenditure Survey (NMES) is a research project of the Center for General Health Services Intramural Research, Agency for Health Care Policy and Research. Since the 1970s the intramural research program has given particular emphasis to studies of the use and financing of health services. The first series of studies (NMES-1) employed data collected in the 1977 National Medical Care Expenditure Survey. NMES-1 produced information on a broad range of issues such as the number and characteristics of the uninsured and the underinsured, the tax implications of excluding employer-paid premiums for health insurance from employee income, and the differences among socioeconomic and demographic groups with respect to the use of health services. A new series of studies (NMES-2) was initiated in the 1980s. These studies also involve a major data collection effort - the 1987 National Medical Expenditure Survey. Like its predecessor, NMES-2 provides information about the non-institutionalized population. In addition and in contrast to the earlier studies, NMES-2 also provides extensive information on the population residing in or admitted to nursing homes and facilities for the mentally retarded. The Household Component of NMES-2 is based on a national probability sample of the civilian, noninstitutionalized population living in the community. The sample is designed to provide a larger representation of population groups of special policy interest to the Federal Government than would have been obtained from a random sample. These groups include poor and low income families, the elderly, the functionally impaired, and black and Hispanic minorities. A Survey of American Indians and Alaska Natives includes a separate sample of American Indians and Alaska Natives living on or near Federal reservations and eligible to receive care provided or supported by the Indian Health Service. The Institutional Population Component includes a sample of persons residing in or admitted to nursing and personal care homes and facilities for the mentally retarded during 1987. A separate Medicare Records Component provides claims data on all Medicare beneficiaries included in the household and institutional samples. Together, the major components of NMES-2 contain information to make national estimates of health status, use of health services, insurance coverage, expenditures, and sources of payment for the civilian population of the United States during the period from January 1 to December 31, 1987. Oversampling of population groups of special interest makes possible in-depth studies of these groups. The database can also be used to assess the implications of recent or proposed changes in public or private health care benefits, methods of financing both health care and insurance coverage, various public and private subsidies for health care, and employee compensation arrangements. Household Survey Each family in the Household Survey was interviewed four times over a period of 16 months to obtain information about the family's health and health care during calendar year 1987. Baseline data on household composition, employment, and insurance were updated at each interview, and information was obtained on illnesses, use of health services, and health expenditures for each family member. A fifth round of interviews was conducted in the spring of 1988 to obtain information on the tax filing and medical deductions of each household. A long term care supplement was administered during the first and fourth rounds of interviewing to permit estimates of persons with functional disabilities and the use of formal services or long term care provided by family or friends. In order to verify and supplement the information provided by household respondents, the Household Component of NMES-2 included two additional surveys. The Medical Provider Survey obtained information from the physicians, hospitals, outpatient clinics, emergency rooms, and home health agencies used by the household sample during 1987. The Health Insurance Plan Survey obtained information on the private insurance of persons in the household sample, including premiums paid by all sources and the provisions of their coverage. Survey of American Indians and Alaska Natives (SAIAN) This component was conducted with the same data collection instruments and interview procedures as the Household Component and covered the same reference period, calendar year 1987. SAIAN also included follow-up surveys to medical providers and health insurers. Consequently, the data can be used to compare American Indians and Alaska Natives eligible for care from the Indian Health Service and the general U.S. population with regard to such issues as health status, use of health services, and access to care. Information was obtained on services provided outside the Indian Health Service and on other sources of health care financing available for persons eligible for care from the IHS. Institutional Population Component The Institutional Population Component of NMES-2 included persons resident in or admitted to nursing and personal care homes and facilities for the mentally retarded at any time in calendar year 1987. This survey provides information on the functional status, use of services, and health expenditures of the institutionalized population. The Survey in Institutions (SII) collected data from facility administrators and designated staff on the characteristics of facilities and charges. The Survey of Next of Kin (SNK) obtained data from the respondent's next-of-kin or other knowledgeable persons in the community on the financial status, insurance coverage, and personal history of the institutionalized person. Survey Samples All survey components were designed to provide statistically unbiased estimates that are representative of the civilian population of the United States in 1987. The Household Survey sample is a stratified multistage area probability design with a total sample of roughly 35,000 individuals, in 14,000 households, who completed all rounds of data collection. Oversampling of the population subgroups of special policy interest was based on a separate screening interview conducted in the fall of 1986 with a sample of 36,000 addresses. The Survey of American Indians and Alaska Natives adopted a multistage area probability sample design using an IHS- constructed frame of counties with individuals eligible for services provided or supported by the Indian Health Service and living on or near Federally recognized reservations or in Alaska. An initial screening interview was completed in approximately 13,700 dwelling units to identify the eligible sample. The screening yielded approximately 1,950 households responding for the full year and approximately 6,500 SAIAN persons responded for their entire period of eligibility in 1987. The institutional population sample was based on a three stage probability design. The first two stages were used to select facilities; the final stage sampled facility residents present on January 1, 1987. These facilities were also used to obtain a sample of admissions between January 1, 1987, and December 31, 1987. Based on sampling specifications the Institutional Population Component includes 1,500 facilities, 800 nursing homes and 700 facilities for the mentally retarded. There is a total of approximately 10,100 persons in the sample including both residents and new admissions. This includes 5,700 persons in nursing homes and 4,400 persons in facilities for the mentally retarded. The sample frame for facilities in the Institutional Population Component was derived from the 1986 Inventory of Long- Term Care Places. Taken in conjunction, the NMES-2 surveys yield comprehensive, population-based information that will support studies of most population groups of policy interest, including those presently outside the scope of various public and private financing mechanisms. In contrast to information obtained from program or provider statistics, NMES-2 data can be used to analyze all public and private sources of coverage for health care services and out-of-pocket payments by individuals and families. The Agency for Health Care Policy and Research sponsored the NMES-2 data collection activities. A substantial part of the support for the Survey of American Indians and Alaska Natives was provided by the Indian Health Service. The Health Care Financing Administration, the National Center for Health Statistics, and the Office of the Assistant Secretary for Planning and Evaluation provided extensive technical assistance during the development of the survey design and instruments. Interviews were conducted by the primary contractor, Westat, Inc., Rockville, Maryland and the National Opinion Research Center at the University of Chicago; the Council of Energy Resource Tribes, Denver, Colorado; and Stephen R. Braund and Associates, Anchorage Alaska. Data processing during the analysis stage of the project is being provided by Social and Scientific Systems, Inc., Bethesda, Maryland. The data were collected under the authorities of the Public Health Service Act and are being edited and published in accordance with the confidentiality provisions of that Act and the Privacy Act. Additional information on NMES-2 is available from Daniel C. Walden, Ph.D., Director of the Division of Medical Expenditure Studies; Center for General Health Services Intramural Research, Agency for Health Care Policy and Research; 2101 East Jefferson Street, Suite 500, Rockville, Maryland, 20852 (301/227-8400). TECHNICAL AND PROGRAMMING INFORMATION General This documentation describes one in a series of public use tapes from the Household Survey of the 1987 National Medical Expenditure Survey (NMES). The tape provides information and related documentation on the use of and expenditures for dental visits for calendar year 1987. The data file contains one record per dental visit for each eligible person in the Household Survey who reported a dental visit during 1987 and who responded for their entire period of eligibility. In addition, each record contains basic person-level demographic information for the sample person, type of service obtained during the dental visit, dates of service, and medical condition (ICD9-HIS codes) if the visit was due to accident or injury. The file can be used to construct summary variables of expenditures, sources of payment, and other aspects of utilization of dental services. NMES Public Use Tape 13 provides information on persons in the Household Survey without dental visits in 1987 and annual person-level information on other health services use as well as detailed demographic, employment and insurance information, round specific eligibility status indicators and reference period dates for the entire civilian noninstitutionalized population. The data on this tape are being released as EBCDIC files only. The tape includes an EBCDIC file containing programming statements required to create a SAS data set and a SAS format library for the data file on the tape. The following documentation offers a brief overview of the type and level of data provided, the content and structure of the data file and the codebook, and programming information. It contains the following sections: Data File Structure and Contents Variable Naming and Codebook Conventions Sample Design, Estimation and Sampling Weights, and Variance Estimation Programming Information Data Dictionary Alphabetical and Position Listing of Variables Codebook Codebook Notes More detailed information on NMES survey instruments and data collection procedures, variance estimation programs, and coding and related information are in Attachments 1 to 5, which are provided as hard-copy attachments to the documentation. Attachment 6 contains a catalogue of data items released on this and other NMES public use tapes. It is supplied to guide the user to the appropriate public use tape for the data items of interest in the NMES Household Survey. Data File Structure and Contents General Information This public use tape contains one data file. The file structure generally reflects the structure of the household questionnaire (see Attachments 1 and 3 for the instruments used). The file contains information on dental visits, expenses, and sources of payment as obtained in four rounds of interviews covering calendar year 1987. The persons represented on this file include all persons in the NMES household sample who used dental services in calendar year 1987 and responded for their entire period of NMES eligibility. The file contains 38,429 records, or one record for each dental visit. A dental visit is defined as a single contact for one or multiple services with a dentist, dental surgeon, oral surgeon, orthodontist, dental assistant, or any other person for dental care. Repeat visits are counted as individual visits. Each record on the data file contains the following information: Unique person and visit identifiers Indicator of the round of data collection Selected demographic variables Variables based on questionnaire items D1 through D11 in the dental visit booklet. These include the date and type of service, ICD9-NHIS codes representing the conditions for dental services resulting from accident or injury, and total expense and sources of payment for all dental services as well as associated imputation flags. Weight and variance estimation variables Detailed information on coding medical conditions related to each dental visit and the type of dental service provided can be found in Sections C.1.1 and C.1.2. The construction of the expense and source of payment variables and associated imputation procedures are described in Section C.1.3. Miscellaneous edits and omissions are discussed in Section C.1.4. Additional detail for selected variables is provided in the codebook notes at the end of the codebook (see section D). The records on this file can be linked to all public use data sets from the Household Survey by using the person identifier (PIDX). Coding of Medical Conditions Coding of Medical Conditions for Visits Related to Accidents and Injuries This file contains a maximum of two condition codes per dental visit resulting from accident or injury as reported by the Household Survey respondent. Information on the nature of the dental injury was used to code each condition related to the dental visit into one of the codes of the 9th Revision of the International Classification of Diseases revised for use in the National Health Interview Survey (NHIS; NCHS, 1979). The revision takes into account the experience of the National Center for Health Statistics, the sponsor of the NHIS, in coding household reported conditions. Coding instructions directed coders to favor X-codes over other relevant ICD-9 codes. Attachment 4 provides details of the NHIS coding scheme for X- codes. The first condition on the record does not necessarily reflect the primary condition for the sample person nor its importance or severity. In addition, there is a small probability that duplicate conditions are attached to the same record. No editing for these duplications has been provided. Coding was conducted by trained medical coders. Two-stage verification of the coding was performed first by supervisors and then by trained nosologists. Coders were required to maintain an error rate at or below 2 percent throughout the coding process. Type of Service An edited variable reflects type of dental service received during each visit (TYPESRVX). TYPESRVX was created using data from each category of Question D7, including the variable DENTOTHR. Data were missing on type of visit for 216 dental visits (less than 1 percent) reported during the four interviewing rounds of the Household Survey. For missing cases in which the user had only one other visit to the same provider during the year, type of service was imputed logically by assigning the same service type. If there was more than one other visit to the same provider, service type was assigned based on the total visit expense closest in value to the original visit without type of service information. If type of service could not be imputed with either method, it was randomly assigned based on the relative frequency of service type for all dental visits with known data for this variable. Expenses and Sources of Payment Total Expense for Dental Visit The data file contains both the unedited charge (EXPTOT) and edited (EXPTOTX) total expense for each dental visit by the sample person during the reference period. These variables reflect all amounts paid out of pocket and by third party sources for services related to each dental visit during 1987 for each sample person who responded for his or her entire period of NMES Household Survey eligibility. There are no dental visits with zero expenses on this file. In settings that do not normally specify a total charge, a dollar value was imputed to construct a total expense variable. For example, there was no explicit total charge for many visits to an HMO or other prepaid providers where care is financed through a capitation payment rather than on a fee-for-service basis. This was also the case for providers financed by Federal, State or local government, by charities, and similar organizations who do not specify charges for their services or provide services free of charge. The edited total expense variable (EXPTOTX) adjusts for such missing or inconsistent expense values by a series of edits and imputation procedures. These addressed three major issues: (1) potential copayment amounts, which were mainly charges reported at the lower extreme of the total expense distribution; (2) potential flat fees, which encompassed multiple visits over a course of treatment and were mainly visit charges at the upper extreme of the total expense distribution; and (3) missing charges where care was delivered free from the provider or under a prepaid arrangement such as an HMO, covered by a flat fee or by Medicaid, or otherwise not reported by the respondent. In cases where a flat fee was associated with multiple visits for the same type of service, the fee was distributed over the number of visits. Visits that were identified as "free from provider", under a prepaid arrangement or missing charge data were imputed, using a weighted sequential hot-deck procedure, to reflect the market value of services. The imputation variables were type of service (TYPESRVX), SMSA status, and designations by state in the Geographic Medicare Economic Index (GMEI). The weighted sequential hot-deck procedure imputes data for visits with complete information to visits with missing data but similar characteristics. Variables with known values for type of service are used to form groups of donors with known data on expenses and identical groups of recipients with missing data. Within such groups, data were assigned from donors to recipients, taking into account the weights associated with each visit in the complex NMES household survey design. Medicaid expenses were imputed using a database consisting of average 1987 Medicaid reimbursements by state, patient age, and type of service for dental care. All imputations were performed at the level of a single visit with the exception of repeat visits (see section C.1.4). Each record with imputed values contains a corresponding imputation flag. In total, approximately 25 percent of expense information was edited or imputed. Sources of Payment Each record on the file contains 9 constructed variables which sum to 100 percent, corresponding to the percent of the total expense paid by each of the following sources: Out of pocket by user or family; Private insurance; including any dental plans; Medicaid; Medicare (the Medicare source of payment variable contains primarily zero values because Medicare, in 1987, did not pay for dental visits in general, although it did cover dental care meeting specific stipulations); Other Federal programs, which include CHAMPUS, CHAMPVA, Supplemental Security Income (SSI), Indian Health Service facility or contract, Intertribal Council, Alaska Native Corporation, Veteran's Administration, any military and other federal programs such as free government screening services and NIH care; Other State and local medical assistance programs such as community health centers (excludes local and state employment related insurance and welfare programs); Workers compensation; Free from the provider, including professional courtesy and bad debt, and; Other, which includes automobile and car insurance, other kinds of insurance not specified, company (where the company is not the insurer), school (where the school is not the insurer or employer), union (where the union is not the insurer or employer), charity, friend, foreign government, or not otherwise specified. Based on respondent reports of the percent or amount paid by each of these sources of payment, the source of payment variables were edited and, where necessary, imputed to correct for the following: (1) the payer reported by the household was incompatible with enrollment in public and private insurance programs reported for the person; (2) the person was not billed reported; (3) the sum of the reported sources did not equal 100 percent; or (4) the sources of payment or the amounts or proportions of the payment were partially or completely missing. Logical edits for sources of payment were performed in those cases where enough information existed. When only a partial source of payment was available and no logical edit was possible, the total distribution of sources of payment was imputed. As for total expenses, the general imputation strategy for sources of payment used a weighted sequential hotdeck procedure. The classification variables used in the source of payment imputation included insurance coverage, region, date of visit, whether the respondent had reported a specific charge, and union membership of the primary insured. Each record with imputed values contains a corresponding imputation flag. The source of payment data have not been reconciled with the variable (DENTVA), which indicates that the dental clinic is a facility of the Veterans Administration. Other Edits and Omissions Some data items from the dental visit booklet were omitted from this file. Omitted variables were not considered to be of independent analytic interest but rather, were methodological probes to insure that the respondent had provided complete utilization and expenditure information. The expense and source of payment variables included on this file reflect all of the components collected in the dental visit section of the questionnaire. Questions pertaining to repeat visits (D26-D30) are not separate variables on this file. Instead, to increase data processing efficiency, the data collected in these questions are represented as separate records, with each record representing a single dental visit. VISITIDX is the unique record identifier for each dental visit. It concatenates ODU, PN, EN, and RVISN. ODU is the original dwelling unit. PN is the person number. The event number EN identifies an initial contact with a given provider for specific services during a round. RVISN is the numerical identifier for any repeat visit within one data collection round to the same provider for the same services at the same expense. The value for RVISN for the first visit equals zero and all repeat visits associated with that visit are numbered consecutively (RVISN = 1 to n). The first visit and all repeat visits share the same event number. All characteristics of the initial visit except the date are assigned to the repeat visits. Similarly, if data for the initial visit were edited or imputed, then the edited or imputed values were also assigned to the repeat visits. About 20 percent of the total dental visits were repeat visits. Unless indicated, all Dental Booklet variables are unedited. Skip patterns associated with unedited variables have not been reconciled. No editing was performed on the round indicator on this file. However, editing was performed on all link variables. Variable Naming and Codebook Conventions The codebook provides unweighted and weighted frequencies for all variables on the file. The codebook contains variable information and frequency distributions for a total of 38,429 records (i.e. visits). Weighted, these records represent 291,766,756 dental visits by 101,563,130 persons (13,439 unweighted). Complete variable listings in alphabetical order and by file position are provided for cross-reference. Most variable descriptors in the codebooks are abbreviated versions of questionnaire items, preceded by indicators of item number. A copy of the round 2 dental visit booklet is included as Attachment 3 to this public use tape to permit a full understanding of the content and wording of each item, the structure of questionnaire sections, skip patterns and administrative information. The codebook describes an EBCDIC data set and provides the following programming identifiers for each variable: IDENTIFIER DESCRIPTION NAME Variable name (maximum of 8 characters) DESCRIPTION Variable descriptor (maximum of 40 characters) FORMAT Number of bytes and decimal places TYPE Type of data: numeric (indicated by NUM) or character (indicated by CHAR) START Beginning column position of variable in the record END Ending column position of variable in the record NOTES Indicator of an explanatory note(s) corresponding to the variable. Explanatory notes can be found in the Codebook Note section. In general, variable names reflect the content of the variable, with an 8 character limitation. For edited versions of original variables, the edited variable name is identical to the original variable with an "X" appended (and truncated when necessary to comply with the 8 character limitation). For variables corresponding to specific questionnaire items, the question number is included in the variable label. The following reserved code values are used: VALUE DEFINITION -1 INAPPLICABLE Question was not asked due to skip pattern -5 NEVER KNOW Question was asked and respondent did not know and never will know the answer -7 REFUSED Question was asked and respondent refused to answer the question -8 DK Question was asked and respondent did not know the answer -9 NOT ASCERTAINED Interviewer did not record the data Sample Design and Variance Estimation Sample Design and Response Rates The NMES household survey was designed to produce national estimates representative of the civilian noninstitutionalized population of the United States as of 1987. For sample selection, the household component of NMES used two independent national multistage area samples from Westat, Inc. and the National Opinion Research Center at the University of Chicago. To improve the quality of the data and to allow for analysis of trends during 1987, the Household Survey was conducted as a panel survey over four core rounds of interviewing. Sampling specifications required the selection of about 17,500 households for the first core household interview. Data were obtained for about 86 percent of eligible households in the first interview and 80 percent by the fourth interview. Approximately 6 percent of all survey participants provided data for only some of the time in which they were eligible to respond. These persons were considered total nonrespondents and a standard nonresponse weight adjustment was used to account for possible selection bias in this respect. For a detailed description of the survey design and of sampling, estimation, and adjustment methods see Cohen, DiGaetano, and Waksberg (1991). Estimation and Sampling Weights General Information The application of appropriate sampling weights is essential to the derivation of valid estimates using this public use file. The weight provided for use with dental visit data, INCALPER, reflects adjustments for complete nonresponse to the NMES survey and poststratification to the Census Bureau 1987 Current Population Survey (CPS) cross-classified by age, race/ethnicity, gender and poverty status. All persons who were eligible at any time during 1987 and responded for the entire period of their eligibility have positive INCALPER weights, yielding 13,439 persons with positive INCALPER weights and at least one dental visit. In order to produce national estimates related to the frequency, expenses and sources of payment for dental care, the value in each record contributing to the estimates must be multiplied by the weight (INCALPER) on that record. It should be noted that this weight, which is also provided on NMES Public Use Tape 13, can also serve as a person-level estimation weight. For estimates involving persons in the Household Survey not on this file (i.e., persons without use of dental services in 1987) or for detailed person-level characteristics of users, including round specific eligibility status and reference period dates, the data on this file should be merged with NMES Public Use Tape 13, using the person-level identification variable PIDX. Information on appropriate tape merges is provided below (C.3.3). Basic Estimates of Utilization and Expenditures This file is constructed for efficient estimation of utilization and expenditures for dental care, including the total number of and expenses for dental visits. The mean expense for dental visits, for instance, should be calculated as the weighted sum of the total expenditures across all records in the file (sum of EXPTOTX x INCALPER) divided by weighted sum of the number of visits (sum of INCALPER). Thus, the numerator is the national estimate for total expenditures for dental visits and the denominator is the population estimate for the total number of dental visits. Subsetting to records based on characteristics of interest expands the scope of potential estimates. For example, the number of dental visits paid for, totally or in part, by private insurance is estimated by summing INCALPER across all records where the private insurance source of payment variable (SOPTPRVT) is greater than zero. Person-Based Ratio Estimates Person-Based Ratio Estimates for Persons with Dental Visits When calculating ratio estimates where the denominator is persons instead of dental visits, care should be taken to properly define and estimate this denominator. If the estimate of interest, for example, is the mean expense for all dental visits across all users of dental services, the following strategy should be considered: All expenses for a person on this file should be summed and a person-level total expense variable created (e.g., the variable X). The mean national estimate would then be derived by obtaining the ratio of the weighted sum of total expenses per person across all unique persons on the file (the sum of INCALPER multiplied by the variable X) divided by the weighted number of unique persons on the file (sum of INCALPER). Only one INCALPER value for each PIDX (person) should contribute to the calculation of the sums for both the numerator and the denominator. Person-Based Ratio Estimates Relative to the Entire Population If the ratio relates to the entire population, this file cannot be used to calculate the denominator, as only those persons with at least one dental visit are represented on it. In this case, Public Use Tape 13 -- Rounds 1-4 Household Survey: Population Characteristics and Person-level Utilization, which has data for all sample people, must be used to estimate persons. For example, to estimate the proportion of persons 65 and over with at least one dental visit which included denture repair, the current file is used to calculate the numerator and NMES Tape 13 is used to calculate the denominator. Sample Weights for Merging Previous Releases Sampling Weights for Merging Previous Releases of NMES Household Data with the Current Tape There have been several previous releases of NMES Household Survey public use data (see Attachment 5). Unless a variable name common to several tapes is provided, the sampling weights contained on these tapes are tape-specific. The tape-specific sampling weights reflect minor adjustments to eligibility and response indicators due, among other factors, to birth, death, or institutionalization among respondents. Adjustments to the weights have also included post-stratification adjustments to control for the distribution of the U.S. noninstitutionalized population by poverty status and, where appropriate, nonresponse adjustments for round-specific supplemental questionnaires (e.g., the health status questionnaires on Tape 9). For estimates from a NMES data file that do not require merging with variables on other NMES files, the sampling weights provided on that tape are the appropriate weights. When merging a NMES household survey tape to another NMES household survey tape, the major analytical variable (i.e., the dependent variable) determines the correct sampling weight to use. For example, for 1987 estimates of dental care use or expenditures (from the present household survey tape) using health status variables from NMES Public Use Tape 9, the full-year weight, INCALPER, on the present tape should be used. By contrast, the weight HSQACCWT from Public Use Tape 9 should be used for when the major dependent variable is health status and dental visit is an independent variable. Three exceptions to this general sampling weight and merger rule are noted below. Details concerning the appropriate weight specific to each tape are given in the documentation for each tape. (1) For estimates of round one data from NMES Public Use Tape 3 (preliminary round one person characteristics and functional health status data), the round one weight (WGTR1PER) provided on NMES Public Use Tape 13 should be used. It should be noted that as a result of further response and eligibility edits, not all persons with positive round one weights on Tape 3 will link when merging to Tape 13. In those instances, an imputation or weighting strategy can be developed to adjust for all persons with positive WGTR1PER weights. (2) For point in time estimates of persons with activity of daily living and instrumental activity of daily living difficulties (Tape 10), the round one or four weight (WGTR1PER and WGTR4PER, respectively), provided on NMES Tape 13 should be used in all instances of merged data regardless of the type of analysis. (3) NMES Public Use Tape 4, which contains prescribed medicine data for the Medicare beneficiary population, should not be merged with the current tape (or any other NMES public use file) because of adjustment to the sampling weights made after the release of Tape 4. It should be noted that the sampling weight provided on NMES Tape 9 (HSQACCWT) reflects nonresponse adjustments specific to the health status questionnaire and access to care supplement data on that tape. This further nonresponse adjustment requires additional considerations in merging Tape 9 with the current tape. (1) When making estimates for data in the current tape, the sampling weights provided on the current tape should be used. Since this would include persons not on Tape 9 in the analysis, data items from Tape 9 will have missing values for these persons. (2) When making estimates of health status or access to care indicators, the Tape 9 weight, HSQACCWT, should be used. This weight adjusts for the exclusion of persons included on the present tape. Variance Estimation Variance estimates of sample statistics require that the complex nature of the NMES Household Survey design be taken into account for hypothesis testing and for the construction of confidence intervals. To obtain variance estimates of statistics by means of statistical programs that use the Taylor series method of variance estimation, variables must be used that denote the strata and the primary sampling unit (PSU) within a given stratum. The variables STRATUMX and SPSU are these variables, respectively and are included on the data file. There are variance estimation programs that account for the complex survey design. A list of available variance estimation programs is produced in Attachment 2. Programming Information These files are contained on a standard label, 9 track 6250 bpi tape. The specifications for each file on the tape are as follows: FILE 1: Description: NMES Household Survey Dental Visit Data File Dataset Name: NMES.PUF143.DATA Number of Observations: 38,429 Number of Variables: 53 Record Length: 220 Block Size: 11,000 Record Format: FB FILE 2: Description: Technical and Programming Information and Data Dictionary for the NMES HHS Dental Visit Data File Dataset Name: NMES.PUF143.DOC Record Length: 133 Block Size: 19,950 Record Format: FB FILE 3: Description: Additional Documentation for SAS Users for the NMES HHS Dental Visit Data File Dataset Name: NMES.PUF143.SRC Record Length: 80 Block Size: 800 Record Format: FB File 1 was created using the SAS (Statistical Analysis System, version 5.18) computer software, and converted to EBCDIC format. File 2 contains the technical documentation stored as an Operating System (OS) EBCDIC file containing ASA carriage control characters in the first byte in each record, which will direct the line printer to skip lines, begin a new page, etc. This technical documentation can be copied to disk and retrieved on- line to view, to modify with a text editor program such as WYLBUR, or to make additional copies. File 3 is an EBCDIC file containing the following additional documentation for SAS users: INPUT statement to create the SAS file, including a LABEL statement; SAS statements which assign a format name to each variable; and SAS statements describing formats. References Cohen, S.B., DiGaetano, R. and Waksberg, J. (1991). National Medical Expenditure Survey: Sample Design of the 1987 Household Survey, Methods 3. AHCPR Pub. No. 91-0037. DHHS: U.S. Public Health Service. National Center for Health Statistics (1979). Medical Coding Manual: National Health Interview Survey. DHHS: U.S. Public Health Service. RECORD LAYOUT Alphabetical listing of Variables DATA DICTIONARY NMES DENTAL VISIT CODEBOOK ALPHABETICAL AND POSITIONAL LISTING OF VARIABLES DATE: MARCH 26, 1992 -----ALPHABETICAL LISTING OF VARIABLES----- START END NAME DESCRIPTION ----- --- ---- ----------- 98 99 BRIDGES D7 BRIDGEWORK THIS VISIT 84 85 CLENTETH D7 TEETH CLEANED THIS VISIT 96 97 CROWNS D7 CROWN(S) THIS VISIT 70 71 DENTINJ D4 DENTAL VISIT DUE TO ACCIDENT/INJURY 104 105 DENTOTHR D7 OTHER DENTAL WORK THIS VISIT 100 101 DENTURES D7 DENTURES THIS VISIT 68 69 DENTVA D3 DENTAL CLINIC IS A FACILITY OF THE VA 80 81 DENTXRAY D6 X-RAY THIS VISIT 60 61 DNDATEDD D1 DATE OF DENTAL VISIT - DAY 58 59 DNDATEMM D1 DATE OF DENTAL VISIT - MONTH 62 63 DNDATEYY D1 DATE OF DENTAL VISIT - YEAR 9 12 EN EVENT NUMBER 23 34 EVENTIDX EVENT ID (ODUX + PN + EN) 86 87 EXAMINE D7 EXAMINATION THIS VISIT 122 122 EXPTFLG IMPUTATION FLAG FOR EDITED TOTAL EXPENSE 108 114 EXPTOT D11 ORIGINAL TOTAL DENTAL CHARGE 115 121 EXPTOTX EDITED TOTAL DENTAL EXPENSE 92 93 EXTRACT D7 EXTRACTION(S) THIS VISIT 66 67 FACTYPE D2 TYPE OF DENTAL FACILITY 90 91 FILLING D7 FILLING(S) THIS VISIT 72 75 ICD1 D5 ICD9 CODE - CONDITION 1 76 79 ICD2 D5 ICD9 CODE - CONDITION 2 196 197 IHSFAC D31 DENTAL FACILITY IHS OR TRIBE/ANC 198 209 INCALPER FULL-YEAR WEIGHT 82 83 JUSTXRAY D7 ONLY X-RAY THIS VISIT 51 53 LASTAGE ED PID AGE AT END OF LAST ELIGIBLE ROUND 1 5 ODUX ORIGINAL DWELLING UNIT OF PERSON 88 89 ORTHDONT D7 ORTHODONTIA THIS VISIT 15 22 PIDX PERSON NUMBER (ODUX + PN) 6 8 PN PERSON NUMBER 64 65 PROVCOD D2 SPECIALTY OF PROVIDER 56 56 RACE3 PID RACE/ETHNICITY 55 55 RACE6 ED PID RACE 102 103 REPAIR D7 BRIDGE/DENTURE REPAIR THIS VISIT 94 95 ROOTCANL D7 ROOT CANAL(S) THIS VISIT 49 50 ROUND DATA COLLECTION ROUND 13 14 RVISN VISIT NUMBER 54 54 SMPSEXR PID SEX 187 194 SOPTFFP PCT PAYMENT FREE FROM PROVIDER 195 195 SOPTFLG IMPUTATION FLG FOR SOURCE OF PAYMENT 147 154 SOPTMCD PCT PAYMENT FROM MEDICAID 139 146 SOPTMCR PCT PAYMENT FROM MEDICARE 155 162 SOPTOTFD PCT PAYMENT FROM OTHER FEDERAL 179 186 SOPTOTHR PCT PAYMENT FROM OTHER 163 170 SOPTOTST PCT PAYMENT FROM OTHER STATE 131 138 SOPTPRVT PCT PAYMENT FROM PRIVATE INSURANCE 123 130 SOPTSELF PCT PAYMENT FROM SELF OR FAMILY 171 178 SOPTWC PCT PAYMENT FROM WORKERS COMP 213 213 SPSU PSEUDO PSU 57 57 SREGION PID CENSUS REGION 210 212 STRATUMX SAMPLING STRATUM 106 107 TYPESRVX ED TYPE DENTAL DERVICE 35 48 VISITIDX VISIT ID (ODUX + PN + EN + RVISN) Positional Listing of Variables NMES DENTAL VISIT CODEBOOK ALPHABETICAL AND POSITIONAL LISTING OF VARIABLES DATE: MARCH 26, 1992 -----POSITIONAL LISTING OF VARIABLES----- START END NAME DESCRIPTION ----- --- ---- ----------- 1 5 ODUX ORIGINAL DWELLING UNIT OF PERSON 6 8 PN PERSON NUMBER 9 12 EN EVENT NUMBER 13 14 RVISN VISIT NUMBER 15 22 PIDX PERSON NUMBER (ODUX + PN) 23 34 EVENTIDX EVENT ID (ODUX + PN + EN) 35 48 VISITIDX VISIT ID (ODUX + PN + EN + RVISN) 49 50 ROUND DATA COLLECTION ROUND 51 53 LASTAGE ED PID AGE AT END OF LAST ELIGIBLE ROUND 54 54 SMPSEXR PID SEX 55 55 RACE6 ED PID RACE 56 56 RACE3 PID RACE/ETHNICITY 57 57 SREGION PID CENSUS REGION 58 59 DNDATEMM D1 DATE OF DENTAL VISIT - MONTH 60 61 DNDATEDD D1 DATE OF DENTAL VISIT - DAY 62 63 DNDATEYY D1 DATE OF DENTAL VISIT - YEAR 64 65 PROVCOD D2 SPECIALTY OF PROVIDER 66 67 FACTYPE D2 TYPE OF DENTAL FACILITY 68 69 DENTVA D3 DENTAL CLINIC IS A FACILITY OF THE VA 70 71 DENTINJ D4 DENTAL VISIT DUE TO ACCIDENT/INJURY 72 75 ICD1 D5 ICD9 CODE - CONDITION 1 76 79 ICD2 D5 ICD9 CODE - CONDITION 2 80 81 DENTXRAY D6 X-RAY THIS VISIT 82 83 JUSTXRAY D7 ONLY X-RAY THIS VISIT 84 85 CLENTETH D7 TEETH CLEANED THIS VISIT 86 87 EXAMINE D7 EXAMINATION THIS VISIT 88 89 ORTHDONT D7 ORTHODONTIA THIS VISIT 90 91 FILLING D7 FILLING(S) THIS VISIT 92 93 EXTRACT D7 EXTRACTION(S) THIS VISIT 94 95 ROOTCANL D7 ROOT CANAL(S) THIS VISIT 96 97 CROWNS D7 CROWN(S) THIS VISIT 98 99 BRIDGES D7 BRIDGEWORK THIS VISIT 100 101 DENTURES D7 DENTURES THIS VISIT 102 103 REPAIR D7 BRIDGE/DENTURE REPAIR THIS VISIT 104 105 DENTOTHR D7 OTHER DENTAL WORK THIS VISIT 106 107 TYPESRVX ED TYPE OF DENTAL SERVICE 108 114 EXPTOT D11 ORIGINAL TOTAL DENTAL CHARGE 115 121 EXPTOTX EDITED TOTAL DENTAL EXPENSE 122 122 EXPTFLG IMPUTATION FLAG FOR EDITED TOTAL EXPENSE 123 130 SOPTSELF PCT PAYMENT FROM SELF OR FAMILY 131 138 SOPTPRVT PCT PAYMENT FROM PRIVATE INSURANCE 139 146 SOPTMCR PCT PAYMENT FROM MEDICARE 147 154 SOPTMCD PCT PAYMENT FROM MEDICAID 155 162 SOPTOTFD PCT PAYMENT FROM OTHER FEDERAL 163 170 SOPTOTST PCT PAYMENT FROM OTHER STATE 171 178 SOPTWC PCT PAYMENT FROM WORKERS COMP 179 186 SOPTOTHR PCT PAYMENT FROM OTHER 187 194 SOPTFFP PCT PAYMENT FREE FROM PROVIDER 195 195 SOPTFLG IMPUTATION FLG FOR SOURCE OF PAYMENT 196 197 IHSFAC D31 DENTAL FACILITY IHS OR TRIBE/ANC 198 209 INCALPER FULL-YEAR WEIGHT 210 212 STRATUMX SAMPLING STRATUM 213 213 SPSU PSEUDO PSU NMES DENTAL VISIT CODEBOOK Starting Numbers 1-59 NMES DENTAL VISIT CODEBOOK DATE: MARCH 26, 1992 ________________________ This codebook provides unweighted and weighted frequencies for the use of dental services for calendar year 1987. The data file contains one record per dental visit for each person in the Household Survey who reported having received dental care over the course of 1987. Basic demographic information about each user, the type of service, associated expenses, sources of payments, and diagnoses are also included on each record. To obtain national estimates for the variables on this file, the weight described at the end of this codebook must be used. Information concerning sample design and variance estimation is provided in the file documentation. For variables corresponding directly to questionnaire items, the item number is provided in the variable descriptor, which also identifies edited variables. For variables with an asterisk in the rightmost column, explanatory notes are provided at the end of the codebook in alphabetical order of the variable name. NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- ODUX ORIGINAL DWELLING UNIT OF PERSON 5.0 NUM 1 5 VALUE UNWEIGHTED WEIGHTED BY INCALPER 20001-37615 38,429 291,766,756 TOTAL 38,429 291,766,756 PN PERSON NUMBER 3.0 NUM 6 8 VALUE UNWEIGHTED WEIGHTED BY INCALPER 10-266 38,429 291,766,756 TOTAL 38,429 291,766,756 EN EVENT NUMBER 4.0 NUM 9 12 VALUE UNWEIGHTED WEIGHTED BY INCALPER 11-1209 38,429 291,766,756 TOTAL 38,429 291,766,756 RVISN VISIT NUMBER 2.0 NUM 13 14 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0-99 38,429 291,766,756 TOTAL 38,429 291,766,756 PIDX PERSON NUMBER (ODUX + PN) 8.0 CHAR 15 22 VALUE UNWEIGHTED WEIGHTED BY INCALPER VALID PERSON ID 38,429 291,766,756 TOTAL 38,429 291,766,756 EVENTIDX EVENT ID (ODUX + PN + EN) 12.0 CHAR 23 34 VALUE UNWEIGHTED WEIGHTED BY INCALPER VALID EVENT ID 38,429 291,766,756 TOTAL 38,429 291,766,756 VISITIDX VISIT ID (ODUX + PN + EN + RVISN) 14.0 CHAR 35 48 VALUE UNWEIGHTED WEIGHTED BY INCALPER VALID VISIT ID 38,429 291,766,756 TOTAL 38,429 291,766,756 ROUND DATA COLLECTION ROUND 2.0 NUM 49 50 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 394 2,982,583 1 9,893 74,974,544 2 14,201 108,329,469 3 8,815 66,870,010 4 5,126 38,610,150 TOTAL 38,429 291,766,756 LASTAGE ED PID AGE AT END OF LAST ELIGIBLE ROUND 3.0 NUM 51 53 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0-17 9,956 76,002,104 18-44 14,009 117,410,559 45-64 7,749 64,536,903 65+ 6,715 33,817,191 TOTAL 38,429 291,766,756 SMPSEXR PID SEX 1.0 NUM 54 54 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 MALE 16,126 125,944,697 2 FEMALE 22,303 165,822,060 TOTAL 38,429 291,766,756 RACE6 ED PID RACE 1.0 NUM 55 55 * VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 AMER INDIAN 170 1,405,352 2 ALASKAN NATIVE 35 265,146 3 ASIAN/PACIFIC 530 4,667,745 4 BLACK 4,934 17,967,064 5 WHITE 31,893 262,764,079 6 OTHER 867 4,697,371 TOTAL 38,429 291,766,756 RACE3 PID RACE/ETHNICITY 1.0 NUM 56 56 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 HISPANIC 2,653 12,831,723 2 BLACK NONHISP 4,872 17,671,554 3 OTHER 30,904 261,263,479 TOTAL 38,429 291,766,756 SREGION PID CENSUS REGION 1.0 NUM 57 57 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 NORTHEAST 8,900 70,703,291 2 MIDWEST 9,783 77,334,827 3 SOUTH 11,416 82,255,720 4 WEST 8,330 61,472,917 TOTAL 38,429 291,766,756 DNDATEMM D1 DATE OF DENTAL VISIT - MONTH 2.0 NUM 58 59 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 103 640,125 -8 DON'T KNOW 182 1,152,580 -7 REFUSED 1 5,007 -5 NEVER KNOW 73 525,504 1 JANUARY 3,537 26,157,190 2 FEBRUARY 3,616 27,345,912 3 MARCH 3,662 27,885,300 4 APRIL 3,251 24,878,832 5 MAY 3,058 23,223,621 6 JUNE 3,555 27,499,550 7 JULY 3,019 23,005,022 8 AUGUST 2,946 22,535,688 9 SEPTEMBER 2,741 21,012,908 10 OCTOBER 3,217 24,739,829 11 NOVEMBER 2,830 21,225,706 12 DECEMBER 2,638 19,933,983 TOTAL 38,429 291,766,756 Starting Numbers 60-79 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- DNDATEDD D1 DATE OF DENTAL VISIT - DAY 2.0 NUM 60 61 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 400 2,862,567 -8 DON'T KNOW 2,065 14,569,772 -7 REFUSED 4 14,540 -5 NEVER KNOW 700 5,128,717 1-31 35,260 269,191,160 TOTAL 38,429 291,766,756 DNDATEYY D1 DATE OF DENTAL VISIT - YEAR 2.0 NUM 62 63 VALUE UNWEIGHTED WEIGHTED BY INCALPER 87 38,429 291,766,756 TOTAL 38,429 291,766,756 PROVCOD D2 SPECIALTY OF PROVIDER 2.0 NUM 64 65 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 880 6,398,601 -8 DON'T KNOW 77 435,538 -7 REFUSED 13 95,642 -1 INAPPLICABLE 938 5,852,717 2 ANESTHESIOLGY 53 362,533 4 DERMATOLOGY 6 49,924 5 FAMLY PRCTICE 20 152,278 6 GENRL PRCTICE 64 579,762 7 INTERNL MEDCN 27 209,994 8 OB/GYN 8 39,262 9 OPHTHALMOLOGY 36 250,290 10 ORTHOEPY 149 1,123,835 11 OSTEOPATHY 25 134,400 12 OTOLARYNGOLGY 8 90,014 14 PEDIATRICS 30 207,420 17 SURGERY 122 904,414 18 UROLOGY 3 21,207 19 DENTIST/CLNIC 35,763 273,527,142 20 EM ROOM PHYSN 7 56,525 21 NEUROLOGIST 1 5,645 24 GASTRENTERLGY 1 4,469 52 CHIROPRACTOR 5 48,261 55 NURSE 43 293,578 56 NURSE PRACTNR 4 20,803 57 TECHNICIAN 10 53,532 59 OPTOMETRIST 28 190,834 60 PODIATRIST 4 16,629 61 PHYSCIAN ASST 12 45,324 63 PSYCHOLOGIST 1 3,703 65 SOCIAL WORKER 1 3,314 66 SPEECH THRPST 1 6,464 91 OTH DR SPECL 60 366,287 92 OTH PROVIDER 29 216,417 TOTAL 38,429 291,766,756 FACTYPE D2 TYPE OF DENTAL FACILITY 2.0 NUM 66 67 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 1,449 10,407,377 -8 DON'T KNOW 27 165,376 -7 REFUSED 6 73,566 -1 INAPPLICABLE 32,076 248,107,579 1 DR OFFICE/GRP 79 566,505 2 DR CLINIC 44 342,135 3 NEIGH/FAM CTR 97 429,650 4 SURGICAL CNTR 5 22,368 5 COMPANY CLNIC 12 70,733 6 SCHOOL CLINIC 24 119,667 7 OTHER CLINIC 232 1,309,707 9 LABORATORY 10 39,779 10 WLK-IN URGENT 7 63,270 11 HOSP CLNIC/ER 319 2,011,725 19 DENTAL CLINIC 3,888 27,053,973 22 OPTICAL STORE 7 33,559 91 OTHER 147 949,786 TOTAL 38,429 291,766,756 DENTVA D3 DENTAL CLINIC IS A FACILITY OF THE VA 2.0 NUM 68 69 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 478 3,812,946 -8 DON'T KNOW 3 11,057 -1 INAPPLICABLE 33,836 255,773,423 1 YES 126 805,886 2 NO 3,986 31,363,445 TOTAL 38,429 291,766,756 DENTINJ D4 DENTAL VISIT DUE TO ACCIDENT/INJURY 2.0 NUM 70 71 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 338 2,432,155 -8 DON'T KNOW 63 513,711 1 YES 802 5,935,260 2 NO 37,226 282,885,630 TOTAL 38,429 291,766,756 ICD1 D5 ICD9 CODE - CONDITION 1 4.0 CHAR 72 75 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 37,627 285,831,497 -9 NOT ASCERTAIN 31 219,377 V001-V999 67 470,509 X00X-X999 7 67,932 0001-9999 697 5,177,441 TOTAL 38,429 291,766,756 ICD2 D5 ICD9 CODE - CONDITION 2 4.0 CHAR 76 79 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 38,387 291,435,763 -9 NOT ASCERTAIN 31 219,377 0001-9999 11 111,617 TOTAL 38,429 291,766,756 Starting Numbers 80-101 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- DENTXRAY D6 X-RAY THIS VISIT 2.0 NUM 80 81 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 336 2,351,768 -8 DON'T KNOW 291 2,339,697 -7 REFUSED 1 5,007 1 YES 13,251 100,067,715 2 NO 24,550 187,002,570 TOTAL 38,429 291,766,756 JUSTXRAY D7 ONLY X-RAY THIS VISIT 2.0 NUM 82 83 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 73 514,758 -8 DON'T KNOW 29 173,818 -7 REFUSED 5 16,933 1 YES 860 6,088,456 2 NO 37,462 284,972,791 TOTAL 38,429 291,766,756 CLENTETH D7 TEETH CLEANED THIS VISIT 2.0 NUM 84 85 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 59 378,103 -8 DON'T KNOW 26 154,700 -7 REFUSED 5 16,933 -1 INAPPLICABLE 853 6,047,569 1 YES 13,079 102,374,424 2 NO 24,407 182,795,027 TOTAL 38,429 291,766,756 EXAMINE D7 EXAMINATION THIS VISIT 2.0 NUM 86 87 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 56 376,286 -8 DON'T KNOW 27 170,742 -7 REFUSED 5 16,933 -1 INAPPLICABLE 853 6,047,569 1 YES 11,375 88,747,433 2 NO 26,113 196,407,793 TOTAL 38,429 291,766,756 ORTHDONT D7 ORTHODONTIA THIS VISIT 2.0 NUM 88 89 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 65 484,607 -8 DON'T KNOW 28 173,121 -7 REFUSED 5 16,933 -1 INAPPLICABLE 853 6,047,569 1 YES 4,886 39,153,609 2 NO 32,592 245,890,916 TOTAL 38,429 291,766,756 FILLING D7 FILLING(S) THIS VISIT 2.0 NUM 90 91 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 63 422,521 -8 DON'T KNOW 20 151,725 -7 REFUSED 5 16,933 -1 INAPPLICABLE 853 6,047,569 1 YES 6,463 48,727,599 2 NO 31,025 236,400,409 TOTAL 38,429 291,766,756 EXTRACT D7 EXTRACTION(S) THIS VISIT 2.0 NUM 92 93 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 70 472,343 -8 DON'T KNOW 24 156,300 -7 REFUSED 5 16,933 -1 INAPPLICABLE 853 6,047,569 1 YES 3,048 19,944,424 2 NO 34,429 265,129,187 TOTAL 38,429 291,766,756 ROOTCANL D7 ROOT CANAL(S) THIS VISIT 2.0 NUM 94 95 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 72 500,804 -8 DON'T KNOW 25 151,936 -7 REFUSED 5 16,933 -1 INAPPLICABLE 853 6,047,569 1 YES 1,745 12,636,058 2 NO 35,729 272,413,455 TOTAL 38,429 291,766,756 CROWNS D7 CROWN(S) THIS VISIT 2.0 NUM 96 97 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 70 464,662 -8 DON'T KNOW 27 176,131 -7 REFUSED 5 16,933 -1 INAPPLICABLE 853 6,047,569 1 YES 2,372 18,944,336 2 NO 35,102 266,117,125 TOTAL 38,429 291,766,756 BRIDGES D7 BRIDGEWORK THIS VISIT 2.0 NUM 98 99 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 66 440,879 -8 DON'T KNOW 29 185,449 -7 REFUSED 4 11,926 -1 INAPPLICABLE 853 6,047,569 1 YES 935 6,571,647 2 NO 36,542 278,509,286 TOTAL 38,429 291,766,756 DENTURES D7 DENTURES THIS VISIT 2.0 NUM 100 101 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 72 496,966 -8 DON'T KNOW 29 185,449 -7 REFUSED 5 16,933 -1 INAPPLICABLE 853 6,047,569 1 YES 1,436 8,734,345 2 NO 36,034 276,285,493 TOTAL 38,429 291,766,756 Starting Numbers 102-138 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- REPAIR D7 BRIDGE/DENTURE REPAIR THIS VISIT 2.0 NUM 102 103 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 71 481,722 -8 DON'T KNOW 29 185,449 -7 REFUSED 1 5,007 -1 INAPPLICABLE 853 6,047,569 1 YES 1,345 8,677,698 2 NO 36,130 276,369,311 TOTAL 38,429 291,766,756 DENTOTHR D7 OTHER DENTAL WORK THIS VISIT 2.0 NUM 104 105 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 72 488,853 -8 DON'T KNOW 85 585,628 -7 REFUSED 5 16,933 -1 INAPPLICABLE 852 6,038,678 0 NO 33,176 251,532,288 12 PERIODONTAL 818 6,223,316 13 FLUORIDE TRMT 623 5,237,174 14 XRAYS IN COMB 58 477,319 15 SEALANT 173 1,462,143 16 CAPPING 246 2,026,086 17 ORAL SURGERY 423 3,029,230 18 CONSULTATION 168 1,392,324 19 ABSCESS 99 740,940 91 OTHER 1,631 12,515,845 TOTAL 38,429 291,766,756 TYPESRVX ED TYPE OF DENTAL SERVICE 2.0 NUM 106 107 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 ONLY XRAY 859 6,079,564 2 TEETH CLEANED 4,952 37,678,629 3 EXAMINATION 3,014 22,524,437 4 ORTHODONTIA 4,526 36,499,468 5 FILLING 4,355 33,229,224 6 EXTRACTION 2,079 13,940,590 7 ROOT CANAL 1,118 8,153,676 8 CROWNS 1,563 12,830,217 9 BRIDGES 508 3,755,106 10 DENTURES 1,009 6,147,197 11 REPAIR 977 6,172,398 12 OTHER DENTAL 2,456 19,020,107 13 MULT SERVCS-1 1,818 13,055,965 14 MULT SERVCS-2 864 5,838,200 15 MULT SERVCS-3 8,331 66,841,980 TOTAL 38,429 291,766,756 EXPTOT D11 ORIGINAL TOTAL DENTAL CHARGE 7.2 NUM 108 114 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 210 1,373,444 -8 DON'T KNOW 1,803 13,285,929 -7 REFUSED 2 19,815 -5 NEVER KNOW 809 6,020,559 -1 INAPPLICABLE 15,021 110,645,241 1.00- 5 125 834,654 5.01- 50 12,936 100,078,110 50.01- 100 4,683 37,372,483 100.01- 200 1,396 10,725,489 200.01- 400 889 7,045,225 400.01- 600 306 2,402,582 600.01- 800 93 734,470 800.01-1000 57 486,207 1000.01-2000 73 595,439 2000.01-6000 26 147,108 TOTAL 38,429 291,766,756 EXPTOTX EDITED TOTAL DENTAL EXPENSE 7.2 NUM 115 121 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1.00- 5 131 928,598 5.01- 50 19,527 145,122,550 50.01- 100 8,762 67,189,951 100.01- 200 5,389 42,506,122 200.01- 400 3,235 25,268,172 400.01- 600 845 6,749,847 600.01- 800 256 1,792,987 800.01-1000 112 956,810 1000.01-2000 161 1,171,464 2000.01-6000 11 80,255 TOTAL 38,429 291,766,756 EXPTFLG IMPUTATION FLAG FOR EDITED TOTAL EXPENSE 1.0 NUM 122 122 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 EXP FROM HS 29,289 228,450,873 3 EXP IMPUTED 9,140 63,315,884 TOTAL 38,429 291,766,756 SOPTSELF PCT PAYMENT FROM SELF OR FAMILY 8.4 NUM 123 130 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 9,770 71,933,026 GT 0 TO 20 3,762 31,129,235 GT 20 TO 40 2,142 17,495,694 GT 40 TO 60 2,425 20,309,690 GT 60 TO 80 1,133 9,716,584 GT 80 TO LT 100 522 4,011,415 100 18,675 137,171,111 TOTAL 38,429 291,766,756 SOPTPRVT PCT PAYMENT FROM PRIVATE INSURANCE 8.4 NUM 131 138 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 24,055 172,434,469 GT 0 TO 20 557 4,257,959 GT 20 TO 40 1,053 9,108,283 GT 40 TO 60 2,387 20,186,425 GT 60 TO 80 3,514 28,926,623 GT 80 TO LT 100 1,743 15,035,985 100 5,120 41,817,012 TOTAL 38,429 291,766,756 Starting Numbers 139-213 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- SOPTMCR PCT PAYMENT FROM MEDICARE 8.4 NUM 139 146 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 38,360 291,489,903 GT 20 TO 40 3 13,247 GT 40 TO 60 21 86,140 GT 60 TO 80 4 19,179 100 41 158,287 TOTAL 38,429 291,766,756 SOPTMCD PCT PAYMENT FROM MEDICAID 8.4 NUM 147 154 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 36,462 281,185,033 GT 0 TO 20 5 18,338 GT 20 TO 40 4 10,233 GT 40 TO 60 7 42,634 GT 60 TO 80 16 51,572 GT 80 TO LT 100 214 1,109,077 100 1,721 9,349,870 TOTAL 38,429 291,766,756 SOPTOTFD PCT PAYMENT FROM OTHER FEDERAL 8.4 NUM 155 162 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 37,858 288,160,425 GT 0 TO 20 12 71,706 GT 20 TO 40 2 16,744 GT 40 TO 60 3 17,992 GT 60 TO 80 15 119,817 GT 80 TO LT 100 5 39,455 100 534 3,340,619 TOTAL 38,429 291,766,756 SOPTOTST PCT PAYMENT FROM OTHER STATE 8.4 NUM 163 170 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 38,253 290,856,797 GT 0 TO 20 1 9,652 GT 40 TO 60 3 36,805 GT 60 TO 80 4 21,403 GT 80 TO LT 100 13 74,506 100 155 767,594 TOTAL 38,429 291,766,756 SOPTWC PCT PAYMENT FROM WORKERS COMP 8.4 NUM 171 178 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 38,391 291,420,221 GT 0 TO 20 3 30,612 GT 80 TO LT 100 1 9,140 100 34 306,784 TOTAL 38,429 291,766,756 SOPTOTHR PCT PAYMENT FROM OTHER 8.4 NUM 179 186 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 38,042 288,570,242 GT 0 TO 20 90 730,624 GT 20 TO 40 12 124,632 GT 40 TO 60 44 414,352 GT 60 TO 80 69 642,935 GT 80 TO LT 100 59 459,649 100 113 824,323 TOTAL 38,429 291,766,756 SOPTFFP PCT PAYMENT FREE FROM PROVIDER 8.4 NUM 187 194 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 36,147 274,505,520 GT 0 TO 20 19 182,196 GT 20 TO 40 132 1,165,547 GT 40 TO 60 34 308,988 GT 60 TO 80 40 283,538 GT 80 TO LT 100 23 128,735 100 2,034 15,192,232 TOTAL 38,429 291,766,756 SOPTFLG IMPUTATION FLG FOR SOURCE OF PAYMENT 1.0 NUM 195 195 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 ALL SOP FRM HS 32,283 244,125,376 2 ALL SOP IMPUTD 6,146 47,641,380 TOTAL 38,429 291,766,756 IHSFAC D31 DENTAL FACILITY IHS OR TRIBE/ANC 2.0 NUM 196 197 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 186 1,409,282 -1 INAPPLICABLE 38,153 289,595,359 1 IHS 13 110,573 3 NOT IHS/TRIBE 77 651,543 TOTAL 38,429 291,766,756 INCALPER FULL-YEAR WEIGHT 12.6 NUM 198 209 VALUE UNWEIGHTED WEIGHTED BY INCALPER 780.924-27174.39 38,429 N/A TOTAL 38,429 N/A STRATUMX SAMPLING STRATUM 3.0 NUM 210 212 VALUE UNWEIGHTED WEIGHTED BY INCALPER 301-401 38,429 291,766,756 TOTAL 38,429 291,766,756 SPSU PSEUDO PSU 1.0 NUM 213 213 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 18,985 144,146,986 2 19,444 147,619,771 TOTAL 38,429 291,766,756 NMES HOUSEHOLD SURVEY DENTAL VISIT CODEBOOK NOTES An asterisk in the rightmost column of the codebook indicates that an explanatory note provides greater detail on information necessary for the use of this variable. These notes are listed below in alphabetical order of variable name. VARIABLE NOTE DENTOTHR A constructed variable that was created by reviewing the "other, specify" text field for the question on type of dental services provided (D7). Possible positive values are: 12 Periodontal work 13 Fluoride treatment 14 X-rays in combination with other work 15 Sealant applied 16 Tooth capped 17 Oral surgery 18 Consultation 19 Abscess 91 Other work EN These variables identify and link multiple or RVISN repeat dental visits. VISITIDX is the unique VISITIDX record identifier for each dental visit. The event number, EN, identifies an initial contact with a given provider for specific services during a round. RVISN is the numerical identifier for any repeat visits within one data collection round to the same provider for the same services at the same expense. Here, RVISN for the first visit equals zero and all repeat visits associated with that visit are numbered consecutively (RVISN = 1 to n). The first visit and all repeat visits share the same event number. EXPTFLG A flag indicating whether the total expense for that visit record was imputed or provided by the household respondent. EXPTOT Unedited charge (EXPTOT) and edited expenditure EXPTOTX (EXPTOTX) variables reflecting total expense for each dental visit by the sample person during 1987. A dollar value was assigned to the edited expense variable for all dental visits, including those free from provider and those financed through a prepaid capitation (HMO) payment. FACTYPE Variable containing the type of dental PROVCOD professional (PROVCOD) or facility (FACTYPE) providing dental services as reported by the household respondent. These data were collected as part of Question D 2. Persons could have provided both the type of provider and the facility. In cases where only facility data were collected, PROVCOD is coded -1. In cases where only the type of dental professional was collected, FACTYPE is coded -1. Neither FACTYPE nor PROVCOD were edited for consistency or imputed. INCALPER Weight adjusted for nonresponse and post-stratified to U.S. census data. Estimates of utilization and expenditure for dental visits require the use of weighted data. For details on this weight, see the Technical and Programming section on this file and the hard copy documentation accompanying this tape. LASTAGE An edited variable which identifies person age, in years, as of the end of the last round in 1987 for which the person was eligible. Less than 0.1 percent of the cases were edited. PROVCOD See FACTYPE. RACE3 A person-level variable constructed to facilitate the poststratification of the NMES person-level sampling weights by race and ethnicity, considering three mutually exclusive classifications: Hispanic, Black--non-Hispanic, and white or other. RACE6 An edited variable indicating race. Less than 0.2 percent of cases were edited. ROUND Indicator of the round of data collection. Dates for each sample person's rounds of data collection are provided on NMES Public Use Tape 13. RVISN See EN. SOPTFLG A flag indicating whether all the source of payment percentages for that dental record were imputed or provided by the household respondent. SPSU To obtain variance estimates of sample statistics STRATUMX by means of standard statistical programs that use the Taylor series linearization method of variance estimation, variables must be used that denote the strata and primary sampling unit (PSU) within a given strata. The variables STRATUMX and SPSU are these variables, respectively. For details on sampling weights and variance estimation, see the Technical and Programming section on this file and the hard copy documentation accompanying this tape. TYPESRVX An edited variable indicating the type of service provided during the visit. Variable values are: 1 X-rays only 2 Teeth cleaned 3 Dental examination 4 Orthodontia work 5 Filling 6 Tooth extraction 7 Root canal work 8 Crown work 9 Bridgework 10 Denture work during the visit 11 Repair of dental work during the visit. 12 Dental work involving at least one other type of service. 13 Multiple services-1: at least two specific types of service in which at least one was work on a root canal, crown, bridge, or dentures and none were other services. For example, a dental visit with a crown and a filling would be included in this group. 14 Multiple services-2: visits with at least one orthodontic service or extraction, but no root canal, crown, bridge, denture work, or other services. 15 Multiple services-3: dental visits with at least two specified types of service, none of which were an extraction, orthodontia, or root canal, crown, bridge, or denture work or other service. A visit involving a filling and an x-ray is an example of multiple services-3. VISITIDX See EN.
This page last reviewed: Thursday, January 28, 2016
This information is provided as technical reference material. Please contact us at firstname.lastname@example.org to request a simple text version of this document.