SAS User File for H67A 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 (H67A.SSP) or the ASCII data file (H67A.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. ****************************************************************************** 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 data file and convert the data to regular SAS format, storing the output in a permanent SAS dataset. This permanent SAS dataset can then be used for all future processing and analyses. Below is a sample PC-SAS program that can be used to convert the SAS transport file to a permanent PC SAS dataset (in a Windows environment, with SAS V6.12). LIBNAME PUFLIB 'C:\MEPS'; FILENAME IN1 'C:\MEPS\H67A.SSP'; PROC XCOPY IN=IN1 OUT=PUFLIB IMPORT; RUN; If the user wants a list of variables and a few sample records in the permanent SAS dataset, following are the SAS statements to accomplish these. PROC CONTENTS DATA=PUFLIB.H67A; TITLE "List of Variables in MEPS H67A SAS Dataset"; RUN; PROC PRINT DATA=PUFLIB.H67A (OBS=20); TITLE "First 20 Observations in MEPS H67A SAS Dataset"; RUN; The LIBNAME statement tells SAS the location (directory name) to store the permanent SAS dataset which is output by PROC XCOPY. The FILENAME statement tells SAS the location (complete directory and file name) of the input SAS transport data file. NOTES: 1) The names used in the LIBNAME and FILENAME statements shown above (i.e., PUFLIB, IN1) are arbitrary; they are only temporary aliases. 2) The directory and file names used in the LIBNAME and FILENAME statements shown above are Windows syntax and may need to be modified for other operating systems such as UNIX, MAC/OS, VMS, or OS/2. 3) H67A 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 H67A.SD2 will be created under the C:\MEPS directory when PROC XCOPY runs successfully. 4) The SAS transport file H67A.SSP was created from a PC-SAS Version 6.12 data file, using PROC COPY. This file has been tested for use with PC-SAS version 6.10 or higher, or with mainframe SAS version 6.08 or higher. This file may work with earlier versions of SAS, although it has not been tested with those versions. Users who are unable to use this SAS Transport file should instead convert the ASCII data file H67A.DAT to a SAS data set as described in Section B. ADDITONAL NOTE TO USERS OF SAS VERSION 8: One of the following procedures should be used to avoid a SAS error when using the downloaded SAS Transport file: 1) Add V8 to LIBNAME statement - e.g., LIBNAME PUFLIB V8 'C:\MEPS'; OR 2) Output the SAS data set to a different library than the one which contains the downloaded SAS Transport file - e.g., LIBNAME PUFLIB 'C:\MEPS'; FILENAME IN1 'C:\DOWNLOAD\H67A.SSP'; PROC XCOPY IN=IN1 OUT=PUFLIB IMPORT; RUN; 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 H67A.DAT ASCII data file. These statements must be used in combination with other SAS statements to create the appropriate SAS program, as shown below. To use the statements provided in Section D to create a SAS program, you will need an ASCII text editor. If you are using an interactive form of SAS (Windows, UNIX, OS2, etc.), use the editor provided as part of the SAS software. Following is a sample SAS program that will convert the ASCII data file to SAS format. LIBNAME PUFLIB 'C:\MEPS'; FILENAME IN1 'C:\MEPS\H67A.DAT'; DATA PUFLIB.H67A; INFILE IN1 LRECL=535; INPUT .....; * to user: insert the complete INPUT statement that is provided in Section D; LABEL .....; * to user: insert the complete LABEL statement that is provided in Section D; RUN; Here is an explanation of the SAS statements used in the program above. LIBNAME statement: This tells SAS the location (directory name) of the permanent SAS dataset. FILENAME statement: This tells SAS the location of the input ASCII data file. DATA statement: This signifies the beginning of a SAS DATA step and specifies describes the output SAS dataset, referencing the LIBNAME entry (PUFLIB) and assigning an internal SAS dataset name (H67A). In the example, after the successful completion of the DATA step, a PC file named H67A.SD2 would have been created in the C:\MEPS directory. INFILE statement: This tells SAS the location (directory and file name) of the input ASCII data file. Also provided is the logical record length (535 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 H67A.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., 535 for H67A.DAT). If RECFM=F is used, then the LRECL value must be specified as the logical record length plus 2 (537 for H67A.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 (535 for H67A.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 (H67A.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. ADDITONAL NOTE TO USERS OF SAS VERSION 8: One of the following procedures should be used to avoid a SAS error when using the downloaded ASCII data file: 1) Add V8 to LIBNAME statement - e.g., LIBNAME PUFLIB V8 'C:\MEPS'; OR 2) Output the SAS data set to a different library than the one which contains the downloaded ASCII data file - e.g., LIBNAME PUFLIB 'C:\MEPS'; FILENAME IN1 'C:\DOWNLOAD\H67A.DAT'; DATA PUFLIB.H67A; INFILE IN1 LRECL=535; C. Optional Format-related SAS Statements If a user wants to use formats for the SAS variables, a SAS format library must first be created. Below is a SAS program that will accomplish this. LIBNAME PUFLIB 'C:\MEPS'; PROC FORMAT LIBRARY=PUFLIB; VALUE .....; * to user: insert the complete set of VALUE statements found in Section D; VALUE .....; .......... ; RUN; Below is an example of how to use the SAS formats defined by the PROC FORMAT procedure. LIBNAME PUFLIB 'C:\MEPS'; OPTIONS FMTSEARCH=(PUFLIB); PROC FREQ DATA=PUFLIB.H67A; TABLES .... / LIST MISSING; FORMAT varnam1 fmtnam1. Varnam2 fmtnam2. .... ; * to user: substitute varnami and fmtnami with actual variable names and format names; * Insert the FORMAT statement provided in Section D, if you are using all the variables; * in the TABLES statement; TITLE "Frequency Distributions ...."; RUN; Here is an explanation of the SAS statements used above. LIBNAME statement: This tells SAS the location (directory name) of the SAS format library. Please note that SAS datasets (file name extension is 'SD2') and format libraries (file name extension is 'SC2') can be stored under the same directory. OPTIONS FMTSEARCH=...: This specifies the SAS format library. PROC FORMAT statement: This identifies the SAS procedure that will make SAS formats according to VALUE statements. Formats will be stored in a file named FORMATS.SC2. Please note that the option 'LIBRARY=...' can be omitted, if the user does not want to create a permanent SAS format library. When simply 'PROC FORMAT;' is used, the formats are defined only for the duration of the batch SAS program or an interactive SAS session. VALUE statement: This gives a) names to formats; and b) descriptive labels for individual values, or range of values. The format names can then be invoked using a FORMAT statement, if desired. PROC FREQ statement: This identifies the SAS procedure that will generate frequency distributions of variables specified in the TABLES statement, formatted if a FORMAT statement is used. The input SAS dataset is specified in the 'DATA=' option. FORMAT statement: This associates existing formats with variables. When using this statement, the formats must have already been created with a PROC FORMAT procedure. RUN statement: This tells SAS to execute all commands up to this point. NOTES: 1) Use of formats is entirely optional, and depends on the type of analyses that you are doing. It is recommended that you create and use them as appropriate. 2) The names used in the LIBNAME and FILENAME statements shown above (i.e., PUFLIB, IN1) are arbitrary; they are only temporary aliases. 3) You only create the permanent SAS data set once. Additional analyses can be run using this permanent dataset. 4) The file and directory specifications in the LIBNAME and FILENAME statements are Windows syntax and may need to be modified for other operating systems such as UNIX, MAC/OS, VMS, or OS/2. D. SAS Statements This section contains SAS INPUT, LABEL, FORMAT and VALUE statements for use in converting the ASCII H67A.DAT file into a SAS data set, and for creating SAS formats. * INPUT STATEMENTS; INFILE IN LRECL=535; INPUT @1 DUID 5.0 @6 PID 3.0 @9 DUPERSID $8.0 @17 RXRECIDX $15.0 @32 LINKIDX $12.0 @44 PURCHRD 1.0 @45 RXBEGDD 2.0 @47 RXBEGMM 2.0 @49 RXBEGYRX 4.0 @53 RXNAME $50.0 @103 RXHHNAME $30.0 @133 RXNDC $11.0 @144 RXQUANTY 8.2 @152 RXFORM $50.0 @202 RXFRMUNT $50.0 @252 RXSTRENG $50.0 @302 RXSTRUNT $50.0 @352 PHARTP1 2.0 @354 PHARTP2 2.0 @356 PHARTP3 2.0 @358 PHARTP4 2.0 @360 PHARTP5 2.0 @362 PHARTP6 2.0 @364 PHARTP7 2.0 @366 RXFLG 1.0 @367 PCIMPFLG 1.0 @368 CLMOMFLG 1.0 @369 INPCFLG 1.0 @370 DIABFLG 1.0 @371 SAMPLE 1.0 @372 RXICD1X $3.0 @375 RXICD2X $3.0 @378 RXICD3X $3.0 @381 RXCCC1X $3.0 @384 RXCCC2X $3.0 @387 RXCCC3X $3.0 @390 PREGCAT $2.0 @392 GBO $2.0 @394 TC1 3.0 @397 TC1S1 3.0 @400 TC1S1_1 3.0 @403 TC1S1_2 3.0 @406 TC1S2 3.0 @409 TC1S2_1 3.0 @412 TC2 3.0 @415 TC2S1 3.0 @418 TC2S1_1 3.0 @421 TC2S1_2 3.0 @424 TC2S2 3.0 @427 TC3 3.0 @430 TC3S1 3.0 @433 TC3S1_1 3.0 @436 RXSF02X 7.2 @443 RXMR02X 7.2 @450 RXMD02X 7.2 @457 RXPV02X 7.2 @464 RXVA02X 6.2 @470 RXTR02X 7.2 @477 RXOF02X 6.2 @483 RXSL02X 6.2 @489 RXWC02X 6.2 @495 RXOT02X 6.2 @501 RXOR02X 6.2 @507 RXOU02X 6.2 @513 RXXP02X 7.2 @520 PERWT02F 12.6 @532 VARSTR 3.0 @535 VARPSU 1.0 ; * FORMAT STATEMENTS; FORMAT DUID DUID. PID PID. DUPERSID $DUPERSI. RXRECIDX $RXRECIX. LINKIDX $LINKIDX. PURCHRD PURCHRD. RXBEGDD RXBEGDD. RXBEGMM RXBEGMM. RXBEGYRX RXBEGYRX. RXNAME $RXNAME. RXHHNAME $RXHHNAM. RXNDC $RXNDC. RXQUANTY RXQUANTY. RXFORM $RXFORM. RXFRMUNT $RXFRMUN. RXSTRENG $RXSTREN. RXSTRUNT $RXSTRUN. PHARTP1 PHARTP. PHARTP2 PHARTP. PHARTP3 PHARTP. PHARTP4 PHARTP. PHARTP5 PHARTP. PHARTP6 PHARTP. PHARTP7 PHARTP. RXFLG RXFLG. PCIMPFLG PCIMPFLG. CLMOMFLG CLMOMFLG. INPCFLG INPCFLG. DIABFLG DIABFLG. SAMPLE SAMPLE. RXICD1X $ICD9COD. RXICD2X $ICD9COD. RXICD3X $ICD9COD. RXCCC1X $CCCODEX. RXCCC2X $CCCODEX. RXCCC3X $CCCODEX. PREGCAT $PREGCAT. GBO $GBO. TC1 TCNAME. TC1S1 TCNAME. TC1S1_1 TCNAME. TC1S1_2 TCNAME. TC1S2 TCNAME. TC1S2_1 TCNAME. TC2 TCNAME. TC2S1 TCNAME. TC2S1_1 TCNAME. TC2S1_2 TCNAME. TC2S2 TCNAME. TC3 TCNAME. TC3S1 TCNAME. TC3S1_1 TCNAME. RXSF02X RXSF02X. RXMR02X RXMR02X. RXMD02X RXMD02X. RXPV02X RXPV02X. RXVA02X RXVA02X. RXTR02X RXTR02X. RXOF02X RXOF02X. RXSL02X RXSL02X. RXWC02X RXWC02X. RXOT02X RXOT02X. RXOR02X RXOR02X. RXOU02X RXOU02X. RXXP02X RXXP02X. PERWT02F PERWT02F. VARSTR VARSTR. VARPSU VARPSU. ; * LABEL STATEMENTS; LABEL DUID ='DWELLING UNIT ID' PID ='PERSON NUMBER' DUPERSID='PERSON ID (DUID + PID)' RXRECIDX='UNIQUE Rx/PRESCRIBED MEDICINE IDENTIFIER' LINKIDX ='ID FOR LINKAGE TO COND/OTH EVENT FILES' PURCHRD ='ROUND Rx/PRESCR MED OBTAINED/PURCHASED' RXBEGDD ='DAY PERSON STARTED TAKING MEDICINE' RXBEGMM ='MONTH PERSON STARTED TAKING MEDICINE' RXBEGYRX='YEAR PERSON STARTED TAKING MEDICINE' RXNAME ='MEDICATION NAME (IMPUTED)' RXHHNAME='HC REPORTED MEDICATION NAME' RXNDC ='NATIONAL DRUG CODE (IMPUTED)' RXQUANTY='QUANTITY OF Rx/PRESCR MED (IMPUTED)' RXFORM ='FORM OF Rx/PRESCRIBED MEDICINE (IMPUTED)' RXFRMUNT='UNIT OF MEAS FORM Rx/PRESC MED (IMPUTED)' RXSTRENG='STRENGTH OF Rx/PRESCR MED DOSE (IMPUTED)' RXSTRUNT='UNIT OF MEAS STRENGTH OF Rx (IMPUTED)' PHARTP1 ='TYPE OF PHARMACY PROV - 1ST' PHARTP2 ='TYPE OF PHARMACY PROV - 2ND' PHARTP3 ='TYPE OF PHARMACY PROV - 3RD' PHARTP4 ='TYPE OF PHARMACY PROV - 4TH' PHARTP5 ='TYPE OF PHARMACY PROV - 5TH' PHARTP6 ='TYPE OF PHARMACY PROV - 6TH' PHARTP7 ='TYPE OF PHARMACY PROV - 7TH' RXFLG ='NDC IMPUTATION SOURCE ON PC DONOR REC' PCIMPFLG='TYPE OF HC TO PC PRESCRIPTION MATCH' CLMOMFLG='CHGE/PYMNT, Rx CLAIM FILING, OMTYPE STAT' INPCFLG ='PID HAS AT LEAST 1 RECORD IN PC' DIABFLG ='Rx INSULIN OR DIABETIC EQUIPMENT/SUPPLY' SAMPLE ='HOUSEHLD RCVD FREE SAMPLE OF Rx IN ROUND' RXICD1X ='3 DIGIT ICD-9 CONDITION CODE' RXICD2X ='3 DIGIT ICD-9 CONDITION CODE' RXICD3X ='3 DIGIT ICD-9 CONDITION CODE' RXCCC1X ='MODIFIED CLINICAL CLASS CODE' RXCCC2X ='MODIFIED CLINICAL CLASS CODE' RXCCC3X ='MODIFIED CLINICAL CLASS CODE' PREGCAT ='MULTUM PREGNANCY CATEGORY' GBO ='MULTUM BRAND/GENERIC DESIGNATION' TC1 ='MULTUM THERAPEUTIC CLASS #1' TC1S1 ='MULTUM THERAPEUTIC SUB-CLASS #1 FOR TC1' TC1S1_1 ='MULTUM THERAPEUT SUB-SUB-CLASS FOR TC1S1' TC1S1_2 ='MULTUM THERAPEUT SUB-SUB-CLASS FOR TC1S1' TC1S2 ='MULTUM THERAPEUTIC SUB-CLASS #2 FOR TC1' TC1S2_1 ='MULTUM THERAPEUT SUB-SUB-CLASS FOR TC1S2' TC2 ='MULTUM THERAPEUTIC CLASS #2' TC2S1 ='MULTUM THERAPEUTIC SUB-CLASS #1 FOR TC2' TC2S1_1 ='MULTUM THERAPEUT SUB-SUB-CLASS FOR TC2S1' TC2S1_2 ='MULTUM THERAPEUT SUB-SUB-CLASS FOR TC2S1' TC2S2 ='MULTUM THERAPEUTIC SUB-CLASS #2 FOR TC2' TC3 ='MULTUM THERAPEUTIC CLASS #3' TC3S1 ='MULTUM THERAPEUTIC SUB-CLASS #1 FOR TC3' TC3S1_1 ='MULTUM THERAPEUT SUB-SUB-CLASS FOR TC3S1' RXSF02X ='AMOUNT PAID, SELF OR FAMILY (IMPUTED)' RXMR02X ='AMOUNT PAID, MEDICARE (IMPUTED)' RXMD02X ='AMOUNT PAID, MEDICAID (IMPUTED)' RXPV02X ='AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)' RXVA02X ='AMOUNT PAID, VETERANS (IMPUTED)' RXTR02X ='AMOUNT PAID, TRICARE (IMPUTED)' RXOF02X ='AMOUNT PAID, OTHER FEDERAL (IMPUTED)' RXSL02X ='AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)' RXWC02X ='AMOUNT PAID, WORKERS COMP (IMPUTED)' RXOT02X ='AMOUNT PAID, OTHER INSURANCE (IMPUTED)' RXOR02X ='AMOUNT PAID, OTHER PRIVATE (IMPUTED)' RXOU02X ='AMOUNT PAID, OTHER PUBLIC (IMPUTED)' RXXP02X ='SUM OF PAYMENTS RXSF02X-RXOU02X(IMPUTED)' PERWT02F='FINAL PERSON LEVEL WEIGHT, 2002' VARSTR ='VARIANCE ESTIMATION STRATUM, 2002' VARPSU ='VARIANCE ESTIMATION PSU, 2002' ; * VALUE STATEMENTS; VALUE $CCCODEX '-1' = '-1 INAPPLICABLE' '-7' = '-7 REFUSED' '-8' = '-8 DK' '-9' = '-9 NOT ASCERTAINED' '001' - '260' = '001-260' ; VALUE CLMOMFLG 1 = '1 C+P=N,FILER=PHARMACY' 2 = '2 C+P=N,FILER=NEITHER' 3 = '3 C+P=Y,FILER=UNK/INAP' 4 = '4 C+P=Y,FILER=FAMILY' 5 = '5 C+P=Y,FILER=PHARMACY,OM=2,3' 6 = '6 C+P=Y,FILER=NEITHER,OM=2,3' ; VALUE DIABFLG 0 = '0 NO' 1 = '1 YES' ; VALUE DUID 20002 - 50651 = 'VALID ID' ; VALUE $DUPERSI '20002038' - '50651039' = 'VALID ID' ; VALUE $GBO '-1' = '-1 INAPPLICABLE' '-9' = '-9 NOT ASCERTAINED' 'G' = 'G GENERIC PRODUCT' 'N' = 'N BRAND NAME PRODUCT' ; VALUE $ICD9COD '-1' = '-1 INAPPLICABLE' '-8' = '-8 DK' '-9' = '-9 NOT ASCERTAINED' '001' - '999' = '001-999' 'E00' - 'E99' = 'E00-E99' 'V00' - 'V99' = 'V00-V99' ; VALUE INPCFLG 0 = '0 NO' 1 = '1 YES' ; VALUE $LINKIDX '200020380020' - '506510390062' = 'VALID ID' ; VALUE PCIMPFLG 1 = '1 EXACT MATCH TO PC Rx FOR PID' 2 = '2 NOT EXACT MATCH TO PC Rx FOR PID' ; VALUE PERWT02F 0 = '0' 405.713765 - 46765.598968 = '405.713765 - 46765.598968' ; VALUE PHARTP -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 1 = '1 MAIL-ORDER' 2 = '2 IN ANOTHER STORE' 3 = '3 IN HMO/CLINIC/HOSPITAL' 4 = '4 DRUG STORE' 5 = '5 ON-LINE' ; VALUE PID 10 - 167 = 'VALID ID' ; VALUE $PREGCAT '-9' = '-9 NOT ASCERTAINED' 'A' = 'A CONTROLLED STUDIES SHOW NO RISK' 'B' = 'B NO EVIDENCE OF RISK IN HUMANS' 'C' = 'C RISK CANNOT BE RULED OUT' 'D' = 'D POSITIVE EVIDENCE OF RISK' 'N' = 'N FDA HAS NOT CLASSIFIED THE RX' 'X' = 'X CONTRAINDICATED IN PREGNANCY' ; VALUE PURCHRD 1 = '1' 2 = '2' 3 = '3' 4 = '4' 5 = '5' ; VALUE RXBEGDD -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 1 - 31 = '1-31' ; VALUE RXBEGMM -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 1 - 12 = '1-12' ; VALUE RXBEGYRX -14 = '-14 NOT YET USED/TAKEN' -9 = '-9 NOT ASCERTAINED' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 1917 - 2003 = '1917-2003' ; VALUE RXFLG 1 = '1 NO IMPUTATION' 2 = '2 IMPUTED FROM OTHER PC RECORD' 3 = '3 IMPUTED FR SECONDARY SRC, BUT ORIG REPORTED' ; VALUE $RXFORM '-7' = '-7 REFUSED' '-8' = '-8 DK' '-9' = '-9 NOT ASCERTAINED' OTHER = 'A-ZZZZZZZZZZ' ; VALUE $RXFRMUN '-7' = '-7 REFUSED' '-8' = '-8 DK' '-9' = '-9 NOT ASCERTAINED' '91' = '91 OTHER SPECIFY' OTHER = 'A-ZZZZZZZZZZ' ; VALUE $RXHHNAM ' ' = 'BLANK' '-1' = '-1 INAPPLICABLE' '-13' = '-13 VALUE SUPPRESSED' '-7' = '-7 REFUSED' '-8' = '-8 DK' '-9' = '-9 NOT ASCERTAINED' OTHER = '0-ZZZZZZZZZZ' ; VALUE RXMD02X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.01 - 13.22 = '$0.01 - $13.22' 13.22 < - 38.69 = '$13.23 - $38.69' 38.69 < - 77.12 = '$38.70 - $77.12' 77.12 < - 4842.11 = '$77.13 - $4842.11' ; VALUE RXMR02X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.01 - 12.26 = '$0.01 - $12.26' 12.26 < - 34.56 = '$12.27 - $34.56' 34.56 < - 68.39 = '$34.57 - $68.39' 68.39 < - 1398.79 = '$68.40 - $1398.79' ; VALUE $RXNAME ' ' = 'BLANK' '-1' = '-1 INAPPLICABLE' '-7' = '-7 REFUSED' '-8' = '-8 DK' '-9' = '-9 NOT ASCERTAINED' OTHER = '0-ZZZZZZZZZZ' ; VALUE $RXNDC '-7' = '-7 REFUSED' '-8' = '-8 DK' '-9' = '-9 NOT ASCERTAINED' '00000000000' = '00000000000' '00000000202' - '99999999996' = '00000000202-99999999996' ; VALUE RXOF02X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.03 - 8.75 = '$0.03 - $8.75' 8.75 < - 23.72 = '$8.76 - $23.72' 23.72 < - 60.06 = '$23.73 - $60.06' 60.06 < - 422.61 = '$60.07 - $422.61' ; VALUE RXOR02X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.01 - 10.3 = '$0.01 - $10.30' 10.3 < - 27.14 = '$10.31 - $27.14' 27.14 < - 66.5 = '$27.15 - $66.50' 66.5 < - 968.7 = '$66.51 - $968.70' ; VALUE RXOT02X -9 = '-9 NOT ASCERTAINED' 0 = '0' 2.9 - 5.5 = '$2.90 - $5.50' 5.5 < - 27.84 = '$5.51 - $27.84' 27.84 < - 45.2 = '$27.85 - $45.20' 45.2 < - 160.17 = '$45.21 - $160.17' ; VALUE RXOU02X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.87 - 2.89 = '$0.87 - $2.89' 2.89 < - 14.89 = '$2.90 - $14.89' 14.89 < - 32.67 = '$14.90 - $32.67' 32.67 < - 302.2 = '$32.68 - $302.20' ; VALUE RXPV02X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.01 - 12.45 = '$0.01 - $12.45' 12.45 < - 33 = '$12.46 - $33.00' 33 < - 67.45 = '$33.01 - $67.45' 67.45 < - 4822.11 = '$67.46 - $4822.11' ; VALUE RXQUANTY -9 = '-9 NOT ASCERTAINED' 0.5 - 24000 = '0.5 - 24000' ; VALUE $RXRECIX '200020380020001' - '506510390062001' = 'VALID ID' ; VALUE RXSF02X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.01 - 6 = '$0.01 - $6.00' 6 < - 14.16 = '$6.01 - $14.16' 14.16 < - 30 = '$14.17 - $30.00' 30 < - 4842.11 = '$30.01 - $4842.11' ; VALUE RXSL02X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.13 - 11.45 = '$0.13 - $11.45' 11.45 < - 30.75 = '$11.46 - $30.75' 30.75 < - 65.7 = '$30.76 - $65.70' 65.7 < - 448.54 = '$65.71 - $448.54' ; VALUE $RXSTREN '-7' = '-7 REFUSED' '-8' = '-8 DK' '-9' = '-9 NOT ASCERTAINED' OTHER = 'A-ZZZZZZZZZZ' ; VALUE $RXSTRUN '-7' = '-7 REFUSED' '-8' = '-8 DK' '-9' = '-9 NOT ASCERTAINED' OTHER = 'A-ZZZZZZZZZZ' ; VALUE RXTR02X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.62 - 9.78 = '$0.62 - $9.78' 9.78 < - 29.95 = '$9.79 - $29.95' 29.95 < - 69.96 = '$29.96 - $69.96' 69.96 < - 4671.91 = '$69.97 - $4671.91' ; VALUE RXVA02X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.1 - 11.25 = '$0.10 - $11.25' 11.25 < - 36.54 = '$11.26 - $36.54' 36.54 < - 75.62 = '$36.55 - $75.62' 75.62 < - 474.06 = '$75.63 - $474.06' ; VALUE RXWC02X -9 = '-9 NOT ASCERTAINED' 0 = '0' 2.99 - 18.2 = '$2.99 - $18.20' 18.2 < - 44.75 = '$18.21 - $44.75' 44.75 < - 80.13 = '$44.76 - $80.13' 80.13 < - 129.37 = '$80.14 - $129.37' ; VALUE RXXP02X -9 = '-9 NOT ASCERTAINED' 0 = '0' 0.1 - 15.99 = '$0.10 - $15.99' 15.99 < - 37.44 = '$16.00 - $37.44' 37.44 < - 73.69 = '$37.45 - $73.69' 73.69 < - 4842.12 = '$73.70 - $4842.11' ; VALUE SAMPLE 0 = '0 NO' 1 = '1 YES' ; VALUE TCNAME -9 = '-9 NOT ASCERTAINED' -1 = '-1 INAPPLICABLE' 1 = '1 ANTI-INFECTIVES' 2 = '2 AMEBICIDES' 3 = '3 ANTHELMINTICS' 4 = '4 ANTIFUNGALS' 5 = '5 ANTIMALARIAL AGENTS' 6 = '6 ANTITUBERCULOSIS AGENTS' 7 = '7 ANTIVIRAL AGENTS' 8 = '8 CARBAPENEMS' 9 = '9 CEPHALOSPORINS' 10 = '10 LEPROSTATICS' 11 = '11 MACROLIDES DERIVATIVES' 12 = '12 MISCELLANEOUS ANTIBIOTICS' 13 = '13 PENICILLINS' 14 = '14 QUINOLONES' 15 = '15 SULFONAMIDES' 16 = '16 TETRACYCLINES' 17 = '17 URINARY ANTI-INFECTIVES' 18 = '18 AMINOGLYCOSIDES' 19 = '19 ANTIHYPERLIPIDEMIC AGENTS' 20 = '20 ANTINEOPLASTICS' 21 = '21 ALKYLATING AGENTS' 22 = '22 ANTIBIOTICS/ANTINEOPLASTICS' 23 = '23 ANTIMETABOLITES' 24 = '24 HORMONES/ANTINEOPLASTICS' 25 = '25 MISCELLANEOUS ANTINEOPLASTICS' 26 = '26 MITOTIC INHIBITORS' 27 = '27 RADIOPHARMACEUTICALS' 28 = '28 BIOLOGICALS' 30 = '30 ANTITOXINS AND ANTIVENINS' 31 = '31 BACTERIAL VACCINES' 32 = '32 COLONY STIMULATING FACTORS' 33 = '33 IMMUNE GLOBULINS' 34 = '34 IN VIVO DIAGNOSTIC BIOLOGICALS' 36 = '36 RECOMBINANT HUMAN ERYTHROPOIETINS' 37 = '37 TOXOIDS' 38 = '38 VIRAL VACCINES' 39 = '39 MISCELLANEOUS BIOLOGICALS' 40 = '40 CARDIOVASCULAR AGENTS' 41 = '41 AGENTS FOR HYPERTENSIVE EMERGENCIES' 42 = '42 ANGIOTENSIN CONVERTING ENZYME INHIBITORS' 43 = '43 ANTIADRENERGIC AGENTS, PERIPHERALLY ACTING' 44 = '44 ANTIADRENERGIC AGENTS, CENTRALLY ACTING' 45 = '45 ANTIANGINAL AGENTS' 46 = '46 ANTIARRHYTHMIC AGENTS' 47 = '47 BETA-ADRENERGIC BLOCKING AGENTS' 48 = '48 CALCIUM CHANNEL BLOCKING AGENTS' 49 = '49 DIURETICS' 50 = '50 INOTROPIC AGENTS' 51 = '51 MISCELLANEOUS CARDIOVASCULAR AGENTS' 52 = '52 PERIPHERAL VASODILATORS' 53 = '53 VASODILATORS' 54 = '54 VASOPRESSORS' 55 = '55 ANTIHYPERTENSIVE COMBINATIONS' 56 = '56 ANGIOTENSIN II INHIBITORS' 57 = '57 CENTRAL NERVOUS SYSTEM AGENTS' 58 = '58 ANALGESICS' 59 = '59 MISCELLANEOUS ANALGESICS' 60 = '60 NARCOTIC ANALGESICS' 61 = '61 NONSTEROIDAL ANTI-INFLAMMATORY AGENTS' 62 = '62 SALICYLATES' 63 = '63 ANALGESIC COMBINATIONS' 64 = '64 ANTICONVULSANTS' 65 = '65 ANTIEMETIC/ANTIVERTIGO AGENTS' 66 = '66 ANTIPARKINSON AGENTS' 67 = '67 ANXIOLYTICS, SEDATIVES, AND HYPNOTICS' 68 = '68 BARBITURATES' 69 = '69 BENZODIAZEPINES' 70 = '70 MISCELLANEOUS ANXIOLYTICS, SEDATIVES AND HYPNOTICS' 71 = '71 CNS STIMULANTS' 72 = '72 GENERAL ANESTHETICS' 73 = '73 MUSCLE RELAXANTS' 74 = '74 NEUROMUSCULAR BLOCKING AGENTS' 76 = '76 MISCELLANEOUS ANTIDEPRESSANTS' 77 = '77 MISCELLANEOUS ANTIPSYCHOTIC AGENTS' 79 = '79 PSYCHOTHERAPEUTIC COMBINATIONS' 80 = '80 MISCELLANEOUS CENTRAL NERVOUS SYSTEM AGENTS' 81 = '81 COAGULATION MODIFIERS' 82 = '82 ANTICOAGULANTS' 83 = '83 ANTIPLATELET AGENTS' 84 = '84 HEPARIN ANTAGONISTS' 85 = '85 MISCELLANEOUS COAGULATION MODIFIERS' 86 = '86 THROMBOLYTICS' 87 = '87 GASTROINTESTINAL AGENTS' 88 = '88 ANTACIDS' 89 = '89 ANTICHOLINERGICS/ANTISPASMODICS' 90 = '90 ANTIDIARRHEALS' 91 = '91 DIGESTIVE ENZYMES' 92 = '92 GALLSTONE SOLUBILIZING AGENTS' 93 = '93 GI STIMULANTS' 94 = '94 H2 ANTAGONISTS' 95 = '95 LAXATIVES' 96 = '96 MISCELLANEOUS GI AGENTS' 97 = '97 HORMONES' 98 = '98 ADRENAL CORTICAL STEROIDS' 99 = '99 ANTIDIABETIC AGENTS' 100 = '100 MISCELLANEOUS HORMONES' 101 = '101 SEX HORMONES' 102 = '102 CONTRACEPTIVES' 103 = '103 THYROID DRUGS' 104 = '104 IMMUNOSUPPRESSIVE AGENTS' 105 = '105 MISCELLANEOUS AGENTS' 106 = '106 ANTIDOTES' 107 = '107 CHELATING AGENTS' 108 = '108 CHOLINERGIC MUSCLE STIMULANTS' 109 = '109 LOCAL INJECTABLE ANESTHETICS' 110 = '110 MISCELLANEOUS UNCATEGORIZED AGENTS' 111 = '111 PSORALENS' 112 = '112 RADIOCONTRAST AGENTS' 113 = '113 GENITOURINARY TRACT AGENTS' 114 = '114 ILLICIT (STREET) DRUGS' 115 = '115 NUTRITIONAL PRODUCTS' 116 = '116 IRON PRODUCTS' 117 = '117 MINERALS AND ELECTROLYTES' 118 = '118 ORAL NUTRITIONAL SUPPLEMENTS' 119 = '119 VITAMINS' 120 = '120 VITAMIN AND MINERAL COMBINATIONS' 121 = '121 INTRAVENOUS NUTRITIONAL PRODUCTS' 122 = '122 RESPIRATORY AGENTS' 123 = '123 ANTIHISTAMINES' 124 = '124 ANTITUSSIVES' 125 = '125 BRONCHODILATORS' 126 = '126 METHYLXANTHINES' 127 = '127 DECONGESTANTS' 128 = '128 EXPECTORANTS' 129 = '129 MISCELLANEOUS RESPIRATORY AGENTS' 130 = '130 RESPIRATORY INHALANT PRODUCTS' 131 = '131 ANTIASTHMATIC COMBINATIONS' 132 = '132 UPPER RESPIRATORY COMBINATIONS' 133 = '133 TOPICAL AGENTS' 134 = '134 ANORECTAL PREPARATIONS' 135 = '135 ANTISEPTIC AND GERMICIDES' 136 = '136 DERMATOLOGICAL AGENTS' 137 = '137 TOPICAL ANTI-INFECTIVES' 138 = '138 TOPICAL STEROIDS' 139 = '139 TOPICAL ANESTHETICS' 140 = '140 MISCELLANEOUS TOPICAL AGENTS' 141 = '141 TOPICAL STEROIDS WITH ANTI-INFECTIVES' 143 = '143 TOPICAL ACNE AGENTS' 144 = '144 TOPICAL ANTIPSORIATICS' 146 = '146 MOUTH AND THROAT PRODUCTS' 147 = '147 OPHTHALMIC PREPARATIONS' 148 = '148 OTIC PREPARATIONS' 149 = '149 SPERMICIDES' 150 = '150 STERILE IRRIGATING SOLUTIONS' 151 = '151 VAGINAL PREPARATIONS' 153 = '153 PLASMA EXPANDERS' 154 = '154 LOOP DIURETICS' 155 = '155 POTASSIUM-SPARING DIURETICS' 156 = '156 THIAZIDE DIURETICS' 157 = '157 CARBONIC ANHYDRASE INHIBITORS' 158 = '158 MISCELLANEOUS DIURETICS' 159 = '159 FIRST GENERATION CEPHALOSPORINS' 160 = '160 SECOND GENERATION CEPHALOSPORINS' 161 = '161 THIRD GENERATION CEPHALOSPORINS' 162 = '162 FOURTH GENERATION CEPHALOSPORINS' 163 = '163 OPHTHALMIC ANTI-INFECTIVES' 164 = '164 OPHTHALMIC GLAUCOMA AGENTS' 165 = '165 OPHTHALMIC STEROIDS' 166 = '166 OPHTHALMIC STEROIDS WITH ANTI-INFECTIVES' 167 = '167 OPHTHALMIC ANTI-INFLAMMATORY AGENTS' 168 = '168 OPHTHALMIC LUBRICANTS AND IRRIGATIONS' 169 = '169 MISCELLANEOUS OPHTHALMIC AGENTS' 170 = '170 OTIC ANTI-INFECTIVES' 171 = '171 OTIC STEROIDS WITH ANTI-INFECTIVES' 172 = '172 MISCELLANEOUS OTIC AGENTS' 173 = '173 HMG-COA REDUCTASE INHIBITORS' 174 = '174 MISCELLANEOUS ANTIHYPERLIPIDEMIC AGENTS' 175 = '175 PROTEASE INHIBITORS' 176 = '176 NRTIS' 177 = '177 MISCELLANEOUS ANTIVIRALS' 178 = '178 SKELETAL MUSCLE RELAXANTS' 179 = '179 SKELETAL MUSCLE RELAXANT COMBINATIONS' 180 = '180 ADRENERGIC BRONCHODILATORS' 181 = '181 BRONCHODILATOR COMBINATIONS' 182 = '182 ANDROGENS AND ANABOLIC STEROIDS' 183 = '183 ESTROGENS' 184 = '184 GONADOTROPINS' 185 = '185 PROGESTINS' 186 = '186 SEX HORMONE COMBINATIONS' 187 = '187 MISCELLANEOUS SEX HORMONES' 191 = '191 NARCOTIC ANALGESIC COMBINATIONS' 192 = '192 ANTIRHEUMATICS' 193 = '193 ANTIMIGRAINE AGENTS' 194 = '194 ANTIGOUT AGENTS' 195 = '195 5HT3 RECEPTOR ANTAGONISTS' 196 = '196 PHENOTHIAZINE ANTIEMETICS' 197 = '197 ANTICHOLINERGIC ANTIEMETICS' 198 = '198 MISCELLANEOUS ANTIEMETICS' 199 = '199 HYDANTOIN ANTICONVULSANTS' 200 = '200 SUCCINIMIDE ANTICONVULSANTS' 201 = '201 BARBITURATE ANTICONVULSANTS' 202 = '202 OXAZOLIDINEDIONE ANTICONVULSANTS' 203 = '203 BENZODIAZEPINE ANTICONVULSANTS' 204 = '204 MISCELLANEOUS ANTICONVULSANTS' 205 = '205 ANTICHOLINERGIC ANTIPARKINSON AGENTS' 206 = '206 MISCELLANEOUS ANTIPARKINSON AGENTS' 208 = '208 SSRI ANTIDEPRESSANTS' 209 = '209 TRICYCLIC ANTIDEPRESSANTS' 210 = '210 PHENOTHIAZINE ANTIPSYCHOTICS' 211 = '211 PLATELET AGGREGATION INHIBITORS' 212 = '212 GLYCOPROTEIN PLATELET INHIBITORS' 213 = '213 SULFONYLUREAS' 214 = '214 NON-SULFONYLUREAS' 215 = '215 INSULIN' 216 = '216 ALPHA-GLUCOSIDASE INHIBITORS' 217 = '217 BISPHOSPHONATES' 218 = '218 ALTERNATIVE MEDICINES' 219 = '219 NUTRACEUTICAL PRODUCTS' 220 = '220 HERBAL PRODUCTS' 222 = '222 PENICILLINASE RESISTANT PENICILLINS' 223 = '223 ANTIPSEUDOMONAL PENICILLINS' 224 = '224 AMINOPENICILLINS' 225 = '225 BETA-LACTAMASE INHIBITORS' 226 = '226 NATURAL PENICILLINS' 227 = '227 NNRTIS' 228 = '228 ADAMANTANE ANTIVIRALS' 229 = '229 PURINE NUCLEOSIDES' 230 = '230 AMINOSALICYLATES' 231 = '231 NICOTINIC ACID DERIVATIVES' 232 = '232 RIFAMYCIN DERIVATIVES' 233 = '233 STREPTOMYCES DERIVATIVES' 234 = '234 MISCELLANEOUS ANTITUBERCULOSIS AGENTS' 235 = '235 AMPHOTERICINS' 236 = '236 AZOLE ANTIFUNGALS' 237 = '237 MISCELLANEOUS ANTIFUNGALS' 238 = '238 AMINOQUINOLONES' 239 = '239 MISCELLANEOUS ANTIMALARIALS' 240 = '240 LINCOMYCIN DERIVATIVES' 241 = '241 FIBRIC ACID DERIVATIVES' 242 = '242 PSYCHOTHERAPEUTIC AGENTS' 243 = '243 LEUKOTRIENE MODIFIERS' 244 = '244 NASAL LUBRICANTS AND IRRIGATIONS' 245 = '245 NASAL STEROIDS' 246 = '246 NASAL ANTIHISTAMINES AND DECONGESTANTS' 247 = '247 NASAL PREPARATIONS' 248 = '248 TOPICAL EMOLLIENTS' 249 = '249 ANTIDEPRESSANTS' 250 = '250 MONOAMINE OXIDASE INHIBITORS' 251 = '251 ANTIPSYCHOTICS' 252 = '252 BILE ACID SEQUESTRANTS' 253 = '253 ANOREXIANTS' 254 = '254 IMMUNOLOGIC AGENTS' 256 = '256 INTERFERONS' 257 = '257 MONOCLONAL ANTIBODIES' 261 = '261 HEPARINS' 262 = '262 COUMARINS AND INDANDIONES' 263 = '263 IMPOTENCE AGENTS' 264 = '264 URINARY ANTISPASMODICS' 265 = '265 URINARY PH MODIFIERS' 266 = '266 MISCELLANEOUS GENITOURINARY TRACT AGENTS' 267 = '267 OPHTHALMIC ANTIHISTAMINES AND DECONGESTANTS' 268 = '268 VAGINAL ANTI-INFECTIVES' 269 = '269 MISCELLANEOUS VAGINAL AGENTS' 270 = '270 ANTIPSORIATICS' 271 = '271 THIAZOLIDINEDIONES' 272 = '272 PROTON PUMP INHIBITORS' 273 = '273 LUNG SURFACTANTS' 274 = '274 CARDIOSELECTIVE BETA BLOCKERS' 275 = '275 NON-CARDIOSELECTIVE BETA BLOCKERS' 276 = '276 DOPAMINERGIC ANTIPARKINSONISM AGENTS' 277 = '277 5-AMINOSALICYLATES' 278 = '278 COX-2 INHIBITORS' 279 = '279 GONADOTROPIN RELEASING HORMONES' 280 = '280 THIOXANTHENES' 281 = '281 NEURAMINIDASE INHIBITORS' 282 = '282 MEGLITINIDES' 283 = '283 THROMBIN INHIBITORS' 284 = '284 VISCOSUPPLEMENTATION AGENTS' 285 = '285 FACTOR XA INHIBITORS' 286 = '286 MYDRIATICS' 287 = '287 OPHTHALMIC ANESTHETICS' 288 = '288 5-ALPHA-REDUCTASE INHIBITORS' 289 = '289 ANTIHYPERURICEMIC AGENTS' 290 = '290 TOPICAL ANTIBIOTICS' 291 = '291 TOPICAL ANTIVIRALS' 292 = '292 TOPICAL ANTIFUNGALS' 293 = '293 GLUCOSE ELEVATING AGENTS' 295 = '295 GROWTH HORMONES' 296 = '296 INHALED CORTICOSTEROIDS' 297 = '297 MUCOLYTICS' 298 = '298 MAST CELL STABILIZERS' 299 = '299 ANTICHOLINERGIC BRONCHODILATORS' 300 = '300 CORTICOTROPIN' 301 = '301 GLUCOCORTICOIDS' 302 = '302 MINERALOCORTICOIDS' 303 = '303 AGENTS FOR PULMONARY HYPERTENSION' 304 = '304 MACROLIDES' 305 = '305 KETOLIDES' ; VALUE VARPSU 1 - 3 = '1 - 3' ; VALUE VARSTR 1 - 203 = '1 - 203' ;