SAS User File for H213B Data 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 (H213B.SSP) or the ASCII data file (H213B.DAT) 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: CIMPORT. 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 files provided in this PUF release. A. A Sample SAS Program for Converting the SAS Transport File to a Permanent SAS Dataset The SAS procedure CIMPORT will read a SAS transport 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 SAS program that can be used to convert the SAS transport file to a permanent SAS dataset (in a Windows environment). LIBNAME PUFLIB 'C:\MEPS\SASDATA'; FILENAME IN1 'C:\MEPS\DOWNLOAD\H213B.SSP'; PROC CIMPORT DATA=PUFLIB.H213B INFILE=IN1; RUN; Below are SAS statements to print a list of variables and a few sample records from the permanent SAS dataset: PROC CONTENTS DATA=PUFLIB.H213B; TITLE 'List of Variables in MEPS H213B SAS Dataset'; RUN; PROC PRINT DATA=PUFLIB.H213B (OBS=20); TITLE 'First 20 Observations in MEPS H213B SAS Dataset'; RUN; The LIBNAME statement tells SAS the location (directory name) to store the permanent SAS dataset which is output by PROC CIMPORT. 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 and Linux. 3) H213B 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 CIMPORT, the output SAS dataset assumes the same dataset name (or file name). Hence, in the example above, a file named H213B.SAS7BDAT will be created under the C:\MEPS\SASDATA directory when PROC CIMPORT runs successfully. 4) The SAS transport file H213B.SSP was created from a SAS V9 data file, using PROC CPORT. This file should 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 H213B.DAT to a SAS dataset as described in Section B. 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 H213B.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, Linux, etc.), use the editor provided as part of the SAS software. Following is a sample Windows SAS program that will convert the ASCII data file to SAS format: LIBNAME PUFLIB 'C:\MEPS\SASDATA'; FILENAME IN1 'C:\MEPS\DOWNLOAD\H213B.DAT'; DATA PUFLIB.H213B; INFILE IN1 LRECL=248; 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 the output SAS dataset, referencing the LIBNAME entry (PUFLIB) and assigning an internal SAS dataset name (H213B). In the example, after the successful completion of the DATA step, a PC file named H213B.SAS7BDAT would have been created in the C:\MEPS\SASDATA 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 (248 bytes), 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 H213B.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 (e.g., 248 for H213B.DAT). If RECFM=F is used, then the LRECL value must be specified as the logical record length plus 2 (250 for H213B.DAT). 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 (248 for H213B.DAT). INPUT statement: This specifies the input record layout, giving names, the beginning column positions, and the lengths for data items (which become SAS variables) in the ASCII data file (H213B.DAT). Variable type (numeric or character) is also defined by character variables having a dollar sign ($) directly before the variables length, while numeric variables do not have a dollar sign. 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 catalog must first be created. Below is a SAS program that will accomplish this: LIBNAME PUFLIB 'C:\MEPS\SASDATA'; 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\SASDATA'; OPTIONS FMTSEARCH=(PUFLIB); PROC FREQ DATA=PUFLIB.H213B; TABLES .... / LIST MISSING; FORMAT varnam1 fmtnam1. Varnam2 fmtnam2. .... ; * to user: substitute varnam1 and fmtnam1 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 'SAS7BDAT') and format catalog (file name extension is 'SAS7BCAT') 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.SAS7BCAT. 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 generates 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 types 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) 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 and Linux. D. SAS Statements This section contains SAS INPUT, LABEL, FORMAT, and VALUE statements for use in converting the ASCII H213B.DAT file into a SAS dataset, and for creating SAS formats. * INPUT STATEMENTS; INFILE IN LRECL=248; INPUT @1 DUID 7.0 @8 PID 3.0 @11 DUPERSID $10.0 @21 EVNTIDX $16.0 @37 EVENTRN 1.0 @38 FFEEIDX $14.0 @52 PANEL 2.0 @54 DVDATEYR 4.0 @58 DVDATEMM 2.0 @60 GENDENT_M18 2.0 @62 DENTHYG_M18 2.0 @64 DNSPCLST_M18 2.0 @66 DENTYPE_M18 2.0 @68 PEDDENT_M18 2.0 @70 EXAMINE_M18 2.0 @72 CLENTETH_M18 2.0 @74 JUSTXRAY_M18 2.0 @76 FLUORIDE_M18 2.0 @78 SEALANT_M18 2.0 @80 FILLINGX 2.0 @82 FILLING_M18 2.0 @84 ROOTCANX 2.0 @86 ROOTCANL_M18 2.0 @88 GUMSURGX 2.0 @90 GUMSURG_M18 2.0 @92 IMPLANTX 2.0 @94 IMPLANT_M18 2.0 @96 ORALSURX 2.0 @98 ORALSURG_M18 2.0 @100 BRIDGESX 2.0 @102 BRIDGES_M18 2.0 @104 ORTHDONX 2.0 @106 ORTHDONT_M18 2.0 @108 DENTPROX 2.0 @110 DENTPROC 2.0 @112 DENTOTHX $25.0 @137 FFDVTYPE 2.0 @139 FFBEF19 3.0 @142 FFTOT20 3.0 @145 DVSF19X 8.2 @153 DVMR19X 7.2 @160 DVMD19X 7.2 @167 DVPV19X 8.2 @175 DVVA19X 7.2 @182 DVTR19X 7.2 @189 DVOF19X 7.2 @196 DVSL19X 6.2 @202 DVWC19X 6.2 @208 DVOT19X 7.2 @215 DVXP19X 8.2 @223 DVTC19X 8.2 @231 IMPFLAG 1.0 @232 PERWT19F 12.6 @244 VARSTR 4.0 @248 VARPSU 1.0 ; * FORMAT STATEMENTS; FORMAT DUID DUIDF. PID PIDF. DUPERSID $DUPERSIDF. EVNTIDX $EVNTIDXF. EVENTRN EVENTRNF. FFEEIDX $FFEEIDXF. PANEL PANELF. DVDATEYR DVDTEYRF. DVDATEMM DVDTEMMF. GENDENT_M18 GENDENTF. DENTHYG_M18 DENTHYGF. DNSPCLST_M18 DNSPCLSF. DENTYPE_M18 DENTYPEF. PEDDENT_M18 PEDDENTF. EXAMINE_M18 EXAMINEF. CLENTETH_M18 CLENTTHF. JUSTXRAY_M18 JUSTXRAF. FLUORIDE_M18 FLUORIDF. SEALANT_M18 SEALANTF. FILLINGX FILLINXF. FILLING_M18 FILLINGF. ROOTCANX ROOTCAXF. ROOTCANL_M18 ROOTCANF. GUMSURGX GUMSURXF. GUMSURG_M18 GUMSURGF. IMPLANTX IMPLNTXF. IMPLANT_M18 IMPLANTF. ORALSURX ORALSRXF. ORALSURG_M18 ORALSURF. BRIDGESX BRIDGEXF. BRIDGES_M18 BRIDGESF. ORTHDONX ORTHDNXF. ORTHDONT_M18 ORTHDONF. DENTPROX DENTPRXF. DENTPROC DENTPROF. DENTOTHX $DENTTXF. FFDVTYPE FFDVTYPF. FFBEF19 FFBEF19F. FFTOT20 FFTOT20F. DVSF19X DVSF19XF. DVMR19X DVMR19XF. DVMD19X DVMD19XF. DVPV19X DVPV19XF. DVVA19X DVVA19XF. DVTR19X DVTR19XF. DVOF19X DVOF19XF. DVSL19X DVSL19XF. DVWC19X DVWC19XF. DVOT19X DVOT19XF. DVXP19X DVXP19XF. DVTC19X DVTC19XF. IMPFLAG IMPFLAGF. PERWT19F PERWT19F. VARSTR VARSTRF. VARPSU VARPSUF. ; * LABEL STATEMENTS; LABEL DUID ="PANEL # + ENCRYPTED DU IDENTIFIER" PID ="PERSON NUMBER" DUPERSID ="PERSON ID (DUID + PID)" EVNTIDX ="EVENT ID" EVENTRN ="EVENT ROUND NUMBER" FFEEIDX ="FLAT FEE ID" PANEL ="PANEL NUMBER" DVDATEYR ="EVENT DATE - YEAR" DVDATEMM ="EVENT DATE - MONTH" GENDENT_M18 ="GENERAL DENTIST SEEN" DENTHYG_M18 ="DENTAL HYGIENIST SEEN" DNSPCLST_M18 ="DENTAL SPECIALIST SEEN" DENTYPE_M18 ="OTHER DENTAL SPECIALIST SEEN" PEDDENT_M18 ="PEDIATRIC DENTIST SEEN" EXAMINE_M18 ="GENERAL EXAM, CHECKUP OR CONSULTATION" CLENTETH_M18 ="CLEANING, PROPHYLAXIS, POLISHING OR PERIODONTAL RECALL" JUSTXRAY_M18 ="X-RAYS, RADIOGRAPHS OR BITEWINGS" FLUORIDE_M18 ="FLUORIDE TREATMENT" SEALANT_M18 ="SEALANT APPLICATION" FILLINGX ="EDITED FILLING_M18" FILLING_M18 ="FILLINGS, INLAYS, CROWNS OR CAPS" ROOTCANX ="EDITED ROOTCANL_M18" ROOTCANL_M18 ="ROOT CANAL" GUMSURGX ="EDITED GUMSURG_M18" GUMSURG_M18 ="PERIODONTAL SCALING, ROOT PLANING OR GUM SURGERY" IMPLANTX ="EDITED IMPLANT_M18" IMPLANT_M18 ="IMPLANTS" ORALSURX ="EDITED ORALSURG_M18" ORALSURG_M18 ="EXTRACTION, TOOTH PULLED OR OTH ORAL SURGERY" BRIDGESX ="EDITED BRIDGES_M18" BRIDGES_M18 ="FIXED OR RELINING/REPAIR OF BRIDGES/DENTURES, REMOVABLE DENTURES" ORTHDONX ="EDITED ORTHDONT_M18" ORTHDONT_M18 ="ORTHODONTIA, BRACES OR RETAINERS" DENTPROX ="EDITED DENTPROC" DENTPROC ="OTHER DENTAL PROCEDURES" DENTOTHX ="OTHER SPECIFY DENTAL PROCEDURES EDITED" FFDVTYPE ="FLAT FEE BUNDLE" FFBEF19 ="TOTAL # OF VISITS IN FF BEFORE 2019" FFTOT20 ="TOTAL # OF VISITS IN FF AFTER 2019" DVSF19X ="AMOUNT PAID, FAMILY (IMPUTED)" DVMR19X ="AMOUNT PAID, MEDICARE (IMPUTED)" DVMD19X ="AMOUNT PAID, MEDICAID (IMPUTED)" DVPV19X ="AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)" DVVA19X ="AMOUNT PAID, VETERANS/CHAMPVA(IMPUTED)" DVTR19X ="AMOUNT PAID, TRICARE(IMPUTED)" DVOF19X ="AMOUNT PAID, OTHER FEDERAL (IMPUTED)" DVSL19X ="AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)" DVWC19X ="AMOUNT PAID, WORKERS COMP (IMPUTED)" DVOT19X ="AMOUNT PAID, OTHER INSURANCE (IMPUTED)" DVXP19X ="SUM OF DVSF19X-DVOT19X (IMPUTED)" DVTC19X ="HHLD REPORTED TOTAL CHARGE (IMPUTED)" IMPFLAG ="IMPUTATION STATUS" PERWT19F ="EXPENDITURE FILE PERSON WEIGHT, 2019" VARSTR ="VARIANCE ESTIMATION STRATUM, 2019" VARPSU ="VARIANCE ESTIMATION PSU, 2019" ; * VALUE STATEMENTS; VALUE BRIDGESF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE BRIDGEXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE CLENTTHF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE DENTHYGF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE DENTPROF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE DENTPRXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE $DENTTXF '-1' = "-1 INAPPLICABLE" '-15' = "-15 CANNOT BE COMPUTED" '-7' = "-7 REFUSED" '-8' = "-8 DK" 'A RECHECK' = "A RECHECK" 'ABCESS' = "ABCESS" 'ABCESS DRAINED' = "ABCESS DRAINED" 'ABSCESS - GUM' = "ABSCESS - GUM" 'ABSESED TOOTH' = "ABSESED TOOTH" 'ABSESS' = "ABSESS" 'ABSESS INFECTION' = "ABSESS INFECTION" 'ADJUNCT SCREENING/CANCER' = "ADJUNCT SCREENING/CANCER" 'ADJUST BITE' = "ADJUST BITE" 'ADJUST BITE PLATE' = "ADJUST BITE PLATE" 'ADJUSTED MOUTH GARD' = "ADJUSTED MOUTH GARD" 'ADJUSTED REMOVABLE BRIDGE' = "ADJUSTED REMOVABLE BRIDGE" 'ADVISORY FEE FOR IMPLANTS' = "ADVISORY FEE FOR IMPLANTS" 'ADVISORY FEE IMPLANTS' = "ADVISORY FEE IMPLANTS" 'ANASTHESIA' = "ANASTHESIA" 'ANESTISIA' = "ANESTISIA" 'ANOTHER RECHECK' = "ANOTHER RECHECK" 'ANTIBIOTIC APPLICATION' = "ANTIBIOTIC APPLICATION" 'ANTIBIOTIC IMPLANT CANINE' = "ANTIBIOTIC IMPLANT CANINE" 'BIOPSY WHITE SPOT' = "BIOPSY WHITE SPOT" 'BITE ADJUSTMENT' = "BITE ADJUSTMENT" 'BITE GUARD' = "BITE GUARD" 'BITE PLATE' = "BITE PLATE" 'BITE SPLINT FITTING' = "BITE SPLINT FITTING" 'BONDING' = "BONDING" 'BONE GRAFT' = "BONE GRAFT" 'BONE GRAFT/SINUS SURGERY' = "BONE GRAFT/SINUS SURGERY" 'BONE GRAPH' = "BONE GRAPH" 'BONE IMPLANT' = "BONE IMPLANT" 'BONE PLANING' = "BONE PLANING" 'BRACKET PLACEMENT ON JAW' = "BRACKET PLACEMENT ON JAW" 'BROKEN CAP AND TOOTH' = "BROKEN CAP AND TOOTH" 'BROKEN TOOTH' = "BROKEN TOOTH" 'BROKEN TOOTH REPAIR' = "BROKEN TOOTH REPAIR" 'BROKEN TOOTH SMOOTHING' = "BROKEN TOOTH SMOOTHING" 'BUILD UP FOR IMPLANT' = "BUILD UP FOR IMPLANT" 'CAP RE GLUED' = "CAP RE GLUED" 'CAT SCAN' = "CAT SCAN" 'CAVITY NOT FILLED' = "CAVITY NOT FILLED" 'CAVITY NOT FILLED ON BLOO' = "CAVITY NOT FILLED ON BLOO" 'CHARTING OF TEETH' = "CHARTING OF TEETH" 'CHECK APPLIANCE FOR APNEA' = "CHECK APPLIANCE FOR APNEA" 'CHECK FOR NERVE DAMAGE' = "CHECK FOR NERVE DAMAGE" 'CHECK FOR POCKETS' = "CHECK FOR POCKETS" 'CHECK MOUTH GUARD' = "CHECK MOUTH GUARD" 'CHECK THE INFECTION' = "CHECK THE INFECTION" 'CHECKED IMPLANTS' = "CHECKED IMPLANTS" 'CHEMICAL TREATMENT CAVITI' = "CHEMICAL TREATMENT CAVITI" 'CLEANING TOOTH ABCESS' = "CLEANING TOOTH ABCESS" 'CLEAR FOR SURGERY' = "CLEAR FOR SURGERY" 'COATING ON TEETH' = "COATING ON TEETH" 'COLD AND HOT FEELING' = "COLD AND HOT FEELING" 'COLD SENSITIVITY TESTING' = "COLD SENSITIVITY TESTING" 'CONSULT' = "CONSULT" 'CONSULTANT TO PERIDONTAL' = "CONSULTANT TO PERIDONTAL" 'CONSULTANTS TO PERIDONTAL' = "CONSULTANTS TO PERIDONTAL" 'CONSULTATION' = "CONSULTATION" 'CONSULTATION FOR ORAL SUR' = "CONSULTATION FOR ORAL SUR" 'CONSULTATION FOR TOOTH RE' = "CONSULTATION FOR TOOTH RE" 'COSMETIC' = "COSMETIC" 'COSMETIC PROSEDURE' = "COSMETIC PROSEDURE" 'COST INCLUDED IN PRIOER' = "COST INCLUDED IN PRIOER" 'CRACKED TOOTH' = "CRACKED TOOTH" 'CRE BUILDUP' = "CRE BUILDUP" 'DENTAL CARE VISIT' = "DENTAL CARE VISIT" 'DENTAL IMPRESSIONS' = "DENTAL IMPRESSIONS" 'DENTAL WORK' = "DENTAL WORK" 'DIAGNOSIS RE:FISHBONE FB' = "DIAGNOSIS RE:FISHBONE FB" 'DIAGNOSTIC' = "DIAGNOSTIC" 'DIAGNOSTIC PREVENTATIVE' = "DIAGNOSTIC PREVENTATIVE" 'DK' = "DK" 'EMERGENCY FITTING' = "EMERGENCY FITTING" 'EMERGENCY TOOTH PAIN' = "EMERGENCY TOOTH PAIN" 'ERUPTED TOOTH EXT' = "ERUPTED TOOTH EXT" 'EXAMINE CRACKED TOOTH' = "EXAMINE CRACKED TOOTH" 'FALLOW UP' = "FALLOW UP" 'FILING OF TOOTH' = "FILING OF TOOTH" 'FITTED FOR NIGHT GUARD' = "FITTED FOR NIGHT GUARD" 'FITTING FOR MOUTH GUARD' = "FITTING FOR MOUTH GUARD" 'FITTING FOR NIGHT GUARD' = "FITTING FOR NIGHT GUARD" 'FITTING FOR NIGHTGUARD' = "FITTING FOR NIGHTGUARD" 'FITTING OF NIGHT GAURD' = "FITTING OF NIGHT GAURD" 'FIXED BROKEN TOOTH' = "FIXED BROKEN TOOTH" 'FIXED CHIPPED TOOTH' = "FIXED CHIPPED TOOTH" 'FLOSSING' = "FLOSSING" 'FOLLOW UP' = "FOLLOW UP" 'FOLLOW UP DANTAL CARE' = "FOLLOW UP DANTAL CARE" 'FOLLOW UP FOR THE FIRST V' = "FOLLOW UP FOR THE FIRST V" 'FOLLOW UP FROM BONE GRAF' = "FOLLOW UP FROM BONE GRAF" 'FOLLOW UP ON STITCHES' = "FOLLOW UP ON STITCHES" 'FOLLOW UP PREV PROCEDURES' = "FOLLOW UP PREV PROCEDURES" 'FOLLOW UP SERVICES' = "FOLLOW UP SERVICES" 'FOLLOW-UP' = "FOLLOW-UP" 'FOLLOWUP TISSUE REMOVAL' = "FOLLOWUP TISSUE REMOVAL" 'FOLLOWUP TO STITCH REMOVA' = "FOLLOWUP TO STITCH REMOVA" 'FRACTURED TOOTH AND INFEC' = "FRACTURED TOOTH AND INFEC" 'GENERAL CHECK UP' = "GENERAL CHECK UP" 'GENERAL DENTAL' = "GENERAL DENTAL" 'GLUE CROWN BACK ON' = "GLUE CROWN BACK ON" 'GOT MOUTH GUARD' = "GOT MOUTH GUARD" 'GUM/ROOT TREATMENT' = "GUM/ROOT TREATMENT" 'IMPLANT PREP' = "IMPLANT PREP" 'IMPRESSION' = "IMPRESSION" 'IMPRESSION MADE' = "IMPRESSION MADE" 'IMPRESSIONS' = "IMPRESSIONS" 'IMPRESSIONS FOR MOUTH GUA' = "IMPRESSIONS FOR MOUTH GUA" 'IMPRESSIONS FOR NEW TEETH' = "IMPRESSIONS FOR NEW TEETH" 'INCLUDED IN OTHER VISITS' = "INCLUDED IN OTHER VISITS" 'INCLUDED IN PRIOR' = "INCLUDED IN PRIOR" 'INFECTED TOOTH' = "INFECTED TOOTH" 'INFECTION' = "INFECTION" 'INFECTION IN JAW' = "INFECTION IN JAW" 'INFLAMMATION' = "INFLAMMATION" 'INTER PERIODONTAL CLEANIN' = "INTER PERIODONTAL CLEANIN" 'INVISILINE' = "INVISILINE" 'JAW PROBLEM' = "JAW PROBLEM" 'JAW PROBLEMS' = "JAW PROBLEMS" 'JAW SPACER' = "JAW SPACER" 'JAWBONE IMPANT' = "JAWBONE IMPANT" 'JUST RECIEVED EXPLANATION' = "JUST RECIEVED EXPLANATION" 'LASER CLEANING' = "LASER CLEANING" 'LASER TREATMENT' = "LASER TREATMENT" 'LIP AND TONGUE TIE CLIP' = "LIP AND TONGUE TIE CLIP" 'LIP TIES' = "LIP TIES" 'LIP,TONGUE, AND CHEEK TIE' = "LIP,TONGUE, AND CHEEK TIE" 'LOOSE TOOTH' = "LOOSE TOOTH" 'MAJOR MOUTH IMPLANTS' = "MAJOR MOUTH IMPLANTS" 'MAKING THE NIGHT GUARD' = "MAKING THE NIGHT GUARD" 'MEASURED FOR MOUTHGARD' = "MEASURED FOR MOUTHGARD" 'MEASURED FOR NIGHT GUARD' = "MEASURED FOR NIGHT GUARD" 'MEDICATION' = "MEDICATION" 'MEMBRANE FOR TOOTH' = "MEMBRANE FOR TOOTH" 'MESAURED FOR PARTIAL' = "MESAURED FOR PARTIAL" 'MOLAR PAIN' = "MOLAR PAIN" 'MOLD' = "MOLD" 'MOLD FOR MOUTH NIGHT GUAR' = "MOLD FOR MOUTH NIGHT GUAR" 'MOLD MADE' = "MOLD MADE" 'MOLDS FOR BLEACH TRAYS' = "MOLDS FOR BLEACH TRAYS" 'MOTH GUARDS AND WHITENING' = "MOTH GUARDS AND WHITENING" 'MOUTH GUARD' = "MOUTH GUARD" 'MOUTH GUARD FITTING' = "MOUTH GUARD FITTING" 'MOUTH GUIDE CHECK' = "MOUTH GUIDE CHECK" 'MOUTHGUARD' = "MOUTHGUARD" 'MOUTHGUARD FITTING' = "MOUTHGUARD FITTING" 'MOUTHPIECE FIT SLEEPAPINE' = "MOUTHPIECE FIT SLEEPAPINE" 'MOUTHPIECESLEEPAPINEA' = "MOUTHPIECESLEEPAPINEA" 'MRI' = "MRI" 'MYOFUNCTIONAL CONSULT' = "MYOFUNCTIONAL CONSULT" 'NERVE TREATMENT' = "NERVE TREATMENT" 'NIGHT GUARD' = "NIGHT GUARD" 'NIGHT GUARD FIT' = "NIGHT GUARD FIT" 'NIGHT GUARD FITTING' = "NIGHT GUARD FITTING" 'NIGHT GUARD REPAIR' = "NIGHT GUARD REPAIR" 'NIGHTGUARD' = "NIGHTGUARD" 'NO DENTAL VISIT OCCURED' = "NO DENTAL VISIT OCCURED" 'NO OTHER' = "NO OTHER" 'NONE' = "NONE" 'NOT SURE' = "NOT SURE" 'NUMBING AND PACKING' = "NUMBING AND PACKING" 'NUMBING AND REPACKING' = "NUMBING AND REPACKING" 'OAYED FOR NIGHTGUARD' = "OAYED FOR NIGHTGUARD" 'OCCLUSAL SPLINT/ BRUXISM' = "OCCLUSAL SPLINT/ BRUXISM" 'ODONTOLPLASTY' = "ODONTOLPLASTY" 'ORAL CANCER SCREENING' = "ORAL CANCER SCREENING" 'ORAL TREATMENT' = "ORAL TREATMENT" 'ORDONTOLPLASTY' = "ORDONTOLPLASTY" 'PACKED- GUMS' = "PACKED- GUMS" 'PAIN TREATMENT' = "PAIN TREATMENT" 'PERIOCHARTING' = "PERIOCHARTING" 'PEROCHARTING' = "PEROCHARTING" 'POST FOR IMPLA T' = "POST FOR IMPLA T" 'POST HYGEINE ANTI INFECTI' = "POST HYGEINE ANTI INFECTI" 'POST OP' = "POST OP" 'PRE-DENTAL CONSULTATION' = "PRE-DENTAL CONSULTATION" 'PRESCRIPTION REFILL' = "PRESCRIPTION REFILL" 'PUT ANTIDIOTIC GUMS' = "PUT ANTIDIOTIC GUMS" 'PUT IN A TOOTH' = "PUT IN A TOOTH" 'REALIGNING OF TOOTH-FALL' = "REALIGNING OF TOOTH-FALL" 'REALIGNMENT' = "REALIGNMENT" 'REBUILD BONE' = "REBUILD BONE" 'REBUILDING OF TOOTH' = "REBUILDING OF TOOTH" 'REFERAL TOSURGEON' = "REFERAL TOSURGEON" 'REFERREL TO SPECIALIST' = "REFERREL TO SPECIALIST" 'REMOVAL OF CHIPPED CROWN' = "REMOVAL OF CHIPPED CROWN" 'REMOVAL OF STUCK FLOSS' = "REMOVAL OF STUCK FLOSS" 'REMOVE BONE CHIP' = "REMOVE BONE CHIP" 'REMOVE OLD SPACER' = "REMOVE OLD SPACER" 'REMOVE STICHES' = "REMOVE STICHES" 'REMOVE STITCHES' = "REMOVE STITCHES" 'REMOVED MOUTH ATTATCHEMEN' = "REMOVED MOUTH ATTATCHEMEN" 'REMOVED STITCES' = "REMOVED STITCES" 'REMOVED STITCHES' = "REMOVED STITCHES" 'REMOVING STITCHES' = "REMOVING STITCHES" 'REPACKED FROM TOOTH EXTRA' = "REPACKED FROM TOOTH EXTRA" 'REPACKING AND NUMBING' = "REPACKING AND NUMBING" 'REPAIR OF TOOTH' = "REPAIR OF TOOTH" 'REPAIR WORK' = "REPAIR WORK" 'RESCHEDULED APPOINTMENT T' = "RESCHEDULED APPOINTMENT T" 'RESIN COMPOSITE ON TEET' = "RESIN COMPOSITE ON TEET" 'RESIN, SURFACE, ANT.' = "RESIN, SURFACE, ANT." 'RETAINER OFF AND FOLLOW' = "RETAINER OFF AND FOLLOW" 'RETAINER WITH A BRIDGE IN' = "RETAINER WITH A BRIDGE IN" 'ROLLUP COST IN PREVIOUS' = "ROLLUP COST IN PREVIOUS" 'SAND' = "SAND" 'SCAN FOR FITTED TRAYS' = "SCAN FOR FITTED TRAYS" 'SCHEDULE AN APPOINTMENT' = "SCHEDULE AN APPOINTMENT" 'SHAVE TOOTH' = "SHAVE TOOTH" 'SHAVED TEETH FOR EVENESS' = "SHAVED TEETH FOR EVENESS" 'SHAVED TOOTH A LITTLE' = "SHAVED TOOTH A LITTLE" 'SHAVING TEETH' = "SHAVING TEETH" 'SHOULD BE A WELL VISIT.' = "SHOULD BE A WELL VISIT." 'SILVER SULFIDE' = "SILVER SULFIDE" 'SINUS INFECTION' = "SINUS INFECTION" 'SLEEP APNEA APPLIANCE' = "SLEEP APNEA APPLIANCE" 'SLEEP APNEA DEVICE' = "SLEEP APNEA DEVICE" 'SLEEP ISSUES' = "SLEEP ISSUES" 'SLEEP STUDY' = "SLEEP STUDY" 'SNORE GUARD' = "SNORE GUARD" 'SPACER EVALUATION' = "SPACER EVALUATION" 'SPLINTING' = "SPLINTING" 'STITCHES REMOVED' = "STITCHES REMOVED" 'SURGERY' = "SURGERY" 'SURGERY RE RESORBTION' = "SURGERY RE RESORBTION" 'TAKE STITCHES OUT' = "TAKE STITCHES OUT" 'TEETH' = "TEETH" 'TEETH SHAVING' = "TEETH SHAVING" 'TEETH WHITENING' = "TEETH WHITENING" 'TEMPORARY TOOTH' = "TEMPORARY TOOTH" 'TMJ' = "TMJ" 'TMJ CARTILEGE IN JAW' = "TMJ CARTILEGE IN JAW" 'TONGUE THERAPY' = "TONGUE THERAPY" 'TOOH WHITE' = "TOOH WHITE" 'TOOTH ACHE' = "TOOTH ACHE" 'TOOTH GRINDING' = "TOOTH GRINDING" 'TOOTH GROUND DOWN' = "TOOTH GROUND DOWN" 'TOOTH IMOLANT' = "TOOTH IMOLANT" 'TOOTH MOLD' = "TOOTH MOLD" 'TOOTH WAS CRACKED GOT FIX' = "TOOTH WAS CRACKED GOT FIX" 'TOOTH WHITENING' = "TOOTH WHITENING" 'TRAY FOR TOOTH WHITENING' = "TRAY FOR TOOTH WHITENING" 'TREATMENT FOR DENTAL PAIN' = "TREATMENT FOR DENTAL PAIN" 'TREATMENT FOR SENSITIVE T' = "TREATMENT FOR SENSITIVE T" 'TREATMENT INFECTED ROOT' = "TREATMENT INFECTED ROOT" 'TRISMUSS' = "TRISMUSS" 'VENEERS' = "VENEERS" 'WHITE TOOH' = "WHITE TOOH" 'WHITENING' = "WHITENING" 'WHITENING AND SPACERS' = "WHITENING AND SPACERS" 'WHITENNING TOOTH' = "WHITENNING TOOTH" 'WOOD WEDGED IN TOOTH' = "WOOD WEDGED IN TOOTH" OTHER = "OTHER" ; VALUE DENTYPEF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE DNSPCLSF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE DUIDF 2320012 - 2469688 = "2320012 - 2469688 DUID" ; VALUE $DUPERSIDF '2320012102' - '2469688102' = "2320012102 - 2469688102 DUPERSID" ; VALUE DVDTEMMF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 - 12 = "1 - 12 MONTH" ; VALUE DVDTEYRF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 2019 = "2019" ; VALUE DVMD19XF 0 = "0" 0.36 - 72.5 = "$0.36 - $72.50" 72.51 - 107.88 = "$72.51 - $107.88" 107.89 - 175 = "$107.89 - $175.00" 175.01 - 7490 = "$175.01 - $7,490.00" ; VALUE DVMR19XF 0 = "0" 3 - 103 = "$3.00 - $103.00" 103.01 - 151 = "$103.01 - $151.00" 151.01 - 235 = "$151.01 - $235.00" 235.01 - 8396 = "$235.01 - $8,396.00" ; VALUE DVOF19XF 0 = "0" 14 - 53 = "$14.00 - $53.00" 53.01 - 142.5 = "$53.01 - $142.50" 142.51 - 428 = "$142.51 - $428.00" 428.01 - 2800 = "$428.01 - $2,800.00" ; VALUE DVOT19XF 0 = "0" 21 - 66 = "$21.00 - $66.00" 66.01 - 135 = "$66.01 - $135.00" 135.01 - 177 = "$135.01 - $177.00" 177.01 - 1220 = "$177.01 - $1,220.00" ; VALUE DVPV19XF 0 = "0" 1 - 104 = "$1.00 - $104.00" 104.01 - 150 = "$104.01 - $150.00" 150.01 - 236 = "$150.01 - $236.00" 236.01 - 33889 = "$236.01 - $33,889.00" ; VALUE DVSF19XF 0 = "0" 1 - 50 = "$1.00 - $50.00" 50.01 - 120 = "$50.01 - $120.00" 120.01 - 250 = "$120.01 - $250.00" 250.01 - 34700 = "$250.01 - $34,700.00" ; VALUE DVSL19XF 0 = "0" 10 - 84.75 = "$10.00 - $84.75" 84.76 - 100 = "$84.76 - $100.00" 100.01 - 180 = "$100.01 - $180.00" 180.01 - 500 = "$180.01 - $500.00" ; VALUE DVTC19XF 0 = "0" 25.23 - 135 = "$25.23 - $135.00" 135.01 - 198 = "$135.01 - $198.00" 198.01 - 337 = "$198.01 - $337.00" 337.01 - 35000 = "$337.01 - $35,000.00" ; VALUE DVTR19XF 0 = "0" 11 - 73 = "$11.00 - $73.00" 73.01 - 125.63 = "$73.01 - $125.63" 125.64 - 206.25 = "$125.64 - $206.25" 206.26 - 6354 = "$206.26 - $6,354.00" ; VALUE DVVA19XF 0 = "0" 13 - 98 = "$13.00 - $98.00" 98.01 - 142 = "$98.01 - $142.00" 142.01 - 231 = "$142.01 - $231.00" 231.01 - 3000 = "$231.01 - $3,000.00" ; VALUE DVWC19XF 0 = "0" 100 - 210 = "$100.00 - $210.00" ; VALUE DVXP19XF 0 = "0" 30.16 - 109.62 = "$30.16 - $109.62" 109.63 - 160 = "$109.63 - $160.00" 160.01 - 280 = "$160.01 - $280.00" 280.01 - 35000 = "$280.01 - $35,000.00" ; VALUE EVENTRNF 1 = "ROUND 1" 2 = "ROUND 2" 3 = "ROUND 3" 4 = "ROUND 4" 5 = "ROUND 5" ; VALUE $EVNTIDXF '2320012102201601' - '2469688102000801' = "2320012102201601 - 2469688102000801 EVNTIDX" ; VALUE EXAMINEF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE FFBEF19F -15 = "-15 CANNOT BE COMPUTED" -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 0 = "0" 1 - 83 = "1 - 83" ; VALUE FFDVTYPF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 FLAT FEE STEM" 2 = "2 FLAT FEE LEAF" ; VALUE $FFEEIDXF '-1' = "-1 INAPPLICABLE" '232001910201' - 'DN246877710201' = "232001910201 - DN246877710201 FFEEIDX" ; VALUE FFTOT20F -15 = "-15 CANNOT BE COMPUTED" -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 0 = "0" 1 - 19 = "1 - 19" ; VALUE FILLINGF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE FILLINXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE FLUORIDF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE GENDENTF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE GUMSURGF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE GUMSURXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE IMPFLAGF 0 = "0 NOT ELIGIBLE FOR IMPUTATION" 1 = "1 COMPLETE HC DATA" 2 = "2 COMPLETE MPC DATA" 3 = "3 FULLY IMPUTED" 4 = "4 PARTIALLY IMPUTED" 5 = "5 CAPITATION IMPUTATION" ; VALUE IMPLANTF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE IMPLNTXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE JUSTXRAF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE ORALSRXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE ORALSURF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE ORTHDNXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE ORTHDONF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE PANELF 23 = "PANEL 23" 24 = "PANEL 24" ; VALUE PEDDENTF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE PERWT19F 0 = "0.000000 WEIGHT" 633.006358 - 77911.063903 = "633.006358 - 77911.063903 WEIGHT" ; VALUE PIDF 101 - 501 = "101 - 501 PID" ; VALUE ROOTCANF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE ROOTCAXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE SEALANTF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE VARPSUF 1 - 6 = "1 - 6" ; VALUE VARSTRF 2001 - 2117 = "2001 - 2117" ;