SAS User File for H36BRR18 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 (H36BRR18.SSP) or the ASCII data file (H36BRR18.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: XCOPY. Section B provides a sample SAS program for the second alternative, which is to read data from the ASCII data file using a SAS DATA step with INFILE, INPUT, and LABEL statements. Section C explains format-related SAS statements that a user may optionally use when working with the SAS dataset. Examples of SAS programs (DATA step or PROC) are provided in all three sections, primarily for the benefit of inexperienced users. Section D contains complete SAS statements that must be used in the programs described in Sections B and C. INCLUDED BELOW ARE NOTES APPLICABLE TO USERS OF SAS VERSION 8 OR HIGHER. ****************************************************************************** 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 XCOPY 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, with SAS V8 or higher). LIBNAME PUFLIB 'C:\MEPS\SASDATA'; FILENAME IN1 'C:\MEPS\DOWNLOAD\H36BRR18.SSP'; PROC XCOPY IN=IN1 OUT=PUFLIB IMPORT; RUN; SAS transport files, SAS data files, and SAS program files each should be stored in separate locations (directory names). Storing different types of SAS files in one location can cause errors with converting or retrieving data. Below are SAS statements to print a list of variables and a few sample records from the permanent SAS dataset: PROC CONTENTS DATA=PUFLIB.H36BRR18; TITLE 'List of Variables in MEPS H36BRR18 SAS Dataset'; RUN; PROC PRINT DATA=PUFLIB.H36BRR18 (OBS=20); TITLE 'First 20 Observations in MEPS H36BRR18 SAS Dataset'; RUN; The LIBNAME statement tells SAS the location (directory name) to store the permanent SAS dataset which is output by PROC XCOPY. The FILENAME statement tells SAS the location (complete directory and file name) of the input SAS transport data file. NOTES: 1) If you have an error reading a SAS data file you created, the problem may be a result of where you are storing and/or how you are retrieving the data. First check the data library for multiple releases of SAS files (e.g., V8 or higher with file extensions of '.SAS7BDAT' and V6 with file extensions of '.SD2') stored in the same location. a) You can avoid errors when reading these files by including the SAS release within the LIBNAME statement - e.g., LIBNAME PUFLIB V8 'C:\MEPS\SASDATA'; or b) Store SAS data files with different file extensions such as .SD2 and .SAS7BDAT, in separate folders (do not co-mingle V8 and V6 files in the same folder); or c) When importing transport files, output the SAS dataset to a different library than the one which contains the downloaded SAS transport file - e.g., LIBNAME PUFLIB 'C:\MEPS\SASDATA'; FILENAME IN1 'C:\MEPS\DOWNLOAD\Hxxx.SSP'; PROC XCOPY IN=IN1 OUT=PUBLIB IMPORT; RUN; 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 directory and file names used in the LIBNAME and FILENAME statements shown above are Windows syntax and may need to be modified for other operating systems such as UNIX, MAC/OS, VMS, or OS/2. 4) H36BRR18 is the internal SAS dataset name (also the PC file name, without the extension) prior to the creation of the SAS transport data file. After running PROC XCOPY, the output SAS dataset assumes the same dataset name (or file name). Hence, in the example above, a file named H36BRR18.SAS7BDAT will be created under the C:\MEPS\SASDATA directory when PROC XCOPY runs successfully. 5) The SAS transport file H36BRR18.SSP was created from a SAS V9 data file, using PROC COPY. This file has been tested for use with SAS V8 or higher. This file may work with earlier versions of SAS, although it has not been tested with those versions. Users who are unable to use this SAS transport file should instead convert the ASCII data file H36BRR18.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 H36BRR18.DAT ASCII data file. These statements must be used in combination with other SAS statements to create the appropriate SAS program, as shown below. To use the statements provided in Section D to create a SAS program, you will need an ASCII text editor. If you are using an interactive form of SAS (Windows, UNIX, OS2, etc.), use the editor provided as part of the SAS software. Following is a sample SAS program that will convert the ASCII data file to SAS format: LIBNAME PUFLIB 'C:\MEPS\SASDATA'; FILENAME IN1 'C:\MEPS\DOWNLOAD\H36BRR18.DAT'; DATA PUFLIB.H36BRR18; INFILE IN1 LRECL=150; 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 (H36BRR18). In the example, after the successful completion of the DATA step, a PC file named H36BRR18.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 (150 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 H36BRR18.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., 150 for H36BRR18.DAT). If RECFM=F is used, then the LRECL value must be specified as the logical record length plus 2 (152 for H36BRR18.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 (150 for H36BRR18.DAT). INPUT statement: This specifies the input record layout, giving names and the beginning and ending column positions for data items (which become SAS variables) in the ASCII data file (H36BRR18.DAT). Variable type (numeric or character) is also defined via the INPUT statement. LABEL statement: This associates descriptive names with the SAS variables. RUN statement: This tells SAS to execute all commands up to this point. See Section A.1 above for tips on retrieving and storing the permanent SAS data files. C. Optional Format-related SAS Statements If a user wants to use formats for the SAS variables, a SAS format library must first be created. Below is a SAS program that will accomplish this: LIBNAME PUFLIB 'C:\MEPS\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.H36BRR18; 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' for SAS V8 or higher and 'SD2' for SAS V6) and format libraries (file name extension is 'SAS7BCAT' for SAS V8 or higher and 'SC2' for SAS V6) 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) You only create the permanent SAS dataset once. Additional analyses can be run using this permanent dataset. 4) The file and directory specifications in the LIBNAME and FILENAME statements are Windows syntax and may need to be modified for other operating systems such as UNIX, MAC/OS, VMS, or OS/2. D. SAS Statements This section contains SAS INPUT, LABEL, FORMAT, and VALUE statements for use in converting the ASCII H36BRR18.DAT file into a SAS dataset, and for creating SAS formats. * INPUT STATEMENTS; INFILE IN LRECL=150; INPUT @1 DUID 7.0 @8 PID 3.0 @11 DUPERSID $10.0 @21 PANEL 2.0 @23 BRR1 1.0 @24 BRR2 1.0 @25 BRR3 1.0 @26 BRR4 1.0 @27 BRR5 1.0 @28 BRR6 1.0 @29 BRR7 1.0 @30 BRR8 1.0 @31 BRR9 1.0 @32 BRR10 1.0 @33 BRR11 1.0 @34 BRR12 1.0 @35 BRR13 1.0 @36 BRR14 1.0 @37 BRR15 1.0 @38 BRR16 1.0 @39 BRR17 1.0 @40 BRR18 1.0 @41 BRR19 1.0 @42 BRR20 1.0 @43 BRR21 1.0 @44 BRR22 1.0 @45 BRR23 1.0 @46 BRR24 1.0 @47 BRR25 1.0 @48 BRR26 1.0 @49 BRR27 1.0 @50 BRR28 1.0 @51 BRR29 1.0 @52 BRR30 1.0 @53 BRR31 1.0 @54 BRR32 1.0 @55 BRR33 1.0 @56 BRR34 1.0 @57 BRR35 1.0 @58 BRR36 1.0 @59 BRR37 1.0 @60 BRR38 1.0 @61 BRR39 1.0 @62 BRR40 1.0 @63 BRR41 1.0 @64 BRR42 1.0 @65 BRR43 1.0 @66 BRR44 1.0 @67 BRR45 1.0 @68 BRR46 1.0 @69 BRR47 1.0 @70 BRR48 1.0 @71 BRR49 1.0 @72 BRR50 1.0 @73 BRR51 1.0 @74 BRR52 1.0 @75 BRR53 1.0 @76 BRR54 1.0 @77 BRR55 1.0 @78 BRR56 1.0 @79 BRR57 1.0 @80 BRR58 1.0 @81 BRR59 1.0 @82 BRR60 1.0 @83 BRR61 1.0 @84 BRR62 1.0 @85 BRR63 1.0 @86 BRR64 1.0 @87 BRR65 1.0 @88 BRR66 1.0 @89 BRR67 1.0 @90 BRR68 1.0 @91 BRR69 1.0 @92 BRR70 1.0 @93 BRR71 1.0 @94 BRR72 1.0 @95 BRR73 1.0 @96 BRR74 1.0 @97 BRR75 1.0 @98 BRR76 1.0 @99 BRR77 1.0 @100 BRR78 1.0 @101 BRR79 1.0 @102 BRR80 1.0 @103 BRR81 1.0 @104 BRR82 1.0 @105 BRR83 1.0 @106 BRR84 1.0 @107 BRR85 1.0 @108 BRR86 1.0 @109 BRR87 1.0 @110 BRR88 1.0 @111 BRR89 1.0 @112 BRR90 1.0 @113 BRR91 1.0 @114 BRR92 1.0 @115 BRR93 1.0 @116 BRR94 1.0 @117 BRR95 1.0 @118 BRR96 1.0 @119 BRR97 1.0 @120 BRR98 1.0 @121 BRR99 1.0 @122 BRR100 1.0 @123 BRR101 1.0 @124 BRR102 1.0 @125 BRR103 1.0 @126 BRR104 1.0 @127 BRR105 1.0 @128 BRR106 1.0 @129 BRR107 1.0 @130 BRR108 1.0 @131 BRR109 1.0 @132 BRR110 1.0 @133 BRR111 1.0 @134 BRR112 1.0 @135 BRR113 1.0 @136 BRR114 1.0 @137 BRR115 1.0 @138 BRR116 1.0 @139 BRR117 1.0 @140 BRR118 1.0 @141 BRR119 1.0 @142 BRR120 1.0 @143 BRR121 1.0 @144 BRR122 1.0 @145 BRR123 1.0 @146 BRR124 1.0 @147 BRR125 1.0 @148 BRR126 1.0 @149 BRR127 1.0 @150 BRR128 1.0 ; * FORMAT STATEMENTS; FORMAT DUID DUID. PID PID. DUPERSID $DUPERID. PANEL PANEL. BRR1 REPL. BRR2 REPL. BRR3 REPL. BRR4 REPL. BRR5 REPL. BRR6 REPL. BRR7 REPL. BRR8 REPL. BRR9 REPL. BRR10 REPL. BRR11 REPL. BRR12 REPL. BRR13 REPL. BRR14 REPL. BRR15 REPL. BRR16 REPL. BRR17 REPL. BRR18 REPL. BRR19 REPL. BRR20 REPL. BRR21 REPL. BRR22 REPL. BRR23 REPL. BRR24 REPL. BRR25 REPL. BRR26 REPL. BRR27 REPL. BRR28 REPL. BRR29 REPL. BRR30 REPL. BRR31 REPL. BRR32 REPL. BRR33 REPL. BRR34 REPL. BRR35 REPL. BRR36 REPL. BRR37 REPL. BRR38 REPL. BRR39 REPL. BRR40 REPL. BRR41 REPL. BRR42 REPL. BRR43 REPL. BRR44 REPL. BRR45 REPL. BRR46 REPL. BRR47 REPL. BRR48 REPL. BRR49 REPL. BRR50 REPL. BRR51 REPL. BRR52 REPL. BRR53 REPL. BRR54 REPL. BRR55 REPL. BRR56 REPL. BRR57 REPL. BRR58 REPL. BRR59 REPL. BRR60 REPL. BRR61 REPL. BRR62 REPL. BRR63 REPL. BRR64 REPL. BRR65 REPL. BRR66 REPL. BRR67 REPL. BRR68 REPL. BRR69 REPL. BRR70 REPL. BRR71 REPL. BRR72 REPL. BRR73 REPL. BRR74 REPL. BRR75 REPL. BRR76 REPL. BRR77 REPL. BRR78 REPL. BRR79 REPL. BRR80 REPL. BRR81 REPL. BRR82 REPL. BRR83 REPL. BRR84 REPL. BRR85 REPL. BRR86 REPL. BRR87 REPL. BRR88 REPL. BRR89 REPL. BRR90 REPL. BRR91 REPL. BRR92 REPL. BRR93 REPL. BRR94 REPL. BRR95 REPL. BRR96 REPL. BRR97 REPL. BRR98 REPL. BRR99 REPL. BRR100 REPL. BRR101 REPL. BRR102 REPL. BRR103 REPL. BRR104 REPL. BRR105 REPL. BRR106 REPL. BRR107 REPL. BRR108 REPL. BRR109 REPL. BRR110 REPL. BRR111 REPL. BRR112 REPL. BRR113 REPL. BRR114 REPL. BRR115 REPL. BRR116 REPL. BRR117 REPL. BRR118 REPL. BRR119 REPL. BRR120 REPL. BRR121 REPL. BRR122 REPL. BRR123 REPL. BRR124 REPL. BRR125 REPL. BRR126 REPL. BRR127 REPL. BRR128 REPL. ; * LABEL STATEMENTS; LABEL DUID ='DWELLING UNIT ID' PID ='PERSON NUMBER' DUPERSID='PERSON ID (DUID + PID)' PANEL ='PANEL NUMBER' BRR1 ='BRR FLAG, REPLICATE 1' BRR2 ='BRR FLAG, REPLICATE 2' BRR3 ='BRR FLAG, REPLICATE 3' BRR4 ='BRR FLAG, REPLICATE 4' BRR5 ='BRR FLAG, REPLICATE 5' BRR6 ='BRR FLAG, REPLICATE 6' BRR7 ='BRR FLAG, REPLICATE 7' BRR8 ='BRR FLAG, REPLICATE 8' BRR9 ='BRR FLAG, REPLICATE 9' BRR10 ='BRR FLAG, REPLICATE 10' BRR11 ='BRR FLAG, REPLICATE 11' BRR12 ='BRR FLAG, REPLICATE 12' BRR13 ='BRR FLAG, REPLICATE 13' BRR14 ='BRR FLAG, REPLICATE 14' BRR15 ='BRR FLAG, REPLICATE 15' BRR16 ='BRR FLAG, REPLICATE 16' BRR17 ='BRR FLAG, REPLICATE 17' BRR18 ='BRR FLAG, REPLICATE 18' BRR19 ='BRR FLAG, REPLICATE 19' BRR20 ='BRR FLAG, REPLICATE 20' BRR21 ='BRR FLAG, REPLICATE 21' BRR22 ='BRR FLAG, REPLICATE 22' BRR23 ='BRR FLAG, REPLICATE 23' BRR24 ='BRR FLAG, REPLICATE 24' BRR25 ='BRR FLAG, REPLICATE 25' BRR26 ='BRR FLAG, REPLICATE 26' BRR27 ='BRR FLAG, REPLICATE 27' BRR28 ='BRR FLAG, REPLICATE 28' BRR29 ='BRR FLAG, REPLICATE 29' BRR30 ='BRR FLAG, REPLICATE 30' BRR31 ='BRR FLAG, REPLICATE 31' BRR32 ='BRR FLAG, REPLICATE 32' BRR33 ='BRR FLAG, REPLICATE 33' BRR34 ='BRR FLAG, REPLICATE 34' BRR35 ='BRR FLAG, REPLICATE 35' BRR36 ='BRR FLAG, REPLICATE 36' BRR37 ='BRR FLAG, REPLICATE 37' BRR38 ='BRR FLAG, REPLICATE 38' BRR39 ='BRR FLAG, REPLICATE 39' BRR40 ='BRR FLAG, REPLICATE 40' BRR41 ='BRR FLAG, REPLICATE 41' BRR42 ='BRR FLAG, REPLICATE 42' BRR43 ='BRR FLAG, REPLICATE 43' BRR44 ='BRR FLAG, REPLICATE 44' BRR45 ='BRR FLAG, REPLICATE 45' BRR46 ='BRR FLAG, REPLICATE 46' BRR47 ='BRR FLAG, REPLICATE 47' BRR48 ='BRR FLAG, REPLICATE 48' BRR49 ='BRR FLAG, REPLICATE 49' BRR50 ='BRR FLAG, REPLICATE 50' BRR51 ='BRR FLAG, REPLICATE 51' BRR52 ='BRR FLAG, REPLICATE 52' BRR53 ='BRR FLAG, REPLICATE 53' BRR54 ='BRR FLAG, REPLICATE 54' BRR55 ='BRR FLAG, REPLICATE 55' BRR56 ='BRR FLAG, REPLICATE 56' BRR57 ='BRR FLAG, REPLICATE 57' BRR58 ='BRR FLAG, REPLICATE 58' BRR59 ='BRR FLAG, REPLICATE 59' BRR60 ='BRR FLAG, REPLICATE 60' BRR61 ='BRR FLAG, REPLICATE 61' BRR62 ='BRR FLAG, REPLICATE 62' BRR63 ='BRR FLAG, REPLICATE 63' BRR64 ='BRR FLAG, REPLICATE 64' BRR65 ='BRR FLAG, REPLICATE 65' BRR66 ='BRR FLAG, REPLICATE 66' BRR67 ='BRR FLAG, REPLICATE 67' BRR68 ='BRR FLAG, REPLICATE 68' BRR69 ='BRR FLAG, REPLICATE 69' BRR70 ='BRR FLAG, REPLICATE 70' BRR71 ='BRR FLAG, REPLICATE 71' BRR72 ='BRR FLAG, REPLICATE 72' BRR73 ='BRR FLAG, REPLICATE 73' BRR74 ='BRR FLAG, REPLICATE 74' BRR75 ='BRR FLAG, REPLICATE 75' BRR76 ='BRR FLAG, REPLICATE 76' BRR77 ='BRR FLAG, REPLICATE 77' BRR78 ='BRR FLAG, REPLICATE 78' BRR79 ='BRR FLAG, REPLICATE 79' BRR80 ='BRR FLAG, REPLICATE 80' BRR81 ='BRR FLAG, REPLICATE 81' BRR82 ='BRR FLAG, REPLICATE 82' BRR83 ='BRR FLAG, REPLICATE 83' BRR84 ='BRR FLAG, REPLICATE 84' BRR85 ='BRR FLAG, REPLICATE 85' BRR86 ='BRR FLAG, REPLICATE 86' BRR87 ='BRR FLAG, REPLICATE 87' BRR88 ='BRR FLAG, REPLICATE 88' BRR89 ='BRR FLAG, REPLICATE 89' BRR90 ='BRR FLAG, REPLICATE 90' BRR91 ='BRR FLAG, REPLICATE 91' BRR92 ='BRR FLAG, REPLICATE 92' BRR93 ='BRR FLAG, REPLICATE 93' BRR94 ='BRR FLAG, REPLICATE 94' BRR95 ='BRR FLAG, REPLICATE 95' BRR96 ='BRR FLAG, REPLICATE 96' BRR97 ='BRR FLAG, REPLICATE 97' BRR98 ='BRR FLAG, REPLICATE 98' BRR99 ='BRR FLAG, REPLICATE 99' BRR100 ='BRR FLAG, REPLICATE 100' BRR101 ='BRR FLAG, REPLICATE 101' BRR102 ='BRR FLAG, REPLICATE 102' BRR103 ='BRR FLAG, REPLICATE 103' BRR104 ='BRR FLAG, REPLICATE 104' BRR105 ='BRR FLAG, REPLICATE 105' BRR106 ='BRR FLAG, REPLICATE 106' BRR107 ='BRR FLAG, REPLICATE 107' BRR108 ='BRR FLAG, REPLICATE 108' BRR109 ='BRR FLAG, REPLICATE 109' BRR110 ='BRR FLAG, REPLICATE 110' BRR111 ='BRR FLAG, REPLICATE 111' BRR112 ='BRR FLAG, REPLICATE 112' BRR113 ='BRR FLAG, REPLICATE 113' BRR114 ='BRR FLAG, REPLICATE 114' BRR115 ='BRR FLAG, REPLICATE 115' BRR116 ='BRR FLAG, REPLICATE 116' BRR117 ='BRR FLAG, REPLICATE 117' BRR118 ='BRR FLAG, REPLICATE 118' BRR119 ='BRR FLAG, REPLICATE 119' BRR120 ='BRR FLAG, REPLICATE 120' BRR121 ='BRR FLAG, REPLICATE 121' BRR122 ='BRR FLAG, REPLICATE 122' BRR123 ='BRR FLAG, REPLICATE 123' BRR124 ='BRR FLAG, REPLICATE 124' BRR125 ='BRR FLAG, REPLICATE 125' BRR126 ='BRR FLAG, REPLICATE 126' BRR127 ='BRR FLAG, REPLICATE 127' BRR128 ='BRR FLAG, REPLICATE 128' ; * VALUE STATEMENTS; VALUE DUID 1 - 9999999 = 'VALID ID' ; VALUE $DUPERID '00000001' - '99999999' = 'VALID ID' ; VALUE PANEL 1 = '1 PANEL 1' 2 = '2 PANEL 2' 3 = '3 PANEL 3' 4 = '4 PANEL 4' 5 = '5 PANEL 5' 6 = '6 PANEL 6' 7 = '7 PANEL 7' 8 = '8 PANEL 8' 9 = '9 PANEL 9' 10 = '10 PANEL 10' 11 = '11 PANEL 11' 12 = '12 PANEL 12' 13 = '13 PANEL 13' 14 = '14 PANEL 14' 15 = '15 PANEL 15' 16 = '16 PANEL 16' 17 = '17 PANEL 17' 18 = '18 PANEL 18' 19 = '19 PANEL 19' 20 = '20 PANEL 20' 21 = '21 PANEL 21' 22 = '22 PANEL 22' 23 = '23 PANEL 23' ; VALUE PID 1 - 999 = 'VALID ID' ; VALUE REPL 0 = '0 NOT IN REPLICATE' 1 = '1 IN REPLICATE' ;