HC16GSU.TXT File This file contains information and sample SAS programs to create a permanent SAS dataset, for users who want to use SAS in processing the MEPS data provided in this PUF release. There are two ways to create a permanent SAS dataset, using either the SAS transport data file or the ASCII data file supplied in this PUF release. Section A provides a sample SAS program for the first alternative, which is to convert the SAS transport data file to a regular SAS dataset, using the SAS PROCedure: XCOPY. Section B provides a sample SAS program for the second alternative, which is to read data from the ASCII data file, using a SAS DATA step with INFILE, INPUT, and LABEL statements. Section C explains format-related SAS statements that a user may optionally use when working with the SAS dataset. Examples of SAS programs (DATA step or PROC) are provided in all three sections, primarily for the benefit of inexperienced users. Section D contains complete SAS statements that must be used in the programs described in Sections B and C. ****************************************************************************** The sample SAS programs provided in Sections A and B show how to create a permanent SAS dataset from the data file, for the HC16G File 1 data provided in this PUF release. A. A Sample SAS Program for Converting the SAS Transport File to a Permanent SAS Dataset The SAS transport file HC16GF1.SSP was created from a PC-SAS Version 6.12 data file, using PROC COPY. This file has been tested for use with PC-SAS version 6.10 or higher, or with mainframe SAS version 6.08 or higher. This file may work with earlier versions of SAS, although it has not been tested with those versions. Users who are unable to use this SAS Transport file should instead convert the ASCII data file HC16GF1.DAT to a SAS data set as described in Section B. The SAS PROCedure XCOPY will read a SAS transport data file and convert the data to regular SAS format, storing the output in a permanent SAS dataset. This permanent SAS dataset can then be used for all future processing and analyses. Below is a sample PC-SAS program that can be used to convert the SAS transport file to a permanent PC SAS dataset (in a Windows environment, with SAS V6.12). LIBNAME PUFLIB 'C:\MEPS'; FILENAME IN1 'C:\MEPS\HC16GF1.SSP'; PROC XCOPY IN=IN1 OUT=PUFLIB IMPORT; RUN; If the user wants a list of variables and a few sample records in the permanent SAS dataset, following are the SAS statements to accomplish these. PROC CONTENTS DATA=PUFLIB.HC16GF1; TITLE "List of Variables in MEPS HC16G SAS Dataset"; RUN; PROC PRINT DATA=PUFLIB.HC16GF1 (OBS=20); TITLE "First 20 Observations in MEPS HC16G SAS Dataset"; RUN; The LIBNAME statement tells SAS the location (directory name) to store the permanent SAS dataset which is output by PROC XCOPY. The FILENAME statement tells SAS the location (complete directory and file name) of the input SAS transport data file. NOTES: 1) The names used in the LIBNAME and FILENAME statements shown above (i.e., PUFLIB, IN1) are arbitrary; they are only temporary aliases. 2) The directory and file names used in the LIBNAME and FILENAME statements shown above are Windows syntax and may need to be modified for other operating systems such as UNIX, MAC/OS, VMS, or OS/2. 3) HC16G is the internal SAS dataset name (also the PC file name, without the extension) prior to the creation of the SAS transport data file. After running PROC XCOPY, the output SAS dataset assumes the same dataset name (or file name). Hence, in the example above, a file named HC16GF1.SD2 will be created under the C:\MEPS directory when PROC XCOPY runs successfully. B. A Sample SAS Program for Converting the ASCII Data File to a Permanent SAS Dataset The complete SAS statements (INPUT and LABEL) included in Section D are intended to save time for those users wishing to create a permanent SAS dataset from the HC16GF1.DAT ASCII data file. These statements must be used in combination with other SAS statements to create the appropriate SAS program, as shown below. To use the statements provided in Section D to create a SAS program, you will need an ASCII text editor. If you are using an interactive form of SAS (Windows, UNIX, OS2, etc.), use the editor provided as part of the SAS software. Following is a sample SAS program that will convert the ASCII data file to SAS format. LIBNAME PUFLIB 'C:\MEPS'; FILENAME IN1 'C:\MEPS\HC16GF1.DAT'; DATA PUFLIB.HC16GF1; INFILE IN1 LRECL=280; INPUT .....; * to user: insert the complete INPUT statement that is provided in Section D; LABEL .....; * to user: insert the complete LABEL statement that is provided in Section D; RUN; Here is an explanation of the SAS statements used in the program above. LIBNAME statement: This tells SAS the location (directory name) of the permanent SAS dataset. FILENAME statement: This tells SAS the location of the input ASCII data file. DATA statement: This signifies the beginning of a SAS DATA step and specifies describes the output SAS dataset, referencing the LIBNAME entry (PUFLIB) and assigning an internal SAS dataset name (HC16GF1). In the example, after the successful completion of the DATA step, a PC file named HC16GF1.SD2 would have been created in the C:\MEPS directory. INFILE statement: This tells SAS the location (directory and file name) of the input ASCII data file. Also provided is the logical record length, with the default of RECFM=V implied when this parameter is omitted. LRECL and RECFM are optional parameters in the INFILE statement. With regard to these options, please note the following: the ASCII data file HC16GF1.DAT contains a 2-byte carriage return/line feed at the end of each record. When converting to a PC-SAS file, the LRECL option should be used to specify the record length to avoid use of a default record length by PC-SAS. If the RECFM=V option is used, the LRECL option must be specified as the logical record length. If RECFM=F is used, then the LRECL value must be specified as the logical record length plus 2. Note that if the RECFM option is omitted, then the default option of RECFM=V is automatically used, and LRECL should be specified as the logical record. INPUT statement: This specifies the input record layout, giving names and the beginning and ending column positions for data items (which become SAS variables) in the ASCII data file (HC16GF1.DAT). Variable type (numeric or character) is also defined via the INPUT statement. LABEL statement: This associates descriptive names with the SAS variables. RUN statement: This tells SAS to execute all commands up to this point. C. Optional Format-related SAS Statements If a user wants to use formats for the SAS variables, a SAS format library must first be created. Below is a SAS program that will accomplish this. LIBNAME PUFLIB 'C:\MEPS'; PROC FORMAT LIBRARY=PUFLIB; VALUE .....; * to user: insert the complete set of VALUE statements found in Section D; VALUE .....; .......... ; RUN; Below is an example of how to use the SAS formats defined by the PROC FORMAT procedure. LIBNAME PUFLIB 'C:\MEPS'; OPTIONS FMTSEARCH=(PUFLIB); PROC FREQ DATA=PUFLIB.HC16GF1; TABLES .... / LIST MISSING; FORMAT varnam1 fmtnam1. Varnam2 fmtnam2. .... ; * to user: substitute varnami and fmtnami with actual variable names and format names; * Insert the FORMAT statement provided in Section D, if you are using all the variables; * in the TABLES statement; TITLE "Frequency Distributions ...."; RUN; Here is an explanation of the SAS statements used above. LIBNAME statement: This tells SAS the location (directory name) of the SAS format library. Please note that SAS datasets (file name extension is 'SD2') and format libraries (file name extension is 'SC2') can be stored under the same directory. OPTIONS FMTSEARCH=...: This specifies the SAS format library. PROC FORMAT statement: This identifies the SAS procedure that will make SAS formats according to VALUE statements. Formats will be stored in a file named FORMATS.SC2. Please note that the option 'LIBRARY=...' can be omitted, if the user does not want to create a permanent SAS format library. When simply 'PROC FORMAT;' is used, the formats are defined only for the duration of the batch SAS program or an interactive SAS session. VALUE statement: This gives a) names to formats; and b) descriptive labels for individual values, or range of values. The format names can then be invoked using a FORMAT statement, if desired. PROC FREQ statement: This identifies the SAS procedure that will generate frequency distributions of variables specified in the TABLES statement, formatted if a FORMAT statement is used. The input SAS dataset is specified in the 'DATA=' option. FORMAT statement: This associates existing formats with variables. When using this statement, the formats must have already been created with a PROC FORMAT procedure. RUN statement: This tells SAS to execute all commands up to this point. NOTES: 1) Use of formats is entirely optional, and depends on the type of analyses that you are doing. It is recommended that you create and use them as appropriate. 2) The names used in the LIBNAME and FILENAME statements shown above (i.e., PUFLIB, IN1) are arbitrary; they are only temporary aliases. 3) You only create the permanent SAS data set once. Additional analyses can be run using this permanent dataset. 4) The file and directory specifications in the LIBNAME and FILENAME statements are Windows syntax and may need to be modified for other operating systems such as UNIX, MAC/OS, VMS, or OS/2. D. SAS Statements This section contains SAS INPUT, LABEL, FORMAT and VALUE statements for use in converting each of the HC16G ASCII data files into a SAS data set, and creating a SAS format library. *INPUT, LABEL, FORMAT AND VALUE STATEMENTS FOR HC16G FILE 1; * INPUT STATEMENTS; INFILE IN LRECL= 280; INPUT @1 DUID 5.0 @6 PID 3.0 @9 DUPERSID $8.0 @17 EVNTIDX $12.0 @29 EVENTRN 1.0 @30 FFEEIDX $12.0 @42 MPCELIG 1.0 @43 MPCDATA 1.0 @44 OBDATEYR 4.0 @48 OBDATEMM 2.0 @50 OBDATEDD 2.0 @52 SEETLKPV 2.0 @54 REFERDBY 2.0 @56 SEEDOC 2.0 @58 MEDPTYPE 2.0 @60 TIMESPNT 2.0 @62 DOCATLOC 2.0 @64 VSTCTGRY 2.0 @66 VSTRELCN 2.0 @68 PHYSTH 2.0 @70 OCCUPTH 2.0 @72 SPEECHTH 2.0 @74 CHEMOTH 2.0 @76 RADIATTH 2.0 @78 KIDNEYD 2.0 @80 IVTHER 2.0 @82 DRUGTRT 2.0 @84 RCVSHOT 2.0 @86 PSYCHOTH 2.0 @88 LABTEST 2.0 @90 SONOGRAM 2.0 @92 XRAYS 2.0 @94 MAMMOG 2.0 @96 MRI 2.0 @98 EKG 2.0 @100 EEG 2.0 @102 RCVVAC 2.0 @104 ANESTH 2.0 @106 OTHSVCE 2.0 @108 SURGPROC 2.0 @110 SURGNAME 2.0 @112 MEDPRESC 2.0 @114 VAPLACE 1.0 @115 OBICD1X $3.0 @118 OBICD2X $3.0 @121 OBICD3X $3.0 @124 OBICD4X $3.0 @127 OBPRO1X $2.0 @129 OBCCC1X $3.0 @132 OBCCC2X $3.0 @135 OBCCC3X $3.0 @138 OBCCC4X $3.0 @141 NUMCOND 2.0 @143 FFOBTYPE 2.0 @145 FFBEF97 2.0 @147 FFTOT98 2.0 @149 OBSF97X 7.2 @156 OBMR97X 8.2 @164 OBMD97X 7.2 @171 OBPV97X 8.2 @179 OBVA97X 7.2 @186 OBCH97X 8.2 @194 OBOF97X 7.2 @201 OBSL97X 7.2 @208 OBWC97X 7.2 @215 OBOR97X 7.2 @222 OBOU97X 6.2 @228 OBOT97X 7.2 @235 OBXP97X 8.2 @243 OBTC97X 8.2 @251 IMPOBSLF 1.0 @252 IMPOBMCR 1.0 @253 IMPOBMCD 1.0 @254 IMPOBPRV 1.0 @255 IMPOBVA 1.0 @256 IMPOBCHM 1.0 @257 IMPOBOFD 1.0 @258 IMPOBSTL 1.0 @259 IMPOBWCP 1.0 @260 IMPOBOPR 1.0 @261 IMPOBOPU 1.0 @262 IMPOBOTH 1.0 @263 IMPOBCHG 1.0 @264 WTDPER97 12.6 @276 VARPSU97 2.0 @278 VARSTR97 3.0 ; * FORMAT STATEMENTS; FORMAT DUID ID. PID ID. DUPERSID $ID. EVNTIDX $ID. EVENTRN EVENTRN. FFEEIDX $ID. MPCELIG MPCELIG. MPCDATA MPCDATA. OBDATEYR OBDATEYR. OBDATEMM OBDATEMM. OBDATEDD OBDATEDD. SEETLKPV SEETLKPV. REFERDBY YESNO. SEEDOC YESNO. MEDPTYPE MEDPTYPE. TIMESPNT TIMESPNT. DOCATLOC YESNO. VSTCTGRY VSTCTGRY. VSTRELCN SERVICE. PHYSTH TREAT. OCCUPTH TREAT. SPEECHTH TREAT. CHEMOTH TREAT. RADIATTH TREAT. KIDNEYD TREAT. IVTHER TREAT. DRUGTRT TREAT. RCVSHOT TREAT. PSYCHOTH TREAT. LABTEST SERVICE. SONOGRAM SERVICE. XRAYS SERVICE. MAMMOG SERVICE. MRI SERVICE. EKG SERVICE. EEG SERVICE. RCVVAC SERVICE. ANESTH SERVICE. OTHSVCE SERVICE. SURGPROC SERVICE. SURGNAME SURGNAME. MEDPRESC YESNO. VAPLACE YESNO. OBICD1X $OBICD. OBICD2X $OBICD. OBICD3X $OBICD. OBICD4X $OBICD. OBPRO1X $OBPRO. OBCCC1X $OBCCC. OBCCC2X $OBCCC. OBCCC3X $OBCCC. OBCCC4X $OBCCC. NUMCOND NUMCOND. FFOBTYPE FFOBTYPE. FFBEF97 FFBEF9G. FFTOT98 FFTOT9H. OBSF97X OBSF97X. OBMR97X OBMR97X. OBMD97X OBMD97X. OBPV97X OBPV97X. OBVA97X OBVA97X. OBCH97X OBCH97X. OBOF97X OBOF97X. OBSL97X OBSL97X. OBWC97X OBWC97X. OBOR97X OBOR97X. OBOU97X OBOU97X. OBOT97X OBOT97X. OBXP97X OBXP97X. OBTC97X OBTC97X. IMPOBSLF IMPYN. IMPOBMCR IMPYN. IMPOBMCD IMPYN. IMPOBPRV IMPYN. IMPOBVA IMPYN. IMPOBCHM IMPYN. IMPOBOFD IMPYN. IMPOBSTL IMPYN. IMPOBWCP IMPYN. IMPOBOPR IMPYN. IMPOBOPU IMPYN. IMPOBOTH IMPYN. IMPOBCHG IMPOBCHG. WTDPER97 WTDPER. VARPSU97 VARPSU. VARSTR97 VARSTR. ; * LABEL STATEMENTS; LABEL DUID ='DWELLING UNIT ID' PID ='PERSON NUMBER' DUPERSID='PERSON ID (DUID+PID)' EVNTIDX ='EVENT ID' EVENTRN ='EVENT ROUND NUMBER' FFEEIDX ='FLAT FEE ID' MPCELIG ='MPC ELIGIBILITY FLAG' MPCDATA ='MPC DATA FLAG' OBDATEYR='EVENT DATE - YEAR' OBDATEMM='EVENT DATE - MONTH' OBDATEDD='EVENT DATE - DAY' SEETLKPV='DID P VISIT PROV IN PERSON OR TELEPHONE' REFERDBY='REFERRED BY ANOTHER PHYSICIAN' SEEDOC ='TALK TO MD THIS VISIT/PHONE CALL' MEDPTYPE='TYPE OF MED PERSON P TALKED TO ON VST DT' TIMESPNT='TIME SPENT WITH DOCTOR/MEDICAL PERSON' DOCATLOC='ANY MD WORK AT LOCATION WHERE P SAW PROV' VSTCTGRY='BEST CATEGORY FOR CARE P HAVE ON VST DT' VSTRELCN='VISIT/PHONE CALL RELATED TO CONDITION' PHYSTH ='THIS VISIT DID P HAVE PHYSICAL THERAPY' OCCUPTH ='DID P HAVE OCCUPATIONAL THERAPY' SPEECHTH='THIS VISIT DID P HAVE SPEECH THERAPY' CHEMOTH ='THIS VISIT DID P HAVE CHEMOTHERAPY' RADIATTH='THIS VISIT DID P HAVE RADIATION THERAPY' KIDNEYD ='THIS VISIT DID P HAVE KIDNEY DIALYSIS' IVTHER ='THIS VISIT DID P HAVE IV THERAPY' DRUGTRT ='TREATMENT FOR DRUG OR ALCOHOL' RCVSHOT ='THIS VISIT DID P RECEIVE ALLERGY SHOT' PSYCHOTH='DID P HAVE PSYCHOTHERAPY/COUNSELING' LABTEST ='THIS VISIST DID P HAVE LAB TEST' SONOGRAM='DID P HAVE SONOGRAM OR ULTRASOUND' XRAYS ='THIS VISIT DID P HAVE X-RAYS' MAMMOG ='THIS VISIT DID P HAVE A MAMMOGRAM' MRI ='THIS VISIT DID P HAVE AN MRI/CATSCAN' EKG ='THIS VISIT DID P HAVE AN EKG OR ECG' EEG ='THIS VISIT DID P HAVE A EEG' RCVVAC ='THIS VISIT DID P RECEIVE VACCINATION' ANESTH ='THIS VISIT DID P RECEIVE ANESTHESIA' OTHSVCE ='OTHER DIAGNOSTIC TESTS/EXAMS' SURGPROC='WAS SURGICAL PROCEDURE PERFORMED ON P' SURGNAME='SURGICAL PROCEDURE NAME IN CATEGORIES' MEDPRESC='ANY MEDICINE PRESCRIBED FOR P THIS VISIT' VAPLACE ='VA FACILITY FLAG' OBICD1X ='3 DIGIT ICD-9 CONDITION CODE' OBICD2X ='3 DIGIT ICD-9 CONDITION CODE' OBICD3X ='3 DIGIT ICD-9 CONDITION CODE' OBICD4X ='3 DIGIT ICD-9 CONDITION CODE' OBPRO1X ='2 DIGIT ICD-9 PROCEDURE CODE' OBCCC1X ='MODIFIED CLINICAL CLASSIFICATION CODE' OBCCC2X ='MODIFIED CLINICAL CLASSIFICATION CODE' OBCCC3X ='MODIFIED CLINICAL CLASSIFICATION CODE' OBCCC4X ='MODIFIED CLINICAL CLASSIFICATION CODE' NUMCOND ='TOTAL # COND RECORDS LINKED TO THIS EVNT' FFOBTYPE='FLAT FEE BUNDLE' FFBEF97 ='TOTAL # OF VISITS IN FF BEFORE 1997' FFTOT98 ='TOTAL # OF VISITS IN FF AFTER 1997' OBSF97X ='AMOUNT PAID, FAMILY (IMPUTED)' OBMR97X ='AMOUNT PAID, MEDICARE (IMPUTED)' OBMD97X ='AMOUNT PAID, MEDICAID (IMPUTED)' OBPV97X ='AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)' OBVA97X ='AMOUNT PAID, VETERANS (IMPUTED)' OBCH97X ='AMOUNT PAID, CHAMPUS/CHAMPVA (IMPUTED)' OBOF97X ='AMOUNT PAID, OTHER FEDERAL (IMPUTED)' OBSL97X ='AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)' OBWC97X ='AMOUNT PAID, WORKERS COMP (IMPUTED)' OBOR97X ='AMOUNT PAID, OTHER PRIVATE (IMPUTED)' OBOU97X ='AMOUNT PAID, OTHER PUBLIC (IMPUTED)' OBOT97X ='AMOUNT PAID, OTHER INSURANCE (IMPUTED)' OBXP97X ='SUM OF OBSF97X-OBOT97X (IMPUTED)' OBTC97X ='HHLD REPORTED TOTAL CHARGE (IMPUTED)' IMPOBSLF='IMPUTATION FLAG FOR OBSF97X' IMPOBMCR='IMPUTATION FLAG FOR OBMR97X' IMPOBMCD='IMPUTATION FLAG FOR OBMD97X' IMPOBPRV='IMPUTATION FLAG FOR OBPV97X' IMPOBVA ='IMPUTATION FLAG FOR OBVA97X' IMPOBCHM='IMPUTATION FLAG FOR OBCH97X' IMPOBOFD='IMPUTATION FLAG FOR OBOF97X' IMPOBSTL='IMPUTATION FLAG FOR OBSL97X' IMPOBWCP='IMPUTATION FLAG FOR OBWC97X' IMPOBOPR='IMPUTATION STATUS OF OBOR97X' IMPOBOPU='IMPUTATION STATUS OF OBOU97X' IMPOBOTH='IMPUTATION FLAG FOR OBOT97X' IMPOBCHG='IMPUTATION STATUS OF OBTC97X' WTDPER97='POVERTY/MORTALITY ADJ PERS LEVL WGT,1997' VARPSU97='VARIANCE ESTIMATION PSU,1997' VARSTR97='VARIANCE ESTIMATION STRATUM,1997' ; * VALUE STATEMENTS; VALUE EVENTRN 1 = '1' 2 = '2' 3 = '3' 4 = '4' 5 = '5' ; VALUE FFBEF9G -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 0 = '0' 1 - 26 = '1 - 26' ; VALUE FFOBTYPE -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 1 = '1 FLAT FEE STEM' 2 = '2 FLAT FEE LEAF' ; VALUE FFTOT9H -9 = '-9 NOT ASCERTAINED' -1 = '-1 INAPPLICABLE' 0 = '0' 1 - 13 = '1 - 13' ; VALUE ID -1='-1' 1-HIGH='VALID ID' ; VALUE $ID ' '='BLANK' '-1'='-1' '0'-'z'='VALID ID' ; VALUE IMPOBCHG -1 = '-1 INAPPLICABLE' 0 = '0 UNIMPUTED TLCHRG' 1 = "1 FAC IMP DONOR'S TLCHRG" 2 = '2 IMPUTED TLCHRG' 3 = '3 BOTH-RECIPIENTS AND DONORS' ; VALUE IMPYN -1 = '-1 INAPPLICABLE' 0 = '0 UNIMPUTED' 1 = '1 IMPUTED' ; VALUE MEDPTYPE -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 1 = '1 CHIROPRACTOR' 2 = '2 DENTIST/DENTAL CARE PERSON' 3 = '3 MIDWIFE' 4 = '4 NURSE/NURSE PRACTITIONER' 5 = '5 OPTOMETRIST' 6 = '6 PODIATRIST' 7 = "7 PHYSICIAN'S ASSISTANT" 8 = '8 PHYSICAL THERAPIST' 9 = '9 OCCUPATIONAL THERAPIST' 10 = '10 PSYCHOLOGIST' 11 = '11 SOCIAL WORKER' 12 = '12 TECHNICIAN' 13 = '13 RECEPTIONIST/CLERK/SECRETARY' 91 = '91 OTHER' ; VALUE MPCDATA 1 = '1 HAS MPC DATA' 2 = '2 NO MPC DATA' ; VALUE MPCELIG 1 = '1 MPC ELIGIBLE' 2 = '2 NOT MPC ELIGIBLE' ; VALUE NUMCOND 0 = '0' 1 - 4 = '1-4' 5 = '5' 6 = '6' 7 = '7' 8 = '8' 9 = '9' 10 = '10' 11 = '11' 12 = '12' 13 = '13' 14 = '14' 15 = '15' 16 = '16' 17 = '17' 18 = '18' 19 = '19' 20 = '20' 21 = '21' 22 = '22' 23 = '23' ; VALUE $OBCCC '-1' = '-1 INAPPLICABLE' '-7' = '-7 REFUSED' '-8' = '-8 DK' '-9' = '-9 NOT ASCERTAINED' '001' - '259' = '001-259' ; VALUE OBCH97X -9 = '-9 NOT ASCERTAINED' 0 = '0' 1.62 - 13 = '$1.62 - $13.00' 13 < - 30 = '$13.01 - $30.00' 30 < - 55 = '$30.01 - $55.00' 55 < - 10956 = '$55.01 - $10956.00' ; VALUE OBDATEDD -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 1 - 31 = '1 - 31' ; VALUE OBDATEMM -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 1 - 12 = '1 - 12' ; VALUE OBDATEYR -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 1997 = '1997' ; VALUE $OBICD '-1' = '-1 INAPPLICABLE' '-8' = '-8 DK' '-9' = '-9 NOT ASCERTAINED' '001' - '139' = '001-139' '140' - '239' = '140-239' '240' - '279' = '240-279' '280' - '289' = '280-289' '290' - '319' = '290-319' '320' - '389' = '320-389' '390' - '459' = '390-459' '460' - '519' = '460-519' '520' - '579' = '520-579' '580' - '629' = '580-629' '630' - '677' = '630-677' '680' - '709' = '680-709' '710' - '739' = '710-739' '740' - '759' = '740-759' '760' - '779' = '760-779' '780' - '799' = '780-799' '800' - '999' = '800-999' 'V00' - 'V99' = 'V00-V99' ; VALUE OBMD97X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.06 - 20.7 = '$0.06 - $20.70' 20.7 < - 37.09 = '$20.71 - $37.09' 37.09 < - 61.46 = '$37.10 - $61.46' 61.46 < - 7342 = '$61.47 - $7342.00' ; VALUE OBMR97X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.04 - 22 = '$0.04 - $22.00' 22 < - 33.74 = '$22.01 - $33.74' 33.74 < - 59.79 = '$33.75 - $59.79' 59.79 < - 15143.26 = '$59.80 - $15143.26' ; VALUE OBOF97X -9 = '-9 NOT ASCERTAINED' 0 = '0' 1 - 27.5 = '$1.00 - $27.50' 27.5 < - 49.145 = '$27.51 - $49.15' 49.145 < - 97 = '$49.16 - $97.00' 97 < - 3050.35 = '$97.01 - $3050.35' ; VALUE OBOR97X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.2 - 12.015 = '$0.20 - $12.02' 12.015 < - 30.66 = '$12.03 - $30.66' 30.66 < - 60 = '$30.67 - $60.00' 60 < - 4799 = '$60.01 - $4799.00' ; VALUE OBOT97X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.08 - 21.7 = '$0.08 - $21.70' 21.7 < - 42.51 = '$21.71 - $42.51' 42.51 < - 80 = '$42.52 - $80.00' 80 < - 3500 = '$80.01 - $3500.00' ; VALUE OBOU97X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.64 - 20 = '$0.64 - $20.00' 20 < - 40 = '$20.01 - $40.00' 40 < - 75 = '$40.01 - $75.00' 75 < - 660.55 = '$75.01 - $660.55' ; VALUE $OBPRO '-1' = '-1 INAPPLICABLE' '-9' = '-9 NOT ASCERTAINED' '01' - '05' = '01-05' '06' - '07' = '06-07' '08' - '16' = '08-16' '18' - '20' = '18-20' '21' - '29' = '21-29' '30' - '34' = '30-34' '35' - '39' = '35-39' '40' - '41' = '40-41' '42' - '54' = '42-54' '55' - '59' = '55-59' '60' - '64' = '60-64' '65' - '71' = '65-71' '72' - '75' = '72-75' '76' - '84' = '76-84' '85' - '86' = '85-86' '87' - '99' = '87-99' ; VALUE OBPV97X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.03 - 21.39 = '$0.03 - $21.39' 21.39 < - 38 = '$21.40 - $38.00' 38 < - 67 = '$38.01 - $67.00' 67 < - 24351.99 = '$67.01 - $24351.99' ; VALUE OBSF97X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.11 - 9 = '$0.11 - $9.00' 9 < - 13 = '$9.01 - $13.00' 13 < - 36 = '$13.01 - $36.00' 36 < - 9000 = '$36.01 - $9000.00' ; VALUE OBSL97X -9 = '-9 NOT ASCERTAINED' 0 = '0' 2 - 23 = '$2.00 - $23.00' 23 < - 34.48 = '$23.01 - $34.48' 34.48 < - 60 = '$34.49 - $60.00' 60 < - 2200 = '$60.01 - $2200.00' ; VALUE OBTC97X -9 = '-9 NOT ASCERTAINED' 0 = '0' 1 - 40 = '$1.00 - $40.00' 40 < - 60.78 = '$40.01 - $60.78' 60.78 < - 108 = '$60.79 - $108.00' 108 < - 58322 = '$108.01 - $58322.00' ; VALUE OBVA97X -9 = '-9 NOT ASCERTAINED' 0 = '0' 1.33 - 26 = '$1.33 - $26.00' 26 < - 50 = '$26.01 - $50.00' 50 < - 97 = '$50.01 - $97.00' 97 < - 4825.23 = '$97.01 - $4825.23' ; VALUE OBWC97X -9 = '-9 NOT ASCERTAINED' 0 = '0' 1 - 40 = '$1.00 - $40.00' 40 < - 69.56 = '$40.01 - $69.56' 69.56 < - 111.32 = '$69.57 - $111.32' 111.32 < - 3098.25 = '$111.33 - $3098.25' ; VALUE OBXP97X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.62 - 30.86 = '$0.62 - $30.86' 30.86 < - 47.32 = '$30.87 - $47.32' 47.32 < - 81 = '$47.33 - $81.00' 81 < - 39495.25 = '$81.01 - $39495.25' ; VALUE SEETLKPV -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 1 = '1 SAW PROVIDER' 2 = '2 TELEPHONE CALL' ; VALUE SERVICE -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 1 = '1 YES' 2 = '2 NO' 95 = '95 NO SERVICES RECEIVED' ; VALUE SURGNAME -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 1 = '1 ARTHROSCOPIC SURGERY' 2 = '2 CLEANING/TREATM WOUND, INFECTION' 3 = '3 REMOVAL OF DISEASED TISSUE (EXCISION)' 4 = '4 STITCHES (WOUND SUTURE)' 5 = '5 EAR TUBES (TYMPANOSTOMY TUBES)' 91 = '91 OTHER SURGICAL PROCEDURE' ; VALUE TIMESPNT -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 1 = '1 5 MINUTES OR LESS' 2 = '2 6-10 MINUTES' 3 = '3 11-15 MINUTES' 4 = '4 16-25 MINUTES' 5 = '5 26-40 MINUTES' 6 = '6 41 MINUTES OR MORE' ; VALUE TREAT -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 1 = '1 YES' 2 = '2 NO' 95 = '95 NO TREATMENT RECEIVED' ; VALUE VARPSU 1 - 34 = '1 - 34' ; VALUE VARSTR 1 - 254 = '1 - 254' ; VALUE VSTCTGRY -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 1 = '1 GENERAL CHECKUP' 2 = '2 DIAGNOSIS OR TREATMENT' 3 = '3 EMERGENCY (E.G.,ACCIDENT OR INJURY)' 4 = '4 PSYCHOTHERAPY OR MENTAL HEALTH COUNSELING' 5 = '5 FOLLOW-UP OR POST-OPERATIVE VISIT' 6 = '6 IMMUNIZATIONS OR SHOTS' 7 = '7 VISION EXAM' 8 = '8 MATERNITY CARE (PRE/POSTNATAL)' 9 = '9 WELL CHILD EXAM' 91 = '91 OTHER' ; VALUE WTDPER 0 = '0' 299.337534 - 66983.924524 = '299.337534 - 66983.924524' ; VALUE YESNO -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 0 = '0 NO' 1 = '1 YES' 2 = '2 NO' ; *INPUT, LABEL, FORMAT AND VALUE STATEMENTS FOR HC16G FILE 2; * INPUT STATEMENTS; INFILE IN LRECL= 212; INPUT @1 DUID 5.0 @6 PID 3.0 @9 DUPERSID $8.0 @17 EVNTIDX $12.0 @29 HHSFFIDX $10.0 @39 OBSF97H 8.2 @47 OBMR97H 7.2 @54 OBMD97H 6.2 @60 OBPV97H 8.2 @68 OBVA97H 5.2 @73 OBCH97H 8.2 @81 OBOF97H 6.2 @87 OBSL97H 7.2 @94 OBWC97H 7.2 @101 OBOT97H 7.2 @108 OBUC97H 7.2 @115 OBTC97H 8.2 @123 OBSF97M 7.2 @130 OBMR97M 7.2 @137 OBMD97M 7.2 @144 OBPV97M 7.2 @151 OBVA97M 5.2 @156 OBCH97M 6.2 @162 OBOF97M 6.2 @168 OBSL97M 6.2 @174 OBWC97M 7.2 @181 OBOT97M 7.2 @188 OBTC97M 8.2 @196 WTDPER97 12.6 @208 VARPSU97 2.0 @210 VARSTR97 3.0 ; * FORMAT STATEMENTS; FORMAT DUID ID. PID ID. DUPERSID $ID. EVNTIDX $ID. HHSFFIDX $ID. OBSF97H OBSF97H. OBMR97H OBMR97H. OBMD97H OBMD97H. OBPV97H OBPV97H. OBVA97H OBVA97H. OBCH97H OBCH97H. OBOF97H OBOF97H. OBSL97H OBSL97H. OBWC97H OBWC97H. OBOT97H OBOT97H. OBUC97H OBUC97H. OBTC97H OBTC97H. OBSF97M OBSF97M. OBMR97M OBMR97M. OBMD97M OBMD97M. OBPV97M OBPV97M. OBVA97M OBVA97M. OBCH97M OBCH97M. OBOF97M OBOF97M. OBSL97M OBSL97M. OBWC97M OBWC97M. OBOT97M OBOT97M. OBTC97M OBTC97M. WTDPER97 WTDPER. VARPSU97 VARPSU. VARSTR97 VARSTR. ; * LABEL STATEMENTS; LABEL DUID ='DWELLING UNIT ID' PID ='PERSON NUMBER' DUPERSID='PERSON ID (DUID+PID)' EVNTIDX ='EVENT ID' HHSFFIDX='HOUSEHOLD REPORTD FLAT FEE ID(UNEDITED)' OBSF97H ='HHLD RPTD AMT PD, FAMILY (PRE-IMPUTED)' OBMR97H ='HHLD RPTD AMT PD, MEDICARE (PRE-IMPUTED)' OBMD97H ='HHLD RPTD AMT PD, MEDICAID (PRE-IMPUTED)' OBPV97H ='HHLD RPTD AMT PD, PRIV INS (PRE-IMPUTED)' OBVA97H ='HHLD RPTD AMT PD, VETERANS (PRE-IMPUTED)' OBCH97H ='HHLD RPTD AMT PD,CHMP/CHPVA(PRE-IMPUTED)' OBOF97H ='HHLD RPTD AMT PD, OTHER FED(PRE-IMPUTED)' OBSL97H ='HHLD RPTD AMT PD, STATE&LOC(PRE-IMPUTED)' OBWC97H ='HHLD RPTD AMT PD, WORK COMP(PRE-IMPUTED)' OBOT97H ='HHLD RPTD AMT PD, OTH INSUR(PRE-IMPUTED)' OBUC97H ='HHLD RPTD AMT PD,UNCOL LIAB(PRE-IMPUTED)' OBTC97H ='HHLD REPORTED TOTAL CHARGE (PRE-IMPUTED)' OBSF97M ='MPC RPTD AMT PD, FAMILY (UN-IMPUTED)' OBMR97M ='MPC RPTD AMT PD, MEDICARE (UN-IMPUTED)' OBMD97M ='MPC RPTD AMT PD, MEDICAID (UN-IMPUTED)' OBPV97M ='MPC RPTD AMT PD, PRIV INS (UN-IMPUTED)' OBVA97M ='MPC RPTD AMT PD, VETERANS (UN-IMPUTED)' OBCH97M ='MPC RPTD AMT PD, CHMP/CHMPVA(UN-IMPUTED)' OBOF97M ='MPC RPTD AMT PD, OTHER FED (UN-IMPUTED)' OBSL97M ='MPC RPTD AMT PD, STATE&LOC (UN-IMPUTED)' OBWC97M ='MPC RPTD AMT PD, WORK COMP (UN-IMPUTED)' OBOT97M ='MPC RPTD AMT PD, OTH INSUR (UN-IMPUTED)' OBTC97M ='MPC REPORTED TOTAL CHARGE (UN-IMPUTED)' WTDPER97='POVERTY/MORTALITY ADJ PERS LEVL WGT,1997' VARPSU97='VARIANCE ESTIMATION PSU,1997' VARSTR97='VARIANCE ESTIMATION STRATUM,1997' ; * VALUE STATEMENTS; VALUE ID -1='-1' 1-HIGH='VALID ID' ; VALUE $ID ' '='BLANK' '-1'='-1' '0'-'z'='VALID ID' ; VALUE OBCH97H -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 3 - 12 = '$3.00 - $12.00' 12 < - 26 = '$12.01 - $26.00' 26 < - 48 = '$26.01 - $48.00' 48 < - 12352 = '$48.01 - $12352.00' ; VALUE OBCH97M -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 6 - 16.24 = '$6.00 - $16.24' 16.24 < - 28.35 = '$16.25 - $28.35' 28.35 < - 49.48 = '$28.36 - $49.48' 49.48 < - 164.08 = '$49.49 - $164.08' ; VALUE OBMD97H -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 100 = '$100.00' ; VALUE OBMD97M -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 0.06 - 19.35 = '$0.06 - $19.35' 19.35 < - 34.48 = '$19.36 - $34.48' 34.48 < - 65 = '$34.49 - $65.00' 65 < - 3709 = '$65.01 - $3709.00' ; VALUE OBMR97H -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 1 - 25 = '$1.00 - $25.00' 25 < - 37 = '$25.01 - $37.00' 37 < - 66 = '$37.01 - $66.00' 66 < - 9039 = '$66.01 - $9039.00' ; VALUE OBMR97M -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 0.54 - 26.94 = '$0.54 - $26.94' 26.94 < - 37 = '$26.95 - $37.00' 37 < - 69.47 = '$37.01 - $69.47' 69.47 < - 2398.52 = '$69.48 - $2398.52' ; VALUE OBOF97H -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 3 = '$3.00' 3 < - 16 = '$3.01 - $16.00' 16 < - 100 = '$16.01 - $100.00' 100 < - 300 = '$100.01 - $300.00' ; VALUE OBOF97M -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 11.1 - 27.67 = '$11.10 - $27.67' 27.67 < - 45 = '$27.68 - $45.00' 45 < - 73.76 = '$45.01 - $73.76' 73.76 < - 264 = '$73.77 - $264.00' ; VALUE OBOT97H -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 1 - 25 = '$1.00 - $25.00' 25 < - 51 = '$25.01 - $51.00' 51 < - 90 = '$51.01 - $90.00' 90 < - 3900 = '$90.01 - $3900.00' ; VALUE OBOT97M -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 2.16 - 28.62 = '$2.16 - $28.62' 28.62 < - 61.46 = '$28.63 - $61.46' 61.46 < - 100 = '$61.47 - $100.00' 100 < - 2089 = '$100.01 - $2089.00' ; VALUE OBPV97H -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 1 - 24 = '$1.00 - $24.00' 24 < - 42 = '$24.01 - $42.00' 42 < - 76 = '$42.01 - $76.00' 76 < - 45000 = '$76.01 - $45000.00' ; VALUE OBPV97M -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 0.2 - 24.31 = '$0.20 - $24.31' 24.31 < - 41 = '$24.32 - $41.00' 41 < - 75 = '$41.01 - $75.00' 75 < - 8681.46 = '$75.01 - $8681.46' ; VALUE OBSF97H -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 1 - 8 = '$1.00 - $8.00' 8 < - 10 = '$8.01 - $10.00' 10 < - 32 = '$10.01 - $32.00' 32 < - 11000 = '$32.01 - $11000.00' ; VALUE OBSF97M -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 0.12 - 8.05 = '$0.12 - $8.05' 8.05 < - 10 = '$8.06 - $10.00' 10 < - 20 = '$10.01 - $20.00' 20 < - 5000 = '$20.01 - $5000.00' ; VALUE OBSL97H -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 2 - 29 = '$2.00 - $29.00' 29 < - 53.5 = '$29.01 - $53.50' 53.5 < - 90 = '$53.51 - $90.00' 90 < - 1620 = '$90.01 - $1620.00' ; VALUE OBSL97M -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 3.02 - 27 = '$3.02 - $27.00' 27 < - 50 = '$27.01 - $50.00' 50 < - 80 = '$50.01 - $80.00' 80 < - 317.64 = '$80.01 - $317.64' ; VALUE OBTC97H -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 1 - 36 = '$1.00 - $36.00' 36 < - 55 = '$36.01 - $55.00' 55 < - 96 = '$55.01 - $96.00' 96 < - 62995 = '$96.01 - $62995.00' ; VALUE OBTC97M -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 2 - 45 = '$2.00 - $45.00' 45 < - 70 = '$45.01 - $70.00' 70 < - 130 = '$70.01 - $130.00' 130 < - 10236.5 = '$130.01 - $10236.50' ; VALUE OBUC97H -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 5 - 15 = '$5.00 - $15.00' 15 < - 25 = '$15.01 - $25.00' 25 < - 59 = '$25.01 - $59.00' 59 < - 1500 = '$59.01 - $1500.00' ; VALUE OBVA97H -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' ; VALUE OBVA97M -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' ; VALUE OBWC97H -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 1 - 60 = '$1.00 - $60.00' 60 < - 100 = '$60.01 - $100.00' 100 = '$100.00' 100 < - 3223 = '$100.01 - $3223.00' ; VALUE OBWC97M -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -1 = '-1 INAPPLICABLE' 0 = '0' 7.88 - 43.35 = '$7.88 - $43.35' 43.35 < - 63.255 = '$43.36 - $63.26' 63.255 < - 134.68 = '$63.27 - $134.68' 134.68 < - 1579.96 = '$134.69 - $1579.96' ; VALUE VARPSU 1 - 34 = '1 - 34' ; VALUE VARSTR 1 - 254 = '1 - 254' ; VALUE WTDPER 0 = '0' 299.337534 - 66983.924524 = '299.337534 - 66983.924524' ;