MEPS HC-49: 1998 Long Term Care Supplemental Public Use File Agency for Healthcare Research and Quality
Center for Cost and Financing Studies
2101 East Jefferson Street, Suite 501
Rockville, MD 20852
(301) 594-1406
TABLE OF CONTENTS
A. Data Use
Agreement
B. Background
1.0 Household
Component
2.0 Medical
Provider
Component
3.0 Insurance
Component
4.0 Survey
Management
C. Technical
and Programming
Information
1.0 General Information
2.0 Data File Information
2.1 Codebook Structure
2.2 Reserved
Codes
2.3 Codebook
Format
2.4 Variable
Naming
2.5 File
Contents
2.5.1 Long
Term Care (LTC) Variables (PANELRN - NUM_COND)
D. Variable-Source
Crosswalk
Attachment
1
A. Data Use Agreement
Individual identifiers have been removed from the
micro-data contained in these files. 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 Healthcare Research and Quality (AHRQ)
and/or the National Center for Health Statistics (NCHS) may not be used for
any purpose other than for the purpose for which they were supplied; any
effort to determine the identity of any reported cases is prohibited by law.
Therefore in accordance with the above referenced Federal
Statute, it is understood that:
-
No one is to use the data in this data set in any way except for
statistical reporting and analysis; and
-
If the identity of any person or establishment should be discovered
inadvertently, then (a) no use will be made of this knowledge, (b) the
Director Office of Management AHRQ will be advised of this incident, (c) the
information that would identify any individual or establishment will be
safeguarded or destroyed, as requested by AHRQ, and (d) no one else will be
informed of the discovered identity; and
-
No one will attempt to link this data set with individually
identifiable records from any data sets other than the Medical Expenditure
Panel Survey or the National Health Interview Survey.
By using these data you signify your agreement to comply
with the above stated statutorily based requirements with the knowledge that
deliberately making a false statement in any matter within the jurisdiction of
any department or agency of the Federal Government violates Title 18 part 1
Chapter 47 Section 1001 and is punishable by a fine of up to $10,000 or up to
5 years in prison.
The Agency for Healthcare Research and Quality requests that users cite
AHRQ and the Medical Expenditure Panel Survey as the data source in any
publications or research based upon these data.
Return To Table Of
Contents
B. Background
The Medical Expenditure Panel Survey (MEPS)
provides nationally representative estimates of health care use, expenditures,
sources of payment, and insurance coverage for the U.S. civilian
non-institutionalized population. MEPS is cosponsored by the Agency for
Healthcare Research and Quality (AHRQ) and the National Center for Health
Statistics (NCHS).
MEPS is a family of three surveys. The
Household Component (HC) is the core survey and forms the basis for the
Medical Provider Component (MPC) and part of the Insurance Component (IC).
Together these surveys yield comprehensive data that provide national
estimates of the level and distribution of health care use and expenditures,
support health services research, and can be used to assess health care policy
implications.
MEPS is the third in a series of national
probability surveys conducted by AHRQ on the financing and use of medical care
in the United States. The National Medical Care Expenditure Survey (NMCES,
also known as NMES-1) was conducted in 1977 and the National Medical
Expenditure Survey (NMES-2) in 1987. Since 1996, MEPS continues this series
with design enhancements and efficiencies that provide a more current data
resource to capture the changing dynamics of the health care delivery and
insurance system.
The design efficiencies incorporated into MEPS
are in accordance with the Department of Health and Human Services (DHHS)
Survey Integration Plan of June 1995, which focused on consolidating DHHS
surveys, achieving cost efficiencies, reducing respondent burden, and
enhancing analytical capacities. To advance these goals, MEPS includes
linkage with the National Health Interview Survey (NHIS) - a survey conducted
by NCHS from which the sample for the MEPS HC is drawn - and enhanced
longitudinal data collection for core survey components. The MEPS HC augments
NHIS by selecting a sample of NHIS respondents, collecting additional data on
their health care expenditures, and linking these data with additional
information collected from the respondents' medical providers, employers, and
insurance providers.
Return To Table Of
Contents
1.0 Household Component
The MEPS HC, a nationally representative
survey of the U.S. civilian non-institutionalized population, collects medical
expenditure data at both the person and household levels. The HC collects
detailed data on demographic characteristics, health conditions, health
status, use of medical care services, charges and payments, access to care,
satisfaction with care, health insurance coverage, income, and employment.
The HC uses an overlapping panel design in
which data are collected through a preliminary contact followed by a series of
five rounds of interviews over a 2 ½-year period. Using computer-assisted
personal interviewing (CAPI) technology, data on medical expenditures and use
for two calendar years are collected from each household. This series of data
collection rounds is launched each subsequent year on a new sample of
households to provide overlapping panels of survey data and, when combined
with other ongoing panels, will provide continuous and current estimates of
health care expenditures.
The sampling frame for the MEPS HC is drawn
from respondents to NHIS. NHIS provides a nationally representative sample of
the U.S. civilian non-institutionalized population, with oversampling of
Hispanics and blacks.
Return To Table Of
Contents
2.0 Medical Provider Component
The MEPS MPC supplements and/or replaces
information on medical care events reported in the MEPS HC by contacting
medical providers and pharmacies identified by household respondents. The MPC
sample includes all home health agencies and pharmacies reported by HC
respondents. Office-based physicians, hospitals, and hospital physicians are
also included in the MPC but may be subsampled at various rates, depending on
burden and resources, in certain years.
Data are collected on medical and financial
characteristics of medical and pharmacy events reported by HC respondents.
The MPC is conducted through telephone interviews and record abstraction.
Return To Table Of
Contents
3.0 Insurance Component
The MEPS IC collects data on health insurance
plans obtained through private and public-sector employers. Data obtained in
the IC include the number and types of private insurance plans offered,
benefits associated with these plans, premiums, contributions by employers and
employees, eligibility requirements, and employer characteristics.
Establishments participating in the MEPS IC
are selected through three sampling frames:
-
A list of employers or other
insurance providers identified by MEPS HC respondents who report having
private health insurance at the Round 1 interview.
-
A Bureau of the Census list
frame of private sector business establishments.
-
The Census of Governments from
Bureau of the Census.
To provide an integrated picture of health
insurance, data collected from the first sampling frame (employers and
insurance providers identified by MEPS HC respondents) are linked back to data
provided by those respondents. Data from the two Census Bureau sampling
frames are used to produce annual national and state estimates of the supply
and cost of private health insurance available to American workers and to
evaluate policy issues pertaining to health insurance. National estimates of
employer contributions to group insurance from the MEPS IC are used in the
computation of Gross Domestic Product (GDP) by the Bureau of Economic
Analysis.
The MEPS IC is an annual panel survey. Data
are collected from the selected organizations through a prescreening telephone
interview, a mailed questionnaire, and a telephone follow-up for
nonrespondents.
Return To Table Of
Contents
4.0 Survey Management
MEPS data are collected under the authority of
the Public Health Service Act. They are edited and published in accordance
with the confidentiality provisions of this act and the Privacy Act. NCHS
provides consultation and technical assistance.
As soon as data collection and editing are
completed, the MEPS survey data are released to the public in staged releases
of summary reports, microdata files and compendiums of tables. Data are
released through MEPSnet, an online interactive tool developed to give users
the ability to statistically analyze MEPS data in real time. Summary reports
and compendiums of tables are released as printed documents and electronic
files. Microdata files are released on electronic files.
Selected printed documents are available
through the AHRQ Publications Clearinghouse. Write or call:
AHRQ Publications Clearinghouse
Attn: (publication number)
P.O. Box 8547
Silver Spring, MD 20907
800-358-9295
410-381-3150 (callers outside the United
States only)
888-586-6340 (toll-free TDD service; hearing
impaired only)
Be sure to specify the AHRQ number of the
document you are requesting.
Additional information on MEPS is available from
the MEPS project manager or the MEPS public use data manager at the Center for
Cost and Financing Studies, Agency for Healthcare Research and Quality.
Return To Table Of
Contents
C. Technical
and Programming Information
1.0 General Information
This documentation describes a series of MEPS variables that were obtained
for calendar year 1998. This data release is intended to supplement the MEPS
variables previously released for 1998. In order to use these variables,
researchers will need to link them to the 1998 Consolidated Full-Year Use and
Expenditure File (HC-028) which contains all previously released 1998 person
level data including demographic and socio-economic information. Please refer
to the HC-028 documentation for further information.
The following documentation offers a brief overview of the types and levels
of data provided, the content and structure of the file, and programming
information. It contains the following sections:
- Data File Information
- Variable-Source Crosswalk (Section D)
A codebook of all the variables included in this 1998 Long Term Care
Supplemental File is provided in a separate file (H49CB.PDF).
A database of all MEPS products released to date and a variable locator
indicating the major MEPS HC data items on public use files (including
weights) that have been released to date can be found at the following link on
the MEPS website: www.meps.ahrq.gov.
Return To Table Of
Contents
2.0 Data File Information
This 1998 long term care
supplemental variable public use data set consists of one person-level file. Unweighted
frequencies are provided for each variable on the files. In conjunction with
the weight variable (WTDPER98) provided on MEPS HC-028: 1998 Full Year
Consolidated Data File, data for these persons can be used to make estimates
for the civilian non-institutionalized U. S. population for 1998. The records
on this data release can be linked to all other 1998 MEPS-HC public use data
files by using the sample person identifier (DUPERSID). Panel 2 cases (Panel
98=2) can be linked back to the 1997 MEPS-HC public use data files. A
longitudinal weight to facilitate Panel 2, 1997-98 analysis can be found on
HC-035.
Return To Table Of
Contents
2.1 Codebook Structure
The codebook and data file sequence lists variables in the following order:
Return To Table Of
Contents
2.2 Reserved Codes
The following reserved code values are used:
VALUE |
DEFINITION |
-1 INAPPLICABLE |
Question was not asked due to skip pattern |
-7 REFUSED |
Question was asked and respondent refused to answer
question |
-8 DK |
Question was asked and respondent did not know
answer |
-9 NOT ASCERTAINED |
Interviewer did not record
the data |
Return To Table Of
Contents
2.3 Codebook Format
This codebook describes an ASCII
data set and provides the following programming identifiers for each variable:
IDENTIFIER |
DESCRIPTION |
Name |
Variable name
(maximum of 8 characters) |
Description |
Variable
descriptor (maximum 40 characters) |
Format |
Number of bytes |
Type |
Type of data:
numeric (indicated by NUM) or character (indicated by CHAR) |
Start |
Beginning
column position of variable in record |
End |
Ending column
position of variable in record |
Return To Table Of
Contents
2.4 Variable Naming
In general, variable names reflect the content of the variable, with an
eight-character limitation. Edited variables end in an X, and are so noted in
the variable label. The last two characters in round-specific variables denote
the rounds of data collection, Round 3, 4, or 5 of Panel 2 and Round 1, 2, or
3 of Panel 3. Unless otherwise noted, variables that end in 98 represent
status as of December 31, 1998.
Variables contained in this
delivery were derived either from the questionnaire itself or from the CAPI.
The source of each variable is identified in the section of the documentation
entitled "Section D. Variable-Source Crosswalk." Sources for each variable are
indicated in one of four ways: (1) variables derived from CAPI or assigned in
sampling are so indicated; (2) variables derived from complex algorithms
associated with re-enumeration are labeled "RE Section"; (3) variables that
are collected by one or more specific questions in the instrument have those
question numbers listed in the Source column; (4) variables constructed from
multiple questions using complex algorithms are labeled "Constructed."
Return To Table Of
Contents
2.5 File Contents
2.5.1 Long Term Care (LTC) Variables (PANELRN -
NUM_COND)
The MEPS LTC supplemental questionnaire is used to
collect detailed information on individuals who have activity or functional
limitations, hearing or vision impairments, and special equipment
requirements. It includes persons in the second round of the 1998 survey
(Round 4 of Panel 2 and Round 2 of Panel 3) who were flagged for one or more
sections of the LTC supplement based on their responses to screener questions
in the health status section of the household survey questionnaire. The
health status flags could have been set in Round 3 or 4 for Panel 2, and in
Round 1 or 2 for Panel 3.
The LTC supplement consists of nine series of questions
about functional limitations and the use of special equipment. Each series of
questions and the associated question numbers in the LTC supplement are shown
below for persons who were eligible for some or all questions in a specific
series:
Sections of LTC Supplement |
Activities of Daily Living (ADL) Series |
asks a full ADL battery (LC1 - LC11) for
individuals who were flagged as having an ADL limitation |
Instrumental Activities of Daily Living (IADL)
Series |
asks a full IADL battery (LC12 - LC19) for
individuals who were flagged as having an IADL limitation |
Memory Series |
asks questions about person's memory (LC20 - LC21)
for individuals flagged as having a cognitive limitation |
Child Series |
asks a series of questions about children's delays,
problems in school, and functioning (LC22 - LC29) for children flagged
as having a limitation |
Communication
Series |
asks a series of
questions about a person's ability to communicate and understand
language (LC30 - LC33) for individuals flagged as having a limitation
and who did not answer the LTC supplement for themselves |
Work Series |
asks questions about work accommodations (LC34 -
LC36) if flagged as having a relevant limitation and age 16 or older |
Transportation Series |
asks information about driving, limitations and
reliance on other individuals or special forms of transportation (LC37 -
LC40) if flagged as having a relevant limitation |
Assisted Technology Series |
asks about use of different kinds of special
equipment or technology (LC41 - LC42) if person has a relevant
limitation |
General Series |
asks about the timing of a limitation and use of
community services (LC43-LC47) if eligible for any section of the LTC
supplement |
Eligibility for each series of questions is determined by
summary variables coded as either "1" (eligible for series) or "0" (ineligible
for series). These summary variables are based on age and responses to
selected questions in the health status section of the household
questionnaire. The nine sections of the LTC questionnaire and associated
summary variables are shown below:
Eligibility Variables for Individual Series |
Activities of Daily Living (ADL) series |
ADLQ = 1 |
Instrumental Activities of Daily Living (IADL)
series |
IADLQ = 1 |
Memory Series |
COGQ = 1 |
Child Series |
CHILDQ = 1 or CHLDLT6Q = 1 or CHLDGE6Q = 1 or
CHLD613Q = 1. The last three variables determine eligibility for
questions based on age < 6, =>6, or 6-13. |
Communication Series |
ADLQ=1 or IADLQ=1 or WHSLIMQ=1
(work/household/school limitations), or SOCLIMQ=1 (social limitations),
or COGQ=1, or HEARQ=1 (hearing limitation), or CHLDLE4Q=1 (child 4
with limitations), or SCHLATTQ=1 (child with school attendance
limitation); and person did not respond for his or herself |
Work Series |
WORKQ = 1 |
Transportation Series |
TRANSAQ = 1; TRANSBQ = 1 |
Assisted Technology Series |
ANYLTCQ = 1 |
General Series |
GENQ = 1 |
Based on the identifiers of eligibility, logical editing
was performed on variables in the LTC supplemental questionnaire. Editing was
fairly minor. It mainly consisted of editing responses to conform to
questionnaire skip patterns and consistency with the eligibility variables.
Several caveats should be noted when using this file:
-
Individuals who were not in the second round of 1998 (Round 4 of
Panel 2 and Round 2 of Panel 3) are not represented in this file. For
example, a person who was eligible for the LTC supplement but died before it
was fielded would not be represented in these data. As a consequence, the
data can only be generalized to individuals who were in the survey at the time
that the LTC questionnaire was asked.
-
A small number of individuals who only had social limitations,
but not other limitations or impairments, did not receive the questions in the
LTC supplement that they were supposed to receive. These individuals can be
identified as having SOCONLY=1.
-
Analysts interested in studying communication, work
accommodations, community services, and use of assisted technology will notice
that some of the individual variables have low usual source of health care
levels (e.g., SERVSCTX). Use of these measures will require analysts to
aggregate the individual items into summary variables.
-
All medical conditions (three-digit ICD-9 codes) associated with
long term care problems and limitations of persons in the LTC supplement have
been added to the LTC file. The medical conditions were abstracted from 1997
and 1998 Medical Conditions files. More information on these conditions can
be obtained by using the encrypted condition code IDs (CONDIX1-17) to link to
the MEPS Medical Conditions files. (See Attachment A: SAS Job for linking
the LTC file with the Conditions file Example.)
-
There are two situations in which persons on the LTC file might have information in the Medical Conditions files even though their
encrypted condition code IDs (CONDIX1-17) have a value of minus 1. The first
situation applies to persons who did not reply to the LTC supplement, or who
did reply but no conditions were linked to the Medical Conditions files as a
result. The second situation applies to persons on the file who did reply to
the LTC supplement and had one or more conditions linking to the Medical
Conditions files. Persons in either of these situations may have conditions
in the Medical Conditions file(s) that are unrelated to their LTC limitations.
Return To Table Of
Contents
D Variable-Source Crosswalk
LONG TERM CARE (LTC) VARIABLES
VARIABLE |
DESCRIPTION |
SOURCE |
DUID |
DWELLING UNIT ID |
ASSIGNED IN SAMPLING |
PID |
PERSON NUMBER |
ASSIGNED IN SAMPLING OR BY CAPI |
DUPERSID |
PERSON ID (DUID+PID) |
ASSIGNED IN SAMPLING |
PANELRN |
PANEL/ROUND INDICATOR FOR LTC
DATA |
CONSTRUCTED |
IADLQ |
ELIGIBLE FOR IADL SERIES |
CONSTRUCTED |
COGQ |
ELIGIBLE FOR MEMORY SERIES |
CONSTRUCTED |
SOCLIMQ |
ELIGIBLE FOR SOCIAL LIMITATIONS
SECTION |
CONSTRUCTED |
FUNCLIMQ |
ELIGIBLE FOR FUNCTIONAL LIMIT
QUESTIONS |
CONSTRUCTED |
AIDLIMQ |
ELIGIBLE FOR AIDS/EQUIP SECTION |
CONSTRUCTED |
SCHOOLQ |
ELIGIBLE FOR SCHOOL LIMITATIONS
SECTION |
CONSTRUCTED |
VISIONQ |
ELIGIBLE FOR VISION SECTION |
CONSTRUCTED |
ADLQ |
ELIGIBLE FOR ADL SERIES |
CONSTRUCTED |
HELPBATX |
EDITED RECEIVE HELP BATHING |
LC01 |
HANDBATX |
ED HANDS ON HELP RECEIVED
BATHING |
LC02 |
INSTBATX |
ED INSTRUCTIONAL HELP RECEIVED
BATHING |
LC02 |
STAYBATX |
ED STAY IN ROOM IN CASE HELP
NEEDED BATH |
LC02 |
HELPDREX |
ED RECEIVE HELP DRESSING |
LC03 |
HANDDRTX |
ED HANDS ON HELP RECEIVED
DRESSING |
LC04 |
INSTDRTX |
ED INSTRUCTIONAL HELP RECEIVED
DRESSING |
LC04 |
STAYDRTX |
ED STAY IN RM IN CASE HELP NEED
DRESSING |
LC04 |
HELPTLTX |
ED RECEIVE HELP TOILETING |
LC05 |
HANDTLTX |
ED HANDS ON HELP RECD USING
TOILET |
LC06 |
INSTTLTX |
ED INSTRUCTIONAL HELP RECD USING
TOILET |
LC06 |
STAYTLTX |
ED STAY IN RM IN CASE HELP
NEEDED TOILET |
LC06 |
HELPBEDX |
ED RECEIVE HELP GETTING OUT OF
BED/CHAIR |
LC07 |
HANDBDTX |
ED HANDS ON HELP TO GET OUT OF
BED/CHAIR |
LC08 |
INSTBDTX |
ED INSTRUCTION/HELP GET OUT OF
BED/CHAIR |
LC08 |
STAYBDTX |
ED STAY IN RM IF HELP NEEDED
BED/CHAIR |
LC08 |
HELPEATX |
ED RECEIVE HELP EATING |
LC09 |
HANDEATX |
ED HANDS ON HELP RECEIVED EATING |
LC10 |
INSTEATX |
ED INSTRUCTINOAL HELP RECEIVED
EATING |
LC10 |
STAYEATX |
ED STAY IN ROOM IN CASE HELP
NEED EAT |
LC10 |
HELPADLX |
ED RECEIVE HELP WITH ANY ADLS >
3 MONS |
LC11 |
HELPSHOX |
ED RECEIVE HELP SHOPPING |
LC12 |
HELPARNX |
ED RECEIVE HELP GETTING AROUND |
LC13 |
HELPMEAX |
ED RECEIVE HELP PREPARING MEALS |
LC14 |
HELPMEDX |
ED RECEIVE HELP TAKING
MEDICATIONS |
LC15 |
HELPMONX |
ED RECEIVE HELP MANAGING MONEY |
LC16 |
HELPLNDX |
ED RECEIVE HELP DOING LAUNDRY |
LC17 |
HELPHSWX |
ED RECEIVE HELP DOING
HOUSEKEEPING |
LC18 |
HELPIADX |
ED RECEIVE HELP WITH ANY IADLS >
3 MONS |
LC19 |
HEARQ |
ELIGIBLE FOR HEARING SECTION |
CONSTRUCTED |
CHLDLE4Q |
ELIGIBLE CHILD <=4 LIMITED
ACTIVIT QUEST |
CONSTRUCTED |
WHSLIMQ |
ELIG WORK/HOUSEHOLD/SCHOOL LIMIT
QUEST |
CONSTRUCTED |
SCHLATTQ |
ELIGIBLE SCHOOL ATTEND LIMITED
SECTION |
CONSTRUCTED |
CHILDQ |
ELIGIBLE FOR CHILD W/ LIMIT
SERIES |
CONSTRUCTED |
CHLDLT6Q |
CHILDQ=1 AND 0<=AGE42X<6 |
CONSTRUCTED |
CHLDGE6Q |
CHILDQ=1 AND AGE42X>=6 |
CONSTRUCTED |
CHLD613Q |
CHILDQ=1 AND 6<=AGE42X<=13 |
CONSTRUCTED |
WORKQ |
ELIGIBLE FOR WORK SERIES |
CONSTRUCTED |
TRANSAQ |
ELIGIBLE FOR LC37/LC38 |
CONSTRUCTED |
TRANSBQ |
ELIGIBLE FOR LC39/LC40 |
CONSTRUCTED |
RATEMEMX |
ED RATE PERSON MEMORY AT PRESENT
TIME |
LC20 |
COMPMEMX |
ED PERS MEMORY COMPARED TO 2 YRS
AGO |
LC21 |
COGPROBX |
ED DELAYS IN COGNITIVE/MENTAL
DEVELOP |
LC22 |
SPCHPRBX |
ED DELAYS IN SPEECH/LANGUAGE
DEVELOP |
LC23 |
SPCDIETX |
ED FOLLOW SPECIAL DIET ORDERED
BY DOC |
LC25 |
CHLDHLPX |
ED NEED HELP EAT/DRESS/BATH/USE
TOILET |
LC26 |
CHLDACTX |
ED DIFF PARTICIPATING STRENUOUS
ACTIVIT |
LC27 |
UNDINSTX |
ED PROB UNDERSTANDING SCHL
INSTRUCTIONS |
LC28 |
PAYATTNX |
ED PROB AT SCHL UNDERSTANDING
INSTR MAT |
LC28 |
PROBCOMX |
ED PROB AT SCHL COMMUNICATING
W/TEACHER |
LC28 |
PROBWLKX |
ED TROUBLE WALKING BLOCKS/CLIMB
STAIRS |
LC29 |
DIFFLANX |
ED DIFFICUL UNDERSTANDING
CONVERSATION |
LC30 |
COMMTLKX |
ED PEOPLE TALK TO COMMUNICATE |
LC31 |
COMMSGNX |
ED PEOPLE USE SIGN LANG TO
COMMUNICATE |
LC31 |
COMMPRWX |
ED PEOPLE USE PRINT/WRITE TO
COMMUNICAT |
LC31 |
COMSYMBX |
ED PEOPLE USE SYMBOL PICTURE TO
COMMUNIC |
LC31 |
COMMGSTX |
ED PEOPLE USE GESTURES TO
COMMUNICATE |
LC31 |
COMMOTHX |
ED PEOPLE USE OTHER WAY TO
COMMUNICATE |
LC31 |
PERSTLKX |
ED DOES PERSON HAVE DIFFICULTY
TALKING |
LC32 |
GESTCOMX |
ED PERSON USES GESTURES TO
COMMUNICATE |
LC33 |
OTHRCOMX |
ED PERSON USES OTHER WAY TO
COMMUNICATE |
LC33 |
PRNTCOMX |
ED PERSON PRINTS OR WRITES TO
COMMUNICAT |
LC33 |
SIGNCOMX |
ED PERSON COMMUNICATE WITH SIGN
LANGUAGE |
LC33 |
SYMBCOMX |
ED PERSON USES SYMBOLS TO
COMMUNICATE |
LC33 |
TALKCOMX |
ED PERSON TALKS TO COMMUNICATE |
LC33 |
CRNTWRKX |
ED IS PERSON CURRENTLY WORKING |
LC34 |
ACOMRMPX |
ED EMPLOYER HAS MADE RAMP TO
ACCOMMODATE |
LC35 |
ACOMELVX |
ED EMPLOYER MADE ELEVATOR TO
ACCOMMODATE |
LC35 |
ACOMDSKX |
ED EMPLOYER HAS MADE RAISED DESK |
LC35 |
ACOMDORX |
ED EMPLOYER HAS MADE DOOR TO
ACCOMMODATE |
LC35 |
ACOMRSTX |
ED EMPLOYER HAS MADE ACCESSIBLE
RESTROOM |
LC35 |
ACOMVSYX |
ED ACCOMMODATE VOICE SYNTHESIZER
DEVICE |
LC35 |
ACOMBRPX |
ED ACCOMMODATE BRAILLE, ENLARGE
PRINT |
LC35 |
ACOMCCHX |
ED ACCOMMODATE JOB COACH |
LC35 |
ACMASISX |
ED ACCOMMODATE PERSONAL
ASSISTANT |
LC35 |
ACOMPNSX |
ED ACCOMMODATE SPECIAL PENS,
PENCILS |
LC35 |
ACOMREDX |
ED ACCOMMODATE JOB REDESIGN,
OPTIONS |
LC35 |
ACOMHRX |
ED ACCOMMODATE MODIFIED WORK
HOURS/DAY |
LC35 |
ACOMEQPX |
ED ACCOMMODATE OTHER EQUIPMENT |
LC35 |
CHNGWRKX |
ED DID PERSON CHANGE THE KIND OF
WORK |
LC36 |
ANYLTCQ |
ELIGIBLE FOR ANY LTC QUESTIONS |
CONSTRUCTED |
GENQ |
ELIGIBLE FOR GENERAL SERIES |
CONSTRUCTED |
PRVNTDRX |
ED PROBLEM PREVENT PERS FROM
DRIVING |
LC37 |
MODVEHX |
ED PERS USES MODIFIED VEHICLE
DRIVE |
LC38 |
STRTLYX |
ED WHEN DID LIMITATIONS
START-YEAR |
LC43 |
STRTLMX |
ED WHEN DID LIMITATIONS
START-MONTH |
LC43 |
SOCONLY |
SOCIAL LIMITATION ONLY |
CONSTRUCTED |
PROVTRAX |
ED FAMILY/FRIENDS PROVIDE
TRANSPORT |
LC39 |
SPECTRAX |
ED RECEIVE OTHER SPECIAL
TRANSPORT |
LC40 |
SPECTECX |
ED USE SPECIAL
EQUIPMENT/TECHNOLOGY |
LC41 |
TECHRAMX |
ED DOES PERSON USE RAILINGS,
RAMPS |
LC42 |
TECHWALX |
ED DOES PERS USE
WALKER,CANE,CRUTCHES |
LC42 |
TECHSHOX |
ED DOES PERSON USE ORTHOPEDIC
SHOES |
LC42 |
TECHBRAX |
ED PERS USE BRACES FOR
ARM,LEG,BACK |
LC42 |
TECHHANX |
ED PERSON USE ARTIFICIAL
ARM,HAND ETC |
LC42 |
TECHRECX |
ED DOES PERSON USE REACHER |
LC42 |
TECHBATX |
ED DOES PERSON USE BATHING AIDS |
LC42 |
TECHTLTX |
ED DOES PERSON USE TOILETING
AIDS |
LC42 |
TECHWHEX |
ED DOES PERSON USE
WHEELCHAIR/SCOOTER |
LC42 |
TECHDREX |
ED DOES PERSON USE DRESSING AIDS |
LC42 |
TECHOXYX |
ED DOES PERS USE OXYGEN OR
RESPIRATOR |
LC42 |
TECHLIFX |
ED DOES PERSON USE LIFT |
LC42 |
TECHDOGX |
ED DOES PERS USE GUIDE DOG
ASSISTANTS |
LC42 |
TECHCOMX |
ED DOES PERS USE COMMUNICATION
EQUIPM |
LC42 |
TECHOTHX |
ED OTH SPECIAL EQUIPMENT OR
TECHNOLOGY |
LC42 |
SERVDCAX |
ED PERSON USES ADULT DAY CARE
SERVICES |
LC46 |
SERVMEAX |
ED PERSON USES MEAL ON WHEELS
SERVICES |
LC46 |
SERVSCTX |
ED PERSON USES SENIOR CENTER
SERVICES |
LC46 |
SERVVOCX |
ED PERS USES VOCATIONAL
REHABILITATION |
LC46 |
SERVSPRX |
ED PERSON USES FAMILY SUPPORT
SERVICES |
LC46 |
SERVTRNX |
ED PERSON USES SPECIAL
TRANSPORTATION |
LC46 |
SERVMGMX |
ED PERSON USES CASE MANAGEMENT |
LC46 |
SERVSHEX |
ED PERSON USES SHELTERED
WORKSHOP |
LC46 |
SERVOTHX |
ED PERSON USES ANY OTHER
SERVICES |
LC46 |
HLPRLAFX |
ED IS THE HELP RELATED TO ARMED
FORCES |
LC47 |
BEF22YRX |
ED LIMITATIONS START BEFORE 22
YR OLD |
LC44 |
CONDIX1 |
ENCRYPTED CONDITION ID 1 - LTC |
LC45 |
CONDIX2 |
ENCRYPTED CONDITION ID 2 - LTC |
LC45 |
CONDIX3 |
ENCRYPTED CONDITION ID 3 - LTC |
LC45 |
CONDIX4 |
ENCRYPTED CONDITION ID 4 - LTC |
LC45 |
CONDIX5 |
ENCRYPTED CONDITION ID 5 - LTC |
LC45 |
CONDIX6 |
ENCRYPTED CONDITION ID 6 - LTC |
LC45 |
CONDIX7 |
ENCRYPTED CONDITION ID 7 - LTC |
LC45 |
CONDIX8 |
ENCRYPTED CONDITION ID 8 - LTC |
LC45 |
CONDIX9 |
ENCRYPTED CONDITION ID 9 - LTC |
LC45 |
CONDIX10 |
ENCRYPTED CONDITION ID 10 - LTC |
LC45 |
CONDIX11 |
ENCRYPTED CONDITION ID 11 - LTC |
LC45 |
CONDIX12 |
ENCRYPTED CONDITION ID 12 - LTC |
LC45 |
CONDIX13 |
ENCRYPTED CONDITION ID 13 - LTC |
LC45 |
CONDIX14 |
ENCRYPTED CONDITION ID 14 - LTC |
LC45 |
CONDIX15 |
ENCRYPTED CONDITION ID 15 - LTC |
LC45 |
CONDIX16 |
ENCRYPTED CONDITION ID 16 - LTC |
LC45 |
CONDIX17 |
ENCRYPTED CONDITION ID 17 - LTC |
LC45 |
icd9cx1 |
ed icd-9 code 1 - LTC |
LC45 |
icd9cx2 |
ed icd-9 code 2 - LTC |
LC45 |
icd9cx3 |
ED ICD-9 CODE 3 - LTC |
LC45 |
ICD9CX4 |
ED ICD-9 CODE 4 - LTC |
LC45 |
ICD9CX5 |
ED ICD-9 CODE 5 - LTC |
LC45 |
ICD9CX6 |
ED ICD-9 CODE 6 - LTC |
LC45 |
ICD9CX7 |
ED ICD-9 CODE 7 - LTC |
LC45 |
ICD9CX8 |
ED ICD-9 CODE 8 - LTC |
LC45 |
ICD9CX9 |
ED ICD-9 CODE 9 - LTC |
LC45 |
ICD9CX10 |
ED ICD-9 CODE 10 - LTC |
LC45 |
ICD9CX11 |
ED ICD-9 CODE 11 -LTC |
LC45 |
ICD9CX12 |
ED ICD-9 CODE 12 - LTC |
LC45 |
ICD9CX13 |
ED ICD-9 CODE 13 - LTC |
LC45 |
ICD9CX14 |
ED ICD-9 CODE 14 - LTC |
LC45 |
ICD9CX15 |
ED ICD-9 CODE 15 - LTC |
LC45 |
ICD9CX16 |
ED ICD-9 CODE 16 - LTC |
LC45 |
ICD9CX17 |
ED ICD-9 CODE 17 - LTC |
LC45 |
BEHVPROX |
ED DELAYS EMOTION/BEHAVIOR
DEVELOP |
LC24 |
NUM_COND |
NUMBER OF CONDITIONS FOR EACH
PERS - LTC |
CONSTRUCTED |
Return To Table Of
Contents
Sample SAS
Codes for Merging the LTC file with the Condition file Example - 1998
/* Sort
the person-condition level file CONDIDS by CONDIDX */
PROC SORT DATA=CONDIDS;
BY
CONDIDX;
RUN;
/* Sort
the condition file COND by CONDIDX */
PROC SORT DATA=COND (KEEP=CONDIDX CCCODEX) OUT=CONDS;
BY
CONDIDX;
RUN;
/* Merge
the CCCODEX codes from the condition file to the person-condition level LTC file
*/
DATA CONDITION (DROP=CONDIDX);
MERGE
CONDIDS (IN=A) CONDS;
BY
CONDIDX;
IF A;
RUN;
/* Convert
the person-condition level LTC file containing the CCCODEX codes of persons
with valid condition IDs back to a person level file and merge it back to the original person
level LTC file */
PROC SORT DATA=CONDITION;
BY
DUPERSID;
RUN;
DATA CONVET (KEEP=DUPERSID CCCODEX1-CCCODEX17);
SET
CONDITION;
BY
DUPERSID;
ARRAY
CCCODEXS(17) $3 CCCODEX1-CCCODEX17;
RETAIN
CCCODEX1-CCCODEX17;
IF
FIRST.DUPERSID THEN
DO;
J = 0;
DO I = 1 TO 17;
CCCODEXS(I) = ' ';
END;
END;
J + 1;
CCCODEXS(J) = CCCODEX;
IF
LAST.DUPERSID;
RUN;
PROC SORT DATA=INOUT.LTC17X OUT=LTC17X;
BY
DUPERSID;
RUN;
DATA INOUT.LTC18X;
MERGE
LTC17X (IN=A) CONVET;
BY
DUPERSID;
IF A;
RUN;
Return To Table Of
Contents
Return to the
MEPS Homepage
|