SAS User File for H220B 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 (H220B.SSP) or the ASCII data file (H220B.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\H220B.SSP'; PROC CIMPORT DATA=PUFLIB.H220B 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.H220B; TITLE 'List of Variables in MEPS H220B SAS Dataset'; RUN; PROC PRINT DATA=PUFLIB.H220B (OBS=20); TITLE 'First 20 Observations in MEPS H220B 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) H220B 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 H220B.SAS7BDAT will be created under the C:\MEPS\SASDATA directory when PROC CIMPORT runs successfully. 4) The SAS transport file H220B.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 H220B.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 H220B.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\H220B.DAT'; DATA PUFLIB.H220B; INFILE IN1 LRECL=253; 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 (H220B). In the example, after the successful completion of the DATA step, a PC file named H220B.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 (253 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 H220B.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., 253 for H220B.DAT). If RECFM=F is used, then the LRECL value must be specified as the logical record length plus 2 (255 for H220B.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 (253 for H220B.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 (H220B.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.H220B; 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 H220B.DAT file into a SAS dataset, and for creating SAS formats. * INPUT STATEMENTS; INFILE IN LRECL=253; 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 CLENTETX 2.0 @74 CLENTETH_M18 2.0 @76 JUSTXRYX 2.0 @78 JUSTXRAY_M18 2.0 @80 FLUORIDE_M18 2.0 @82 SEALANTX 2.0 @84 SEALANT_M18 2.0 @86 FILLINGX 2.0 @88 FILLING_M18 2.0 @90 ROOTCANX 2.0 @92 ROOTCANL_M18 2.0 @94 GUMSURGX 2.0 @96 GUMSURG_M18 2.0 @98 IMPLANTX 2.0 @100 IMPLANT_M18 2.0 @102 ORALSURX 2.0 @104 ORALSURG_M18 2.0 @106 BRIDGESX 2.0 @108 BRIDGES_M18 2.0 @110 ORTHDONX 2.0 @112 ORTHDONT_M18 2.0 @114 DENTPROX 2.0 @116 DENTPROC 2.0 @118 DENTOTHX $25.0 @143 FFDVTYPE 2.0 @145 FFBEF20 3.0 @148 FFTOT21 3.0 @151 DVSF20X 8.2 @159 DVMR20X 7.2 @166 DVMD20X 7.2 @173 DVPV20X 8.2 @181 DVVA20X 7.2 @188 DVTR20X 7.2 @195 DVOF20X 7.2 @202 DVSL20X 6.2 @208 DVWC20X 5.2 @213 DVOT20X 7.2 @220 DVXP20X 8.2 @228 DVTC20X 8.2 @236 IMPFLAG 1.0 @237 PERWT20F 12.6 @249 VARSTR 4.0 @253 VARPSU 1.0 ; * FORMAT STATEMENTS; FORMAT DUID DUIDF. PID PIDF. DUPERSID $DUPERSIDF. EVNTIDX $EVNTIDXF. EVENTRN EVENTRNF. FFEEIDX $FFEEIDXF. PANEL PANELF. DVDATEYR DVDATEYRF. DVDATEMM DVDATEMMF. GENDENT_M18 GENDENT_M18F. DENTHYG_M18 DENTHYG_M18F. DNSPCLST_M18 DNSPCLST_M18F. DENTYPE_M18 DENTYPE_M18F. PEDDENT_M18 PEDDENT_M18F. EXAMINE_M18 EXAMINE_M18F. CLENTETX CLENTETXF. CLENTETH_M18 CLENTETH_M18F. JUSTXRYX JUSTXRYXF. JUSTXRAY_M18 JUSTXRAY_M18F. FLUORIDE_M18 FLUORIDE_M18F. SEALANTX SEALANTXF. SEALANT_M18 SEALANT_M18F. FILLINGX FILLINGXF. FILLING_M18 FILLING_M18F. ROOTCANX ROOTCANXF. ROOTCANL_M18 ROOTCANL_M18F. GUMSURGX GUMSURGXF. GUMSURG_M18 GUMSURG_M18F. IMPLANTX IMPLANTXF. IMPLANT_M18 IMPLANT_M18F. ORALSURX ORALSURXF. ORALSURG_M18 ORALSURG_M18F. BRIDGESX BRIDGESXF. BRIDGES_M18 BRIDGES_M18F. ORTHDONX ORTHDONXF. ORTHDONT_M18 ORTHDONT_M18F. DENTPROX DENTPROXF. DENTPROC DENTPROCF. DENTOTHX $DENTOTHXF. FFDVTYPE FFDVTYPEF. FFBEF20 FFBEF20F. FFTOT21 FFTOT21F. DVSF20X DVSF20XF. DVMR20X DVMR20XF. DVMD20X DVMD20XF. DVPV20X DVPV20XF. DVVA20X DVVA20XF. DVTR20X DVTR20XF. DVOF20X DVOF20XF. DVSL20X DVSL20XF. DVWC20X DVWC20XF. DVOT20X DVOT20XF. DVXP20X DVXP20XF. DVTC20X DVTC20XF. IMPFLAG IMPFLAGF. PERWT20F PERWT20FF. 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" CLENTETX ="EDITED CLENTETH_M18" CLENTETH_M18 ="CLEANING, PROPHYLAXIS, POLISHING OR PERIODONTAL RECALL" JUSTXRYX ="EDITED JUSTXRAY_M18" JUSTXRAY_M18 ="X-RAYS, RADIOGRAPHS OR BITEWINGS" FLUORIDE_M18 ="FLUORIDE TREATMENT" SEALANTX ="EDITED SEALANT_M18" 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" FFBEF20 ="TOTAL # OF VISITS IN FF BEFORE 2020" FFTOT21 ="TOTAL # OF VISITS IN FF AFTER 2020" DVSF20X ="AMOUNT PAID, FAMILY (IMPUTED)" DVMR20X ="AMOUNT PAID, MEDICARE (IMPUTED)" DVMD20X ="AMOUNT PAID, MEDICAID (IMPUTED)" DVPV20X ="AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)" DVVA20X ="AMOUNT PAID, VETERANS/CHAMPVA(IMPUTED)" DVTR20X ="AMOUNT PAID, TRICARE(IMPUTED)" DVOF20X ="AMOUNT PAID, OTHER FEDERAL (IMPUTED)" DVSL20X ="AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)" DVWC20X ="AMOUNT PAID, WORKERS COMP (IMPUTED)" DVOT20X ="AMOUNT PAID, OTHER INSURANCE (IMPUTED)" DVXP20X ="SUM OF DVSF20X-DVOT20X (IMPUTED)" DVTC20X ="HHLD REPORTED TOTAL CHARGE (IMPUTED)" IMPFLAG ="IMPUTATION STATUS" PERWT20F ="EXPENDITURE FILE PERSON WEIGHT, 2020" VARSTR ="VARIANCE ESTIMATION STRATUM, 2020" VARPSU ="VARIANCE ESTIMATION PSU, 2020" ; * VALUE STATEMENTS; VALUE BRIDGESXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE BRIDGES_M18F -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE CLENTETH_M18F -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE CLENTETXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE DENTHYG_M18F -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE $DENTOTHXF '-1' = "-1 INAPPLICABLE" '-15' = "-15 CANNOT BE COMPUTED" '-7' = "-7 REFUSED" '-8' = "-8 DK" '1ST VISIT' = "1ST VISIT" 'ABCESS' = "ABCESS" 'ABCESS TOOTH' = "ABCESS TOOTH" 'ABCESSED TOOTH' = "ABCESSED TOOTH" 'ABSESS' = "ABSESS" 'ABSESSED TOOTH' = "ABSESSED TOOTH" 'ACCLUSIAL GUARD IMPRESSIO' = "ACCLUSIAL GUARD IMPRESSIO" 'ADJUST BITE' = "ADJUST BITE" 'ADJUSTED DAMAGED TEETH' = "ADJUSTED DAMAGED TEETH" 'ADJUSTING SPLINT' = "ADJUSTING SPLINT" 'ANESTHESIA HEALTH CHECK' = "ANESTHESIA HEALTH CHECK" 'ANESTHSIA' = "ANESTHSIA" 'ANTIBIOTIC IN GUMS' = "ANTIBIOTIC IN GUMS" 'ANTIBIOTIC PRESCRIBED' = "ANTIBIOTIC PRESCRIBED" 'ANTIBIOTICS' = "ANTIBIOTICS" 'ANTIBOTIC PROCEDURE' = "ANTIBOTIC PROCEDURE" 'APNEA FIX' = "APNEA FIX" 'ASSESSMENT OF MOUTH' = "ASSESSMENT OF MOUTH" 'BEHAVIORAL MANAGEMENT' = "BEHAVIORAL MANAGEMENT" 'BITE ADJUSTMENT' = "BITE ADJUSTMENT" 'BITE ALIGNMENT' = "BITE ALIGNMENT" 'BITE GUARD' = "BITE GUARD" 'BITEGUARD IMPRESSION' = "BITEGUARD IMPRESSION" 'BLOOD PRESSURE AND WEIGHT' = "BLOOD PRESSURE AND WEIGHT" 'BONDED TWO FRONT TEETH TO' = "BONDED TWO FRONT TEETH TO" 'BONDING' = "BONDING" 'BONE GRAFT' = "BONE GRAFT" 'BONE GRAFTING' = "BONE GRAFTING" 'BONE GRAPH' = "BONE GRAPH" 'BONE REPLACEMENT' = "BONE REPLACEMENT" 'BRIDGES/IMPLAN/CROWN' = "BRIDGES/IMPLAN/CROWN" 'BROKEN TOOTH' = "BROKEN TOOTH" 'BROKEN TOOTH EVALUATION' = "BROKEN TOOTH EVALUATION" 'BUFFED SHARP EDGES' = "BUFFED SHARP EDGES" 'BUILD UP' = "BUILD UP" 'BUILDUP' = "BUILDUP" 'BYOPSI' = "BYOPSI" 'CANCELLED' = "CANCELLED" 'CANCER SCREENING' = "CANCER SCREENING" 'CAVITY BLOCKER' = "CAVITY BLOCKER" 'CHECK SURGERY' = "CHECK SURGERY" 'CHECK TO VERIFY INSURANCE' = "CHECK TO VERIFY INSURANCE" 'CHECKED TO SEE AESTHESIA' = "CHECKED TO SEE AESTHESIA" 'CHECKING THE TOOTH AT THE' = "CHECKING THE TOOTH AT THE" 'COMPUTER EVAL/PRE IMPLANT' = "COMPUTER EVAL/PRE IMPLANT" 'CONSULT' = "CONSULT" 'CONSULTATION' = "CONSULTATION" 'CONSULTATION SESSION RE C' = "CONSULTATION SESSION RE C" 'CONSULTATION/MEASUREMENT' = "CONSULTATION/MEASUREMENT" 'CORRECTED BITE/TEETH/GRIN' = "CORRECTED BITE/TEETH/GRIN" 'COSULTATION' = "COSULTATION" 'CRACKED TOOTH & SMOOTHING' = "CRACKED TOOTH & SMOOTHING" 'CT-SCAN & MOLLAR CREATION' = "CT-SCAN & MOLLAR CREATION" 'CUT ADDITIONAL BRACE TISS' = "CUT ADDITIONAL BRACE TISS" 'DENSTIST' = "DENSTIST" 'DENT NEW' = "DENT NEW" 'DENTA CONS.REFERRAL' = "DENTA CONS.REFERRAL" 'DENTAL CLEANING' = "DENTAL CLEANING" 'DENTAL CLEANING & MOUTHGA' = "DENTAL CLEANING & MOUTHGA" 'DENTAL CLEANING, MOUTHGAR' = "DENTAL CLEANING, MOUTHGAR" 'DENTAL CONSULTATION' = "DENTAL CONSULTATION" 'DENTAL DIAGNOSTIC' = "DENTAL DIAGNOSTIC" 'DENTAL GUARD' = "DENTAL GUARD" 'DENTAL IMPRESSIONS' = "DENTAL IMPRESSIONS" 'DENTAL PAIN' = "DENTAL PAIN" 'DENTAL SPECIALIST' = "DENTAL SPECIALIST" 'DENTAL WORK' = "DENTAL WORK" 'DENTIST' = "DENTIST" 'DIAGNOSING EAR PAIN' = "DIAGNOSING EAR PAIN" 'DIAGNOSIS' = "DIAGNOSIS" 'DIAGNOSTIC OR PREVENTIVE' = "DIAGNOSTIC OR PREVENTIVE" 'EMERGENCY TREATMENT' = "EMERGENCY TREATMENT" 'EMERGENCY VISIT TOOTH ACH' = "EMERGENCY VISIT TOOTH ACH" 'EYE EXAM AT SCHGOOL' = "EYE EXAM AT SCHGOOL" 'FILE SHARP RIDGES ON TEET' = "FILE SHARP RIDGES ON TEET" 'FITTD FOR DENTURES' = "FITTD FOR DENTURES" 'FITTED ACCLUSIAL GUARD' = "FITTED ACCLUSIAL GUARD" 'FITTING FOR NIGHT GUARD' = "FITTING FOR NIGHT GUARD" 'FIX FALSE TOOTH' = "FIX FALSE TOOTH" 'FIXED BROKEN TOOTH' = "FIXED BROKEN TOOTH" 'FIXED BROKEN TOOTH & 2 CR' = "FIXED BROKEN TOOTH & 2 CR" 'FIXED CHIPPED TOOTH' = "FIXED CHIPPED TOOTH" 'FLU SHOT' = "FLU SHOT" 'FLUOROSCOPE' = "FLUOROSCOPE" 'FOLLOW UP' = "FOLLOW UP" 'FOLLOW UP FROM SURGERY' = "FOLLOW UP FROM SURGERY" 'FOLLOW UP ON INFECTION' = "FOLLOW UP ON INFECTION" 'FOLLOW UP VISIT' = "FOLLOW UP VISIT" 'FOLLOW-UP' = "FOLLOW-UP" 'FOLLOW-UP APPOINTMENT' = "FOLLOW-UP APPOINTMENT" 'FOLLOWUP BY PHONE' = "FOLLOWUP BY PHONE" 'FOLOOW-UP TO SURGERY' = "FOLOOW-UP TO SURGERY" 'FOOD PARTICLES IN GUMS RE' = "FOOD PARTICLES IN GUMS RE" 'FRENOTOMY' = "FRENOTOMY" 'FRONT TOOTH REPAIR' = "FRONT TOOTH REPAIR" 'GAVE MEDICINE' = "GAVE MEDICINE" 'GENERAL CONSULT' = "GENERAL CONSULT" 'GET ANTIBIOTICS' = "GET ANTIBIOTICS" 'GINGIVITIS TREATMENT' = "GINGIVITIS TREATMENT" 'GROUND TEETH' = "GROUND TEETH" 'GUARD' = "GUARD" 'HAD A MOLD DONE' = "HAD A MOLD DONE" 'HEALTH CHECK' = "HEALTH CHECK" 'HOLE REMAINS IN TOOTH' = "HOLE REMAINS IN TOOTH" 'IMAGE OF TEETH' = "IMAGE OF TEETH" 'IMPRESSION' = "IMPRESSION" 'IMPRESSION FOR MOUTH GUAR' = "IMPRESSION FOR MOUTH GUAR" 'IMPRESSIONS' = "IMPRESSIONS" 'IMPRESSIONS AND FITTINGS' = "IMPRESSIONS AND FITTINGS" 'INCLUDED WITH 1ST VISIT' = "INCLUDED WITH 1ST VISIT" 'INCLUSION BENIGN LESION' = "INCLUSION BENIGN LESION" 'INFECTED TOOTH' = "INFECTED TOOTH" 'INFECTION' = "INFECTION" 'INFECTION CROWN' = "INFECTION CROWN" 'INVISILINE' = "INVISILINE" 'LASER CUT-TONGUE/LIP TIE' = "LASER CUT-TONGUE/LIP TIE" 'LASER TREATMENT' = "LASER TREATMENT" 'LIP TIE' = "LIP TIE" 'LIP TIE REVISION' = "LIP TIE REVISION" 'LOOKED AT A SORE TOOTH' = "LOOKED AT A SORE TOOTH" 'LOSE TOOTH' = "LOSE TOOTH" 'MADE TRAY FOR WHITENING' = "MADE TRAY FOR WHITENING" 'MEASURED FOR CROWN' = "MEASURED FOR CROWN" 'MEAT EXTRACTION FROM TOOT' = "MEAT EXTRACTION FROM TOOT" 'MEDICATED SHOTS' = "MEDICATED SHOTS" 'MISSED THE APPOINTMENT' = "MISSED THE APPOINTMENT" 'MOLD FOR NIGHT GUARD' = "MOLD FOR NIGHT GUARD" 'MOLD FOR PARTIAL' = "MOLD FOR PARTIAL" 'MONTHLY TREATMENT' = "MONTHLY TREATMENT" 'MOULD OF MOUTH' = "MOULD OF MOUTH" 'MOUTH GUARD' = "MOUTH GUARD" 'MOUTH GUARD FITTING' = "MOUTH GUARD FITTING" 'MOUTH GUARD MADE' = "MOUTH GUARD MADE" 'MOUTH IMPRESIONS' = "MOUTH IMPRESIONS" 'MOUTH INFECTION' = "MOUTH INFECTION" 'MOUTHGUARD' = "MOUTHGUARD" 'MOUTHGUARD CHECKUP' = "MOUTHGUARD CHECKUP" 'NA' = "NA" 'NIGHT GUARD' = "NIGHT GUARD" 'NIGHT GUARD FITTING' = "NIGHT GUARD FITTING" 'NIGHT GUARD IMPRESSION' = "NIGHT GUARD IMPRESSION" 'NIGHT GUARD INCERTION' = "NIGHT GUARD INCERTION" 'NIGHTGUARD' = "NIGHTGUARD" 'NIGHTGUARD MOLDING' = "NIGHTGUARD MOLDING" 'NOT SEEN, SINUS INFECTION' = "NOT SEEN, SINUS INFECTION" 'NOTHING' = "NOTHING" 'ORAL CANCER CHECK' = "ORAL CANCER CHECK" 'ORAL CANCER SCREENING' = "ORAL CANCER SCREENING" 'ORAL EVALUATION' = "ORAL EVALUATION" 'OVERBITE PAIN' = "OVERBITE PAIN" 'PAIN' = "PAIN" 'PAIN DUE TO FILLING' = "PAIN DUE TO FILLING" 'PAIN FROM FILLING' = "PAIN FROM FILLING" 'PAIN INJECTION' = "PAIN INJECTION" 'PAINT ON RECSESSION OF GU' = "PAINT ON RECSESSION OF GU" 'PALADAR' = "PALADAR" 'PARTIAL PLATES & FITTING' = "PARTIAL PLATES & FITTING" 'PICK-UP MOUTH GUARD' = "PICK-UP MOUTH GUARD" 'PICTURES OF TEETH FOR INV' = "PICTURES OF TEETH FOR INV" 'PLUG/BUILDUP' = "PLUG/BUILDUP" 'PORCELIN TEETH' = "PORCELIN TEETH" 'POST OP' = "POST OP" 'POST OP CK' = "POST OP CK" 'POST OP VISIT' = "POST OP VISIT" 'POST OPERATIVE FOLLOW' = "POST OPERATIVE FOLLOW" 'PREO0 VISIT' = "PREO0 VISIT" 'PREOP AND IMPRESSIONS' = "PREOP AND IMPRESSIONS" 'PREVENTATIVE ANTIBIOTIC' = "PREVENTATIVE ANTIBIOTIC" 'PROCEDURE' = "PROCEDURE" 'PROCEEDURE/ TOOTH REPAIR' = "PROCEEDURE/ TOOTH REPAIR" 'PROVIDED PRX FOR INFECTIO' = "PROVIDED PRX FOR INFECTIO" 'REBUILDING NEW CROWN' = "REBUILDING NEW CROWN" 'REBUILT 3 TEETH' = "REBUILT 3 TEETH" 'REBUILT TOOTH' = "REBUILT TOOTH" 'RECEVIED NIGHT GUARD' = "RECEVIED NIGHT GUARD" 'REMOVE STITCHES' = "REMOVE STITCHES" 'REMOVE TOOTH FRAGMENT-GUM' = "REMOVE TOOTH FRAGMENT-GUM" 'REMOVED STICHES' = "REMOVED STICHES" 'REMOVED STITCHES' = "REMOVED STITCHES" 'REPAIR OF TEETH PST ACCID' = "REPAIR OF TEETH PST ACCID" 'REPAIRED TOOTH' = "REPAIRED TOOTH" 'RESEMENTING' = "RESEMENTING" 'RESIN AND OCC GUARD' = "RESIN AND OCC GUARD" 'ROOT PLAN' = "ROOT PLAN" 'SANDING BROKEN TOOTH' = "SANDING BROKEN TOOTH" 'SENT AWAY FEVER PATIENT' = "SENT AWAY FEVER PATIENT" 'SEVER LIGAMENT OF TOP LIP' = "SEVER LIGAMENT OF TOP LIP" 'SHAVE TEETH' = "SHAVE TEETH" 'SHAVED MY TOOTH DOWN' = "SHAVED MY TOOTH DOWN" 'SHAVING OF A TOOTH' = "SHAVING OF A TOOTH" 'SHOWING RESULTS OF XRAY' = "SHOWING RESULTS OF XRAY" 'SILVER DIAMINE FLOURIDE' = "SILVER DIAMINE FLOURIDE" 'SINUS CLEANED OUT' = "SINUS CLEANED OUT" 'SINUS SURGERY PROCEDURE' = "SINUS SURGERY PROCEDURE" 'SLEEP APNEA' = "SLEEP APNEA" 'SLEEP APNEA DEVICE' = "SLEEP APNEA DEVICE" 'SMOOTHED BROKEN TOOTH' = "SMOOTHED BROKEN TOOTH" 'SMOOTHED FRONT TOOTH' = "SMOOTHED FRONT TOOTH" 'SPLINT' = "SPLINT" 'SPOT IN MOUTH' = "SPOT IN MOUTH" 'STICHES REMOVED' = "STICHES REMOVED" 'STITCHES OUT' = "STITCHES OUT" 'STITCHES REMOVED' = "STITCHES REMOVED" 'STITCHES REMOVED FROM EXT' = "STITCHES REMOVED FROM EXT" 'SURGERY -- BRIDGE' = "SURGERY -- BRIDGE" 'SUTURE CHECKUP' = "SUTURE CHECKUP" 'SUTURE REMOVAL' = "SUTURE REMOVAL" 'SUTURE REMOVAL FOLLOWINGY' = "SUTURE REMOVAL FOLLOWINGY" 'TALK ABOUT BILL' = "TALK ABOUT BILL" 'TEAR IN GUM' = "TEAR IN GUM" 'TEETH BLEACHING' = "TEETH BLEACHING" 'TEETH GRINDING' = "TEETH GRINDING" 'TEETH WAITENING' = "TEETH WAITENING" 'TEETH WHITENING' = "TEETH WHITENING" 'TEETH WHITENING KIT' = "TEETH WHITENING KIT" 'TEETH WHITENING PREP' = "TEETH WHITENING PREP" 'TEMPORARY POST' = "TEMPORARY POST" 'TEMPORARY POSTS' = "TEMPORARY POSTS" 'TEST' = "TEST" 'TISSUE BRIDGES WERE CUT' = "TISSUE BRIDGES WERE CUT" 'TMG ISSUE' = "TMG ISSUE" 'TMJ' = "TMJ" 'TMJ MOUTHPIECE' = "TMJ MOUTHPIECE" 'TONGUE' = "TONGUE" 'TONGUE AND LIP TIE SURGER' = "TONGUE AND LIP TIE SURGER" 'TONGUE TIE' = "TONGUE TIE" 'TOOK CAP OFF AND REMOVED' = "TOOK CAP OFF AND REMOVED" 'TOOK IMPRESSION' = "TOOK IMPRESSION" 'TOOK IMPRESSION OF MOUTH' = "TOOK IMPRESSION OF MOUTH" 'TOOTH ACHE' = "TOOTH ACHE" 'TOOTH GLUED BACK' = "TOOTH GLUED BACK" 'TOOTH INFECTION' = "TOOTH INFECTION" 'TOOTH PAIN' = "TOOTH PAIN" 'TOOTH REBUILD' = "TOOTH REBUILD" 'TOOTH REBUILT' = "TOOTH REBUILT" 'TOOTH REPAIR' = "TOOTH REPAIR" 'TOOTH ROOTS' = "TOOTH ROOTS" 'TOOTH TEST' = "TOOTH TEST" 'TOUGUE PROBLEMS' = "TOUGUE PROBLEMS" 'TOUNGH TIED CLIP' = "TOUNGH TIED CLIP" 'TRAY FOR TMJ TREATMENT' = "TRAY FOR TMJ TREATMENT" 'UNABLE TO PREFORM TEETH R' = "UNABLE TO PREFORM TEETH R" 'UV TREATMENT' = "UV TREATMENT" 'VENEERS' = "VENEERS" 'VIRTURAL VISIT' = "VIRTURAL VISIT" 'WHITENING' = "WHITENING" 'WROTE PRESCRIPTION' = "WROTE PRESCRIPTION" ; VALUE DENTPROCF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE DENTPROXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE DENTYPE_M18F -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE DNSPCLST_M18F -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE DUIDF 2320012 - 2579869 = "VALID ID" ; VALUE $DUPERSIDF '2320012102' - '2579869104' = "VALID ID" ; VALUE DVDATEMMF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 - 12 = "1-12 MONTH" ; VALUE DVDATEYRF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 2020 = "2020" ; VALUE DVMD20XF 0 = "0" 1.91 - 78.3 = "$1.91 - $78.30" 78.31 - 114.84 = "$78.31 - $114.84" 114.85 - 191.4 = "$114.85 - $191.40" 191.41 - 8505.75 = "$191.41 - $8,505.75" ; VALUE DVMR20XF 0 = "0" 3.61 - 105 = "$3.61 - $105.00" 105.01 - 154.51 = "$105.01 - $154.51" 154.52 - 274 = "$154.52 - $274.00" 274.01 - 5999 = "$274.01 - $5,999.00" ; VALUE DVOF20XF 0 = "0" 22.5 - 76.74 = "$22.50 - $76.74" 76.75 - 257.52 = "$76.75 - $257.52" 257.53 - 730.5 = "$257.53 - $730.50" 730.51 - 3030 = "$730.51 - $3,030.00" ; VALUE DVOT20XF 0 = "0" 5 - 36.5 = "$5.00 - $36.50" 36.51 - 83 = "$36.51 - $83.00" 83.01 - 155 = "$83.01 - $155.00" 155.01 - 5955 = "$155.01 - $5,955.00" ; VALUE DVPV20XF 0 = "0" 1 - 110.22 = "$1.00 - $110.22" 110.23 - 159 = "$110.23 - $159.00" 159.01 - 252 = "$159.01 - $252.00" 252.01 - 19000 = "$252.01 - $19,000.00" ; VALUE DVSF20XF 0 = "0" 1 - 50 = "$1.00 - $50.00" 50.01 - 124 = "$50.01 - $124.00" 124.01 - 280 = "$124.01 - $280.00" 280.01 - 60000 = "$280.01 - $60,000.00" ; VALUE DVSL20XF 0 = "0" 100 - 147.3 = "$100.00 - $147.30" 147.31 - 236 = "$147.31 - $236.00" 236.01 - 251.93 = "$236.01 - $251.93" 251.94 - 799 = "$251.94 - $799.00" ; VALUE DVTC20XF 0 = "0" 50 - 142 = "$50.00 - $142.00" 142.01 - 208 = "$142.01 - $208.00" 208.01 - 365 = "$208.01 - $365.00" 365.01 - 60000 = "$365.01 - $60,000.00" ; VALUE DVTR20XF 0 = "0" 14 - 52.53 = "$14.00 - $52.53" 52.54 - 102.5 = "$52.54 - $102.50" 102.51 - 195 = "$102.51 - $195.00" 195.01 - 4018 = "$195.01 - $4,018.00" ; VALUE DVVA20XF 0 = "0" 25 - 90.65 = "$25.00 - $90.65" 90.66 - 123.28 = "$90.66 - $123.28" 123.29 - 171 = "$123.29 - $171.00" 171.01 - 5997 = "$171.01 - $5,997.00" ; VALUE DVWC20XF 0 = "0" 99 = "$99.00" ; VALUE DVXP20XF 0 = "0" 30.16 - 117 = "$30.16 - $117.00" 117.01 - 173.05 = "$117.01 - $173.05" 173.06 - 300 = "$173.06 - $300.00" 300.01 - 60000 = "$300.01 - $60,000.00" ; VALUE EVENTRNF 1 = "1 ROUND 1" 2 = "2 ROUND 2" 3 = "3 ROUND 3" 4 = "4 ROUND 4" 5 = "5 ROUND 5" 6 = "6 ROUND 6" 7 = "7 ROUND 7" ; VALUE $EVNTIDXF '2320012102203301' - '2579869104000401' = "VALID ID" ; VALUE EXAMINE_M18F -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE FFBEF20F -15 = "-15 CANNOT BE COMPUTED" -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 0 = "0" 1 - 50 = "1 - 50" ; VALUE FFDVTYPEF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 FLAT FEE STEM" 2 = "2 FLAT FEE LEAF" ; VALUE $FFEEIDXF '-1' = "-1 INAPPLICABLE" '232004310102' - 'DN257924910102' = "VALID ID" ; VALUE FFTOT21F -15 = "-15 CANNOT BE COMPUTED" -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 0 = "0" 1 - 7 = "1 - 7" ; VALUE FILLINGXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE FILLING_M18F -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE FLUORIDE_M18F -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE GENDENT_M18F -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE GUMSURGXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE GUMSURG_M18F -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 IMPLANTXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE IMPLANT_M18F -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE JUSTXRAY_M18F -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE JUSTXRYXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE ORALSURG_M18F -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE ORALSURXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE ORTHDONT_M18F -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE ORTHDONXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE PANELF 23 = "23 PANEL 23" 24 = "24 PANEL 24" 25 = "25 PANEL 25" ; VALUE PEDDENT_M18F -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE PERWT20FF 0 = "0.000000" 381.503233 - 92787.225297 = "381.503233 - 92787.225297" ; VALUE PIDF 101 - 501 = "VALID ID" ; VALUE ROOTCANL_M18F -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE ROOTCANXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE SEALANTXF -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE SEALANT_M18F -8 = "-8 DK" -7 = "-7 REFUSED" -1 = "-1 INAPPLICABLE" 1 = "1 YES" 2 = "2 NO" ; VALUE VARPSUF 1 - 6 = "1 - 6 VARPSU" ; VALUE VARSTRF 2001 - 2117 = "2001 - 2117 VARSTR" ;