SAS User File for H239B 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 (H239B.SSP) or the ASCII data file (H239B.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\H239B.SSP';                                                
                                                                                                    
     PROC CIMPORT DATA=PUFLIB.H239B 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.H239B;                                                          
     TITLE 'List of Variables in MEPS H239B SAS Dataset';                                      
     RUN;                                                                                           
                                                                                                    
     PROC PRINT DATA=PUFLIB.H239B (OBS=20);                                                    
     TITLE 'First 20 Observations in MEPS H239B 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)  H239B 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                        
     H239B.SAS7BDAT will be created under the C:\MEPS\SASDATA directory when                   
     PROC CIMPORT runs successfully.                                                                
                                                                                                    
     4)  The SAS transport file H239B.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 H239B.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 H239B.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\H239B.DAT';                                                
                                                                                                    
     DATA PUFLIB.H239B;                                                                        
     INFILE IN1 LRECL=235;                                                                     
     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 (H239B).  In the example, after the successful                    
completion of the DATA step, a PC file named H239B.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 (235                        
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 H239B.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., 235 for H239B.DAT).  If RECFM=F is used, then the                    
LRECL value must  be specified as the logical record length plus 2 (237 for            
H239B.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 (235 for H239B.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 (H239B.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.H239B;                                                              
     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 H239B.DAT file into a SAS dataset, and for creating                       
SAS formats.                                                                                        
                                                                                                    
* INPUT STATEMENTS;
INFILE IN LRECL=235;

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     EXAMINEX                          2.0
      @72     CLENTETX                          2.0
      @74     JUSTXRYX                          2.0
      @76     FLUORIDX                          2.0
      @78     SEALANTX                          2.0
      @80     FILLINGX                          2.0
      @82     ROOTCANX                          2.0
      @84     GUMSURGX                          2.0
      @86     IMPLANTX                          2.0
      @88     ORALSURX                          2.0
      @90     BRIDGESX                          2.0
      @92     ORTHDONX                          2.0
      @94     DENTPROX                          2.0
      @96     DENTOTHX                         $25.0
      @121    FFDVTYPE                          2.0
      @123    FFBEF22                           3.0
      @126    FFTOT23                           3.0
      @129    DVSF22X                           8.2
      @137    DVMR22X                           8.2
      @145    DVMD22X                           7.2
      @152    DVPV22X                           8.2
      @160    DVVA22X                           7.2
      @167    DVTR22X                           7.2
      @174    DVOF22X                           7.2
      @181    DVSL22X                           7.2
      @188    DVWC22X                           6.2
      @194    DVOT22X                           7.2
      @201    DVXP22X                           8.2
      @209    DVTC22X                           8.2
      @217    IMPFLAG                           1.0
      @218    PERWT22F                          13.6
      @231    VARSTR                            4.0
      @235    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.
       EXAMINEX                          EXAMINEXF.
       CLENTETX                          CLENTETXF.
       JUSTXRYX                          JUSTXRYXF.
       FLUORIDX                          FLUORIDXF.
       SEALANTX                          SEALANTXF.
       FILLINGX                          FILLINGXF.
       ROOTCANX                          ROOTCANXF.
       GUMSURGX                          GUMSURGXF.
       IMPLANTX                          IMPLANTXF.
       ORALSURX                          ORALSURXF.
       BRIDGESX                          BRIDGESXF.
       ORTHDONX                          ORTHDONXF.
       DENTPROX                          DENTPROXF.
       DENTOTHX                          $DENTOTHXF.
       FFDVTYPE                          FFDVTYPEF.
       FFBEF22                           FFBEF22F.
       FFTOT23                           FFTOT23F.
       DVSF22X                           DVSF22XF.
       DVMR22X                           DVMR22XF.
       DVMD22X                           DVMD22XF.
       DVPV22X                           DVPV22XF.
       DVVA22X                           DVVA22XF.
       DVTR22X                           DVTR22XF.
       DVOF22X                           DVOF22XF.
       DVSL22X                           DVSL22XF.
       DVWC22X                           DVWC22XF.
       DVOT22X                           DVOT22XF.
       DVXP22X                           DVXP22XF.
       DVTC22X                           DVTC22XF.
       IMPFLAG                           IMPFLAGF.
       PERWT22F                          PERWT22FF.
       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"
      EXAMINEX                         ="GENERAL EXAM, CHECKUP OR CONSULTATION - EDITED"
      CLENTETX                         ="CLEANING, PROPHYLAXIS, POLISHING OR PERIODONTAL RECALL - EDITED"
      JUSTXRYX                         ="X-RAYS, RADIOGRAPHS OR BITEWINGS - EDITED"
      FLUORIDX                         ="FLUORIDE TREATMENT - EDITED"
      SEALANTX                         ="SEALANT APPLICATION - EDITED"
      FILLINGX                         ="FILLINGS, INLAYS, CROWNS OR CAPS - EDITED"
      ROOTCANX                         ="ROOT CANAL - EDITED"
      GUMSURGX                         ="PERIODONTAL SCALING, ROOT PLANING OR GUM SURGERY - EDITED"
      IMPLANTX                         ="IMPLANTS - EDITED"
      ORALSURX                         ="EXTRACTION, TOOTH PULLED OR OTH ORAL SURGERY - EDITED"
      BRIDGESX                         ="FIXED OR RELINING/REPAIR OF BRIDGES/DENTURES, REMOVABLE DENTURES - EDITED"
      ORTHDONX                         ="ORTHODONTIA, BRACES OR RETAINERS - EDITED"
      DENTPROX                         ="OTHER DENTAL PROCEDURES - EDITED"
      DENTOTHX                         ="OTHER SPECIFY DENTAL PROCEDURES - EDITED"
      FFDVTYPE                         ="FLAT FEE BUNDLE"
      FFBEF22                          ="TOTAL # OF VISITS IN FF BEFORE 2022"
      FFTOT23                          ="TOTAL # OF VISITS IN FF AFTER 2022"
      DVSF22X                          ="AMOUNT PAID, FAMILY (IMPUTED)"
      DVMR22X                          ="AMOUNT PAID, MEDICARE (IMPUTED)"
      DVMD22X                          ="AMOUNT PAID, MEDICAID (IMPUTED)"
      DVPV22X                          ="AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)"
      DVVA22X                          ="AMOUNT PAID, VETERANS/CHAMPVA (IMPUTED)"
      DVTR22X                          ="AMOUNT PAID, TRICARE (IMPUTED)"
      DVOF22X                          ="AMOUNT PAID, OTHER FEDERAL (IMPUTED)"
      DVSL22X                          ="AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)"
      DVWC22X                          ="AMOUNT PAID, WORKERS COMP (IMPUTED)"
      DVOT22X                          ="AMOUNT PAID, OTHER INSURANCE (IMPUTED)"
      DVXP22X                          ="SUM OF DVSF22X - DVOT22X (IMPUTED)"
      DVTC22X                          ="HHLD REPORTED TOTAL CHARGE (IMPUTED)"
      IMPFLAG                          ="IMPUTATION STATUS"
      PERWT22F                         ="EXPENDITURE FILE PERSON WEIGHT, 2022"
      VARSTR                           ="VARIANCE ESTIMATION STRATUM, 2022"
      VARPSU                           ="VARIANCE ESTIMATION PSU, 2022"
;


* VALUE STATEMENTS;
VALUE BRIDGESXF  
  -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"
  'ABCESS' = "ABCESS"
  'ABSCESS' = "ABSCESS"
  'ABSESS' = "ABSESS"
  'ABSESS AND BONE GRAFT' = "ABSESS AND BONE GRAFT"
  'ABSESS TOOTH' = "ABSESS TOOTH"
  'ABYSS' = "ABYSS"
  'ADHERE MOLAR TO GUMS' = "ADHERE MOLAR TO GUMS"
  'ADJUSTED WHAT WAS DONE' = "ADJUSTED WHAT WAS DONE"
  'ADJUSTMENTS' = "ADJUSTMENTS"
  'AJUSTMENT' = "AJUSTMENT"
  'ANESTHESIA' = "ANESTHESIA"
  'ANTIBIOTIC' = "ANTIBIOTIC"
  'ANTIBIOTIC INSERTED GUMLI' = "ANTIBIOTIC INSERTED GUMLI"
  'ANTIBIOTIC TREATMENT' = "ANTIBIOTIC TREATMENT"
  'APPLIED ANTIBIOTIC' = "APPLIED ANTIBIOTIC"
  'APPOINTMENT WAS CANCELLED' = "APPOINTMENT WAS CANCELLED"
  'ASCESS' = "ASCESS"
  'AT HOME SLEEP STUDY' = "AT HOME SLEEP STUDY"
  'BIOPSY' = "BIOPSY"
  'BITE ADJUSTMENT' = "BITE ADJUSTMENT"
  'BITE AJUSTMENT' = "BITE AJUSTMENT"
  'BITE GUARD' = "BITE GUARD"
  'BITE GUARD MADE' = "BITE GUARD MADE"
  'BLOOD CHECK /CARDIO CHECK' = "BLOOD CHECK /CARDIO CHECK"
  'BLOOD PRESSURE CHECK' = "BLOOD PRESSURE CHECK"
  'BONDING' = "BONDING"
  'BONE DENSITY ISSUES' = "BONE DENSITY ISSUES"
  'BONE GRAFT' = "BONE GRAFT"
  'BONE GRAFTING' = "BONE GRAFTING"
  'BONE GRAPH' = "BONE GRAPH"
  'BONE INJECTED DIDNT WORK' = "BONE INJECTED DIDNT WORK"
  'BONE REPLACEMENT GRAFT' = "BONE REPLACEMENT GRAFT"
  'BOTOX INJECTION' = "BOTOX INJECTION"
  'BROKEN TOOTH REPAIR' = "BROKEN TOOTH REPAIR"
  'CAMERA PICTURES OF TEETH' = "CAMERA PICTURES OF TEETH"
  'CANCER SCANNING' = "CANCER SCANNING"
  'CANCER SCREENING' = "CANCER SCREENING"
  'CAST/MOLD OF TOOTH' = "CAST/MOLD OF TOOTH"
  'CEMENTED TOOTH, NOT IMPL' = "CEMENTED TOOTH, NOT IMPL"
  'CHECK SURGERY' = "CHECK SURGERY"
  'CHECKED A LESION' = "CHECKED A LESION"
  'CHECKING ENAMEL ON TEETH' = "CHECKING ENAMEL ON TEETH"
  'CHECKING PREP AND MEDS' = "CHECKING PREP AND MEDS"
  'CHIP TOOTH' = "CHIP TOOTH"
  'CLEANING & UV LIGHT' = "CLEANING & UV LIGHT"
  'CLEARANCE FOR KNEE SURGER' = "CLEARANCE FOR KNEE SURGER"
  'CLIP TONGUE TIE' = "CLIP TONGUE TIE"
  'COATED TOOTH ROOT W/ENAME' = "COATED TOOTH ROOT W/ENAME"
  'COMPREHENSIVE ORAL EVALUA' = "COMPREHENSIVE ORAL EVALUA"
  'CONE CT' = "CONE CT"
  'CONSOLTATION ON INVISULIN' = "CONSOLTATION ON INVISULIN"
  'CONSULT' = "CONSULT"
  'CONSULTATION' = "CONSULTATION"
  'CONSULTATION FOR SURGERY' = "CONSULTATION FOR SURGERY"
  'CONSULTATION OF RESTORATI' = "CONSULTATION OF RESTORATI"
  'CONSULTATION WISDOM TEETH' = "CONSULTATION WISDOM TEETH"
  'CORE BUILD UP' = "CORE BUILD UP"
  'COSMETIC' = "COSMETIC"
  'COVID TEST' = "COVID TEST"
  'CRACKED TOOTH PAIN' = "CRACKED TOOTH PAIN"
  'CRACKED TOOTH REPAIR' = "CRACKED TOOTH REPAIR"
  'CREAM' = "CREAM"
  'CT CAPTURE' = "CT CAPTURE"
  'CT SCAN' = "CT SCAN"
  'DECAY PREVENTION' = "DECAY PREVENTION"
  'DENTAL' = "DENTAL"
  'DENTAL EMERGENCY' = "DENTAL EMERGENCY"
  'DENTAL MESUREMENT' = "DENTAL MESUREMENT"
  'DENTAL MOUTH GUARD' = "DENTAL MOUTH GUARD"
  'DENTAL PAIN' = "DENTAL PAIN"
  'DENTAL PRESCRIPTION VISIT' = "DENTAL PRESCRIPTION VISIT"
  'DENTAL REFERRAL' = "DENTAL REFERRAL"
  'DENTEURS PROCEDURE' = "DENTEURS PROCEDURE"
  'DETAIL PICTURES TO GUARD' = "DETAIL PICTURES TO GUARD"
  'DIAGNOSED CRACKED TOOTH' = "DIAGNOSED CRACKED TOOTH"
  'DIAGNOSTIC ZYGOMATIC IMPL' = "DIAGNOSTIC ZYGOMATIC IMPL"
  'DK' = "DK"
  'DO NOT DO ANYTHING' = "DO NOT DO ANYTHING"
  'DRILLED FOR THE CROWN' = "DRILLED FOR THE CROWN"
  'EVALUATION PERIOTIC' = "EVALUATION PERIOTIC"
  'EXAM NO SURGERY' = "EXAM NO SURGERY"
  'EXTRACTIONS OF HARDWARE' = "EXTRACTIONS OF HARDWARE"
  'F/U FOR VENEERS' = "F/U FOR VENEERS"
  'FILE DOWN TOOTH' = "FILE DOWN TOOTH"
  'FILING DOWN CROWN' = "FILING DOWN CROWN"
  'FILLINGS AND EXTRACTIONS' = "FILLINGS AND EXTRACTIONS"
  'FITTED MOUTHGUARD' = "FITTED MOUTHGUARD"
  'FITTING' = "FITTING"
  'FITTING FOR A MOUTHGUARD' = "FITTING FOR A MOUTHGUARD"
  'FITTING FOR MOUTH GUARD' = "FITTING FOR MOUTH GUARD"
  'FIXED BROKEN TOOTH' = "FIXED BROKEN TOOTH"
  'FIXED CHIPPED TOOTH' = "FIXED CHIPPED TOOTH"
  'FIXING BROKEN TOOTH' = "FIXING BROKEN TOOTH"
  'FOLLOW UP' = "FOLLOW UP"
  'FOLLOW UP POST SUR' = "FOLLOW UP POST SUR"
  'FOLLOW UP TO SURGERY' = "FOLLOW UP TO SURGERY"
  'FOLLOW UP VISIT' = "FOLLOW UP VISIT"
  'FOLLOW-UP' = "FOLLOW-UP"
  'FOLLOW-UP FROM BONE GRAPH' = "FOLLOW-UP FROM BONE GRAPH"
  'FOLLOWUP' = "FOLLOWUP"
  'FOLLOWUP TO SURGURY ONLY' = "FOLLOWUP TO SURGURY ONLY"
  'FOLLOWUP VISIT' = "FOLLOWUP VISIT"
  'FOUND ABSEST' = "FOUND ABSEST"
  'FRACTURED TOOTH' = "FRACTURED TOOTH"
  'FREE FOLLOW UP' = "FREE FOLLOW UP"
  'FU FROM PULLED TOOTH' = "FU FROM PULLED TOOTH"
  'GENERAL CHECK UP' = "GENERAL CHECK UP"
  'GLUED IT TEMPORARILY' = "GLUED IT TEMPORARILY"
  'GRIND DOWN BONE SPUR' = "GRIND DOWN BONE SPUR"
  'GUMS' = "GUMS"
  'IMPLANT AND FOLLOWUP' = "IMPLANT AND FOLLOWUP"
  'IMPRESIONS' = "IMPRESIONS"
  'IMPRESSION' = "IMPRESSION"
  'IMPRESSION UPPER MOUTH' = "IMPRESSION UPPER MOUTH"
  'IMPRESSIONS' = "IMPRESSIONS"
  'IMPRESSIONS OF DENTAL' = "IMPRESSIONS OF DENTAL"
  'INFECTION' = "INFECTION"
  'INFECTION AROUND WISDOM T' = "INFECTION AROUND WISDOM T"
  'INFECTION IN CROWN' = "INFECTION IN CROWN"
  'INVISILIGN CANCLLED' = "INVISILIGN CANCLLED"
  'INVISILINE' = "INVISILINE"
  'JAW OUT OF WACK' = "JAW OUT OF WACK"
  'JAW PAIN' = "JAW PAIN"
  'JAW PAIN -NERVE' = "JAW PAIN -NERVE"
  'JAW PAIN EMERGENCY VISIT' = "JAW PAIN EMERGENCY VISIT"
  'LASER THERAPY' = "LASER THERAPY"
  'LESION REMOVAL' = "LESION REMOVAL"
  'LTD ORAL EVAL PROBLEM FOC' = "LTD ORAL EVAL PROBLEM FOC"
  'MADE CORRECTIONS' = "MADE CORRECTIONS"
  'MADE TOOTH MOLD' = "MADE TOOTH MOLD"
  'MAGO' = "MAGO"
  'MEASUREMENTS, PHOTOGRAPHS' = "MEASUREMENTS, PHOTOGRAPHS"
  'MOLD FOR DENTAL WHITEING' = "MOLD FOR DENTAL WHITEING"
  'MOLD FOR GUARD' = "MOLD FOR GUARD"
  'MOLD FOR WHITENING FIXTUR' = "MOLD FOR WHITENING FIXTUR"
  'MOLD OF TEETH' = "MOLD OF TEETH"
  'MOLD TAKING OF TEETH' = "MOLD TAKING OF TEETH"
  'MOLDS OF GUMS' = "MOLDS OF GUMS"
  'MOLDS SENT OUT FOR CROWNS' = "MOLDS SENT OUT FOR CROWNS"
  'MOULDS' = "MOULDS"
  'MOUTH GUARD' = "MOUTH GUARD"
  'MOUTH GUARD FITING' = "MOUTH GUARD FITING"
  'MOUTH GUARD FITTING' = "MOUTH GUARD FITTING"
  'MOUTHGUARD' = "MOUTHGUARD"
  'MOUTHGUARD FITTING' = "MOUTHGUARD FITTING"
  'MUSCLE SPASAM ON JAW' = "MUSCLE SPASAM ON JAW"
  'NIGHT GUARD' = "NIGHT GUARD"
  'NIGHT GUARD FITTING' = "NIGHT GUARD FITTING"
  'NIGHTGUARD' = "NIGHTGUARD"
  'NIGHTGUARD SCAN AND FITTI' = "NIGHTGUARD SCAN AND FITTI"
  'NO TREATMENT/PAT REF' = "NO TREATMENT/PAT REF"
  'NOT A VISIT ERROR' = "NOT A VISIT ERROR"
  'NOTHING' = "NOTHING"
  'NOTHING WAS DONE' = "NOTHING WAS DONE"
  'OCCLUSION GRINDING GUARD' = "OCCLUSION GRINDING GUARD"
  'ODONTOPLASTY' = "ODONTOPLASTY"
  'ONGOING DENTAL CARE' = "ONGOING DENTAL CARE"
  'OPINION ON IMPLANTS' = "OPINION ON IMPLANTS"
  'ORAL APPLIANCE/SLEEP AP' = "ORAL APPLIANCE/SLEEP AP"
  'ORAL CANCER SCREENING' = "ORAL CANCER SCREENING"
  'ORAL EXAM FOR MOUTH GUARD' = "ORAL EXAM FOR MOUTH GUARD"
  'ORTHOPEDICE SURGEON' = "ORTHOPEDICE SURGEON"
  'PAIN ON ONE TEETH' = "PAIN ON ONE TEETH"
  'PASTE WAS PUT ON TOOTH' = "PASTE WAS PUT ON TOOTH"
  'PERIAPICAL' = "PERIAPICAL"
  'PHOTO OF FRACTURED' = "PHOTO OF FRACTURED"
  'PLAN FOR UPPER QUADRANT' = "PLAN FOR UPPER QUADRANT"
  'POST OP CHECK' = "POST OP CHECK"
  'POST OP EXAM' = "POST OP EXAM"
  'PRE CAVITY TREATMENT' = "PRE CAVITY TREATMENT"
  'PRE SURGEY CHECK' = "PRE SURGEY CHECK"
  'PREP FOR GETTTING STEM' = "PREP FOR GETTTING STEM"
  'PREPARATION FOR SURGERY' = "PREPARATION FOR SURGERY"
  'PREPARE FOR KNEE SURGERY' = "PREPARE FOR KNEE SURGERY"
  'PREVENTATIVE' = "PREVENTATIVE"
  'PROCEDURE FOR ABSESS' = "PROCEDURE FOR ABSESS"
  'PULLED/TISSUE REG/GRAFT' = "PULLED/TISSUE REG/GRAFT"
  'REABSORPTION' = "REABSORPTION"
  'REALIGNMENT' = "REALIGNMENT"
  'RECEIVED MOUTHGUARD' = "RECEIVED MOUTHGUARD"
  'RECHECK' = "RECHECK"
  'RECHECK BECAUSE STILL PAI' = "RECHECK BECAUSE STILL PAI"
  'REDO IMPRESSION' = "REDO IMPRESSION"
  'REMOVAL OF A LESION' = "REMOVAL OF A LESION"
  'REMOVED SCREWS' = "REMOVED SCREWS"
  'REMOVED STITCHES' = "REMOVED STITCHES"
  'REPAIR CHIPPED VENEER' = "REPAIR CHIPPED VENEER"
  'REPAIR TOOTH ENAMEL DEGRA' = "REPAIR TOOTH ENAMEL DEGRA"
  'REPAIRS' = "REPAIRS"
  'REPROFILED FRONT TOOTH' = "REPROFILED FRONT TOOTH"
  'RESIN AND COMPOSITES' = "RESIN AND COMPOSITES"
  'RESIN PLUS POSTERIOR' = "RESIN PLUS POSTERIOR"
  'ROOTS LAZER SURGERY' = "ROOTS LAZER SURGERY"
  'SCAN FOR NIGHTGUARD' = "SCAN FOR NIGHTGUARD"
  'SCRAPED TOOTH TO PUT ANTI' = "SCRAPED TOOTH TO PUT ANTI"
  'SCRAPING' = "SCRAPING"
  'SCREENING FOR ORAL CANCER' = "SCREENING FOR ORAL CANCER"
  'SEDATION' = "SEDATION"
  'SET UP MORE EXTRACTIONS' = "SET UP MORE EXTRACTIONS"
  'SHAVED TOOTH WITH CHIP' = "SHAVED TOOTH WITH CHIP"
  'SHOWED UP NO SERVICES' = "SHOWED UP NO SERVICES"
  'SLEEP APNEA' = "SLEEP APNEA"
  'SLEEP APNEA DEVICE' = "SLEEP APNEA DEVICE"
  'SLEEP APNEA PIECE' = "SLEEP APNEA PIECE"
  'SLEEP APNEA PIECE PLACEME' = "SLEEP APNEA PIECE PLACEME"
  'SLEEP APNEA TREATMENT' = "SLEEP APNEA TREATMENT"
  'SLEEP APNES PIECE PLACEME' = "SLEEP APNES PIECE PLACEME"
  'SLEEP CONSULTATION' = "SLEEP CONSULTATION"
  'SLEEP STUDY RESULTS' = "SLEEP STUDY RESULTS"
  'SMOOTH THE TOOTH' = "SMOOTH THE TOOTH"
  'SMOOTHING' = "SMOOTHING"
  'SORE GUM' = "SORE GUM"
  'SORE MOUTH' = "SORE MOUTH"
  'STICHES REMOVED' = "STICHES REMOVED"
  'SURFUS POSTERS' = "SURFUS POSTERS"
  'SURGERY' = "SURGERY"
  'SURGERY FOLLOW-UP' = "SURGERY FOLLOW-UP"
  'SURGICAL GUIDE' = "SURGICAL GUIDE"
  'SUTURE REMOVAL' = "SUTURE REMOVAL"
  'SWOLLEN GUMS' = "SWOLLEN GUMS"
  'TEETH GRINDING' = "TEETH GRINDING"
  'TEETH IMPRESSION' = "TEETH IMPRESSION"
  'TEETH RELINE' = "TEETH RELINE"
  'TEETH WHITENING' = "TEETH WHITENING"
  'TELEHEALTH CONTINUATION' = "TELEHEALTH CONTINUATION"
  'TEMPORARY NIGHT GUARD' = "TEMPORARY NIGHT GUARD"
  'TEMPORARY TOOTH' = "TEMPORARY TOOTH"
  'THREE DENTAL SPLINTS' = "THREE DENTAL SPLINTS"
  'TIED TONGUE PROCEDURE' = "TIED TONGUE PROCEDURE"
  'TIED TONGUE SURGERY' = "TIED TONGUE SURGERY"
  'TMJ SPLINT' = "TMJ SPLINT"
  'TO SEE THE RESULTS OF EXA' = "TO SEE THE RESULTS OF EXA"
  'TONGUE' = "TONGUE"
  'TONGUE TIDE' = "TONGUE TIDE"
  'TONGUE TIE' = "TONGUE TIE"
  'TONGUE TIED PROCEDURE' = "TONGUE TIED PROCEDURE"
  'TONGUETIE' = "TONGUETIE"
  'TOOK MOLD' = "TOOK MOLD"
  'TOOTH' = "TOOTH"
  'TOOTH ACHE' = "TOOTH ACHE"
  'TOOTH ACHE ABCESS' = "TOOTH ACHE ABCESS"
  'TOOTH ADJUSTMENT' = "TOOTH ADJUSTMENT"
  'TOOTH BONDING' = "TOOTH BONDING"
  'TOOTH EXTRACTION' = "TOOTH EXTRACTION"
  'TOOTH FILED DOWN' = "TOOTH FILED DOWN"
  'TOOTH FILING' = "TOOTH FILING"
  'TOOTH GUARD' = "TOOTH GUARD"
  'TOOTH PAIN' = "TOOTH PAIN"
  'TOOTH REPAIR' = "TOOTH REPAIR"
  'TOOTH SANDING' = "TOOTH SANDING"
  'TOOTHACHE' = "TOOTHACHE"
  'TOUGUE CRISP' = "TOUGUE CRISP"
  'UNKNOWN SURGERY' = "UNKNOWN SURGERY"
  'UPPER LIP TIE REMOVED' = "UPPER LIP TIE REMOVED"
  'WHITENING' = "WHITENING"
  'WHITING' = "WHITING"
  'WIRE CHANGE' = "WIRE CHANGE"
  ;
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  
  2460006 - 2799694 = "VALID ID"
  ;
VALUE $DUPERSIDF  
  '2460006101' - '2799694101' = "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"
  2022 = "2022"
  ;
VALUE DVMD22XF  
  0 = "0"
  8.16 - 84.5 = "$8.16 - $84.50"
  84.51 - 127.95 = "$84.51 - $127.95"
  127.96 - 232 = "$127.96 - $232.00"
  232.01 - 5800 = "$232.01 - $5,800.00"
  ;
VALUE DVMR22XF  
  0 = "0"
  10 - 110.31 = "$10.00 - $110.31"
  110.32 - 156.1 = "$110.32 - $156.10"
  156.11 - 292 = "$156.11 - $292.00"
  292.01 - 16216.31 = "$292.01 - $16,216.31"
  ;
VALUE DVOF22XF  
  0 = "0"
  20 - 33.75 = "$20.00 - $33.75"
  33.76 - 85 = "$33.76 - $85.00"
  85.01 - 150 = "$85.01 - $150.00"
  150.01 - 2380 = "$150.01 - $2,380.00"
  ;
VALUE DVOT22XF  
  0 = "0"
  17 - 90.28 = "$17.00 - $90.28"
  90.29 - 150 = "$90.29 - $150.00"
  150.01 - 261.15 = "$150.01 - $261.15"
  261.16 - 3096.87 = "$261.16 - $3,096.87"
  ;
VALUE DVPV22XF  
  0 = "0"
  1 - 115 = "$1.00 - $115.00"
  115.01 - 165 = "$115.01 - $165.00"
  165.01 - 258.07 = "$165.01 - $258.07"
  258.08 - 15975 = "$258.08 - $15,975.00"
  ;
VALUE DVSF22XF  
  0 = "0"
  1 - 50 = "$1.00 - $50.00"
  50.01 - 130 = "$50.01 - $130.00"
  130.01 - 300 = "$130.01 - $300.00"
  300.01 - 31000 = "$300.01 - $31,000.00"
  ;
VALUE DVSL22XF  
  0 = "0"
  55 - 56.72 = "$55.00 - $56.72"
  56.73 - 301.78 = "$56.73 - $301.78"
  301.79 - 600 = "$301.79 - $600.00"
  600.01 - 7992 = "$600.01 - $7,992.00"
  ;
VALUE DVTC22XF  
  0 = "0"
  47.13 - 152.03 = "$47.13 - $152.03"
  152.04 - 225.92 = "$152.04 - $225.92"
  225.93 - 400 = "$225.93 - $400.00"
  400.01 - 31000 = "$400.01 - $31,000.00"
  ;
VALUE DVTR22XF  
  0 = "0"
  11 - 80.59 = "$11.00 - $80.59"
  80.6 - 135.28 = "$80.60 - $135.28"
  135.29 - 260.16 = "$135.29 - $260.16"
  260.17 - 6088.62 = "$260.17 - $6,088.62"
  ;
VALUE DVVA22XF  
  0 = "0"
  14 - 135 = "$14.00 - $135.00"
  135.01 - 173.78 = "$135.01 - $173.78"
  173.79 - 261.2 = "$173.79 - $261.20"
  261.21 - 2500 = "$261.21 - $2,500.00"
  ;
VALUE DVWC22XF  
  0 = "0"
  275 - 458.92 = "$275.00 - $458.92"
  ;
VALUE DVXP22XF  
  0 = "0"
  30.74 - 124.91 = "$30.74 - $124.91"
  124.92 - 185.64 = "$124.92 - $185.64"
  185.65 - 331 = "$185.65 - $331.00"
  331.01 - 31000 = "$331.01 - $31,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"
  8 = "8 ROUND 8"
  9 = "9 ROUND 9"
  ;
VALUE $EVNTIDXF  
  '2460006101009801' - '2799694101003401' = "VALID ID"
  ;
VALUE EXAMINEXF  
  -8 = "-8 DK"
  -7 = "-7 REFUSED"
  -1 = "-1 INAPPLICABLE"
  1 = "1 YES"
  2 = "2 NO"
  ;
VALUE FFBEF22F  
  -15 = "-15 CANNOT BE COMPUTED"
  -8 = "-8 DK"
  -7 = "-7 REFUSED"
  -1 = "-1 INAPPLICABLE"
  0 = "0"
  1 - 60 = "1 - 60"
  ;
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"
  '246000610102' - 'DN279919010101' = "VALID ID"
  ;
VALUE FFTOT23F  
  -15 = "-15 CANNOT BE COMPUTED"
  -8 = "-8 DK"
  -7 = "-7 REFUSED"
  -1 = "-1 INAPPLICABLE"
  0 = "0"
  1 - 50 = "1 - 50"
  ;
VALUE FILLINGXF  
  -8 = "-8 DK"
  -7 = "-7 REFUSED"
  -1 = "-1 INAPPLICABLE"
  1 = "1 YES"
  2 = "2 NO"
  ;
VALUE FLUORIDXF  
  -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 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 JUSTXRYXF  
  -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 ORTHDONXF  
  -8 = "-8 DK"
  -7 = "-7 REFUSED"
  -1 = "-1 INAPPLICABLE"
  1 = "1 YES"
  2 = "2 NO"
  ;
VALUE PANELF  
  24 = "24 PANEL 24"
  26 = "26 PANEL 26"
  27 = "27 PANEL 27"
  ;
VALUE PEDDENT_M18F  
  -8 = "-8 DK"
  -7 = "-7 REFUSED"
  -1 = "-1 INAPPLICABLE"
  1 = "1 YES"
  2 = "2 NO"
  ;
VALUE PERWT22FF  
  0 = "0.000000"
  405.007613 - 117275.917612 = "405.007613 - 117275.917612"
  ;
VALUE PIDF  
  101 - 501 = "VALID ID"
  ;
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 VARPSUF  
  1 - 8 = "1 - 8"
  ;
VALUE VARSTRF  
  2001 - 2117 = "2001 - 2117"
  ;