 |
 |
 |
|
   |
||||||||
|
|
|||||||
|
Scientific Data Documentation
Research Tape 28R, SAS Input Statement, 1987Dataset Name = CC37.NMES87.TAPE28R.DATAX (Where X = 1,2, or 3) THE FOLLOWING SAS INPUT AND LABEL STATEMENTS ARE FOR USE WITH DATA FILE # 1 INPUT @1 OFIDX 6.0 @7 PN 3.0 @10 SPERIDX 9.0 @19 NEWFTYPE 1.0 @20 FILE2SP 1.0 @21 FILE3SP 2.0 @23 PPSAMP $2.0 @25 RESTYPE 1.0 @26 DEC31AGE 3.0 @29 BSRACEX 1.0 @30 SPSEX 1.0 @31 USER $2.0 @33 WIUEQEXP 11.6 @44 STAIUEQ1 2.0 @46 PSUIUEQ1 3.0 LABEL OFIDX ='PRIMARY SAMPLED FACIL IDENTIFIER' PN ='PERSON NUMBER' SPERIDX ='SAMPLE PERSON IDENTIFIER (OFIDX + PN)' NEWFTYPE='FACILITY TYPE BASED ON PHASE 1 FQ' FILE2SP ='NUMBER OF RECORDS FOR SP ON FILE 2' FILE3SP ='NUMBER OF RECORDS FOR SP ON FILE 3' PPSAMP ='PERIOD OF SAMPLING SP' RESTYPE ='SP SAMPLE TYPE (CR/NA)' DEC31AGE='CALCULATED AGE(REF DATE=12/31/87 OR DOD)' BSRACEX ='BQE1ED SP RACIAL BACKGROUND' SPSEX ='BQA1ED SAMPLE PERSON SEX' USER ='PERSON-LEVEL VAR FOR INSTIT USER TYPE' WIUEQEXP='INST USER POP WT FOR USE AND EXP' STAIUEQ1='STRATA FOR WIUEQEXP' PSUIUEQ1='PSU W/IN STRATA FOR WIUEQEXP' THE FOLLOWING SAS INPUT AND LABEL STATEMENTS ARE FOR USE WITH DATA FILE # 2 INPUT @1 IUEQIDX $16.0 @17 OFIDX 6.0 @23 PN 3.0 @26 SPERIDX 9.0 @35 RN 1.0 @36 IUEQFIDX 6.0 @42 NEWFTYPE 1.0 @43 FILE3IU 2.0 @45 BBOX6DD 2.0 @47 BBOX6MM 2.0 @49 BBOX6YY 2.0 @51 EBOX6DD 2.0 @53 EBOX6MM 2.0 @55 EBOX6YY 2.0 @57 EMERRMYN 2.0 @59 EMERRMNM 2.0 @61 OUTDEPYN 2.0 @63 OUTDEPNM 2.0 @65 ISPSEE01 2.0 @67 ISPSEE02 2.0 @69 ISPSEE03 2.0 @71 ISPSEE04 2.0 @73 ISPSEE05 2.0 @75 ISPSEE06 2.0 @77 ISPSEE07 2.0 @79 ISPSEE08 2.0 @81 ISPSEE09 2.0 @83 ISPSEE10 2.0 @85 ISPSEE11 2.0 @87 PRVDNURS 2.0 @89 NUMWKNUR 2.0 @91 NUMDAWK 2.0 @93 NURSPDFC 2.0 @95 IUCAREMP 2.0 @97 IUCARCON 2.0 @99 IUCARELS 2.0 LABEL IUEQIDX ='RECORD ID (OFIDX + PN + RN + IUEQFIDX)' OFIDX ='PRIMARY SAMPLED FACIL IDENTIFIER' PN ='PERSON NUMBER' SPERIDX ='SAMPLE PERSON IDENTIFIER (OFIDX + PN)' RN ='DATA COLLECTION ROUND OF IUEQ' IUEQFIDX='FACILITY ID FOR IUEQ' NEWFTYPE='FACILITY TYPE BASED ON PHASE 1 FQ' FILE3IU ='NUM RECORDS FOR THIS IUEQID ON FILE3' BBOX6DD ='IUEQ BOX6 - COMPUTED BEGIN REF DATE - DD' BBOX6MM ='IUEQ BOX6 - COMPUTED BEGIN REF DATE - MM' BBOX6YY ='IUEQ BOX6 - COMPUTED BEGIN REF DATE - YY' EBOX6DD ='IUEQ BOX6 - COMPUTED END REF DATE - DD' EBOX6MM ='IUEQ BOX6 - COMPUTED END REF DATE - MM' EBOX6YY ='IUEQ BOX6 - COMPUTED END REF DATE - YY' EMERRMYN='IC6 SP GO TO HOSPITAL EMERGENCY ROOM' EMERRMNM='IC7 #TIMES SP WENT TO HOSP EMER ROOM' OUTDEPYN='IC8 SP GO TO HOSPITAL OUTPATIENT DEPT' OUTDEPNM='IC9 #TIMES SP GO TO HOSP OUTPATIENT DEPT' ISPSEE01='IC1A DID SP SEE DENTAL CARE PROFESSIONAL' ISPSEE02='IC1B DID SP SEE MENTAL HEALTH CARE PROF' ISPSEE03='IC10A DID SP SEE MEDICAL DOCTOR' ISPSEE04='IC10B DID SP SEE OPTOMETRIST' ISPSEE05='IC10C DID SP SEE PODIATRIST' ISPSEE06='IC10D DID SP SEE CHIROPRACTOR' ISPSEE07='IC15A DID SP SEE PHYSICAL THERAPIST' ISPSEE08='IC15B DID SP SEE OCCUPATIONAL THERAPIST' ISPSEE09='IC15C DID SP SEE SPEECH/HEARING THERAPIS' ISPSEE10='IC15D DID SP SEE RESPIRATORY THERAPIST' ISPSEE11='IC15E DID SP SEE I.V. THERAPIST' PRVDNURS='IC20 SP HAVE PRIVATE DUTY NURSING CARE' NUMWKNUR='IC21 #WEEKS SP HAVE PRIV DUTY NURS CARE' NUMDAWK ='IC22 #DAYS/WK SP HAVE PRIV DUTY NURS CAR' NURSPDFC='IC23 PRIV DUTY NURS PAID BY FACILITY' IUCAREMP='IC24 SP CARE PROVIDED BY EMPLOYEE' IUCARCON='IC24 SP CARE PROVIDED ON CONTRACT' IUCARELS='IC24 SP CARE PROVIDED BY SOMEONE ELSE' THE FOLLOWING SAS INPUT AND LABEL STATEMENTS ARE FOR USE WITH DATA FILE # 3 INPUT @1 IMEDIDX $18.0 @19 OFIDX 6.0 @25 PN 3.0 @28 SPERIDX 9.0 @37 RN 1.0 @38 IUEQFIDX 6.0 @44 IUEQIDX $16.0 @60 NEWFTYPE 1.0 @61 IMEDNX 2.0 @63 IQCCODE $4.0 @67 NUMVST 3.0 @70 NUMVSTFC 3.0 @73 NUMBYFC 3.0 @76 ICAREEMP 2.0 @78 ICARECON 2.0 @80 ICAREELS 2.0 @82 THEROS1 $30.0 @112 THEROS2 $30.0 LABEL IMEDIDX ='RECORD ID (OFIDX+PN+RN+IUEQFIDX+IMEDNX)' OFIDX ='PRIMARY SAMPLED FACIL IDENTIFIER' PN ='PERSON NUMBER' SPERIDX ='SAMPLE PERSON IDENTIFIER (OFIDX + PN)' RN ='DATA COLLECTION ROUND OF IUEQ' IUEQFIDX='FACILITY ID FOR IUEQ' IUEQIDX ='IUEQ ID (OFIDX + PN + RN + IUEQFIDX)' NEWFTYPE='FACILITY TYPE BASED ON PHASE 1 FQ' IMEDNX ='EDITED MED PROVIDER UTILIZATION REC NUM' IQCCODE ='IC1/10/15 TYPE HEALTH CARE PROVID SP SAW' NUMVST ='IC2/11/16 # TIMES SP SAW MED PROVIDER' NUMVSTFC='IC3/12/17 # TIMES SEEN IN THIS FACILITY' NUMBYFC ='IC4/13/18 # TIMES PAID FOR BY FACILITY' ICAREEMP='IC5/14/19 SP CARE PROVIDED BY EMPLOYEE' ICARECON='IC5/14/19 SP CARE PROVIDED ON CONTRACT' ICAREELS='IC5/14/19 SP CARE PROV BY SOMEONE ELSE' THEROS1 ='IC15F OTHER LICENSED THERAPIST 1' THEROS2 ='IC15F OTHER LICENSED THERAPIST 2' THE FOLLOWING ARE THE SAS VALUE STATEMENTS FOR USE WITH FILES 1, 2 AND 3 OF TAPE 28R: VALUE OFIDX 100016-119998 = '100016 - 119998'; VALUE PN 13-249 = '13-249'; VALUE SPERIDX 100016013-119998068 = 'VALID PERSON ID'; VALUE IUEQFIDX 100016-200558 = '100016 - 200558'; VALUE $POSVAL '1' - HIGH = 'VALID ID'; VALUE NEWFTYPE -1 = '-1 INAPPLICABLE' -9 = '-9 NOT ASCERTAIN' -8 = '-8 DK' -7 = '-7 REFUSED' 1 = '1 NH' 3 = '3 MR'; VALUE $PPSAMP 'A1' = 'A1 NA 1/1 - 4/30' 'A2' = 'A2 NA 5/1 - 8/31' 'A3' = 'A3 NA 9/1 -12/31' 'CR' = 'CR 1/1/87'; VALUE RESTYPE -1 = '-1 INAPPLICABLE' -9 = '-9 NOT ASCERTAIN' -8 = '-8 DK' -7 = '-7 REFUSED' 1 = '1 CURRENT RES' 2 = '2 NEW ADMIT'; VALUE DEC31AGE 0-20 = ' 0-20' 21-34 = '21-34' 35-64 = '35-64' 65-74 = '65-74' 75-84 = '75-84' 85-HIGH= '85+'; VALUE BSRACEX -1 = '-1 INAPPLICABLE' -9 = '-9 NOT ASCERTAIN' -8 = '-8 DK' -7 = '-7 REFUSED' 1 = '1 AMER INDIAN' 2 = '2 ASIAN/PACIFIC' 3 = '3 BLACK' 4 = '4 WHITE' 5 = '5 OTHER SPECIFY'; VALUE SPSEX 1 = '1 MALE' 2 = '2 FEMALE'; VALUE BQKADMMX -1 = '-1 INAPPLICABLE' -9 = '-9 NOT ASCERTAIN' -8 = '-8 DK' -7 = '-7 REFUSED' 1 = ' 1 JANUARY' 2 = ' 2 FEBRUARY' 3 = ' 3 MARCH' 4 = ' 4 APRIL' 5 = ' 5 MAY' 6 = ' 6 JUNE' 7 = ' 7 JULY' 8 = ' 8 AUGUST' 9 = ' 9 SEPTEMBER' 10 = '10 OCTOBER' 11 = '11 NOVEMBER' 12 = '12 DECEMBER'; VALUE BQKADDDX 1-31 = '1-31'; VALUE BQKADYYX 1917-1985= '1917-1985' 1986= ' 1986' 1987= ' 1987'; VALUE BQKADDF -1 = '-1 INAPPLICABLE' -9 = '-9 NOT ASCERTAIN' -8 = '-8 DK' -7 = '-7 REFUSED' 0 = '0 NOT IMPUTED' 1 = '1 DAY IMPUTED' 2 = '2 MONTH AND DAY' 3 = '3 ED TAPE 8 KAD'; VALUE VITAL -1 = '-1 INAPPLICABLE' -9 = '-9 NOT ASCERTAIN' -8 = '-8 DK' -7 = '-7 REFUSED' 1 = ' 1 LIVING' 2 = ' 2 DEAD'; VALUE SPDODMM -1 = '-1 INAPPLICABLE' -9 = '-9 NOT ASCERTAIN' -8 = '-8 DK' -7 = '-7 REFUSED' 1 = ' 1 JANUARY' 2 = ' 2 FEBRUARY' 3 = ' 3 MARCH' 4 = ' 4 APRIL' 5 = ' 5 MAY' 6 = ' 6 JUNE' 7 = ' 7 JULY' 8 = ' 8 AUGUST' 9 = ' 9 SEPTEMBER' 10 = '10 OCTOBER' 11 = '11 NOVEMBER' 12 = '12 DECEMBER'; VALUE SPDODDD -1 = '-1 INAPPLICABLE' -9 = '-9 NOT ASCERTAIN' -8 = '-8 DK' -7 = '-7 REFUSED' 1-31 = ' 1-31'; VALUE SPDODYY -1 = '-1 INAPPLICABLE' -9 = '-9 NOT ASCERTAIN' -8 = '-8 DK' -7 = '-7 REFUSED' 1987 = ' 1987'; VALUE DODIMPFL -1 = '-1 INAPPLICABLE' -9 = '-9 NOT ASCERTAIN' -8 = '-8 DK' -7 = '-7 REFUSED' 0 = ' 0 NOT IMPUTED' 1 = ' 1 IMPUTED'; VALUE KNDPLAC -7 = '-7 REFUSED' -8 = '-8 DK' -9 = '-9 NOT ASCERTAIN' -1 = '-1 INAPPLICABLE' 1 = ' 1 IN PSF' 2 = ' 2 HOUSE/APT' 3 = ' 3 RETIRMNT HOME' 4 = ' 4 BOARDING HSE' 5 = ' 5 FOSTER/FAMILY' 6 = ' 6 GROUP HOME' 7 = ' 7 NURSING HOME' 8 = ' 8 MR FACILITY' 9 = ' 9 HOSPITAL' 10 = '10 ON STREET' 21 = '21 CORRECTIONAL' 22 = '22 TRAINING CNTR' 91 = '91 OTHER'; VALUE KND1IMPF -7 = '-7 REFUSED' -8 = '-8 DK' -9 = '-9 NOT ASCERTAIN' -1 = '-1 INAPPLICABLE' 0 = ' 0 NOT IMPUTED' 1 = ' 1 IMPUTED'; VALUE KND2IMPF -7 = '-7 REFUSED' -8 = '-8 DK' -9 = '-9 NOT ASCERTAIN' -1 = '-1 INAPPLICABLE' 0 = ' 0 NOT IMPUTED' 1 = ' 1 IMPUTED'; VALUE CEDMME -7 = '-7 REFUSED' -8 = '-8 DK' -9 = '-9 NOT ASCERTAIN' -1 = '-1 INAPPLICABLE' 1 = ' 1 JANUARY' 2 = ' 2 FEBRUARY' 3 = ' 3 MARCH' 4 = ' 4 APRIL' 5 = ' 5 MAY' 6 = ' 6 JUNE' 7 = ' 7 JULY' 8 = ' 8 AUGUST' 9 = ' 9 SEPTEMBER' 10 = '10 OCTOBER' 11 = '11 NOVEMBER' 12 = '12 DECEMBER'; VALUE CEDDDE -7 = '-7 REFUSED' -8 = '-8 DK' -9 = '-9 NOT ASCERTAIN' -1 = '-1 INAPPLICABLE' 1-31 = '1-31'; VALUE CEDYYE 1882-1985 = '1882-1985' 1986 = ' 1986' 1987 = ' 1987'; VALUE CEDIMPFL -7 = '-7 REFUSED' -8 = '-8 DK' -9 = '-9 NOT ASCERTAIN' -1 = '-1 INAPPLICABLE' 0 = '0 NOT IMPUTED' 1 = '1 IMPUTED'; VALUE $USER '0' = '0 NOT A USER' '1' = '1 CR PSF JAN-DEC' '2' = '2 CR PSF' '3' = '3 CR PSF PSF' '4' = '4 CR PSF IPC' '5A'= '5A NA PSF-DEC' '5B'= '5B NA PSF' '5C'= '5C NA PSF PSF' '5D'= '5D NA PSF IPC' '7' = '7 NA IPC1/87 PSF' '8' = '8 NA IPC PSF'; VALUE RN 1 = '1' 2 = '2' 3 = '3'; VALUE BOX6MM -7 = '-7 REFUSED' -8 = '-8 DK' -9 = '-9 NOT ASCERTAIN' -1 = '-1 INAPPLICABLE' 1 = ' 1 JANUARY' 2 = ' 2 FEBRUARY' 3 = ' 3 MARCH' 4 = ' 4 APRIL' 5 = ' 5 MAY' 6 = ' 6 JUNE' 7 = ' 7 JULY' 8 = ' 8 AUGUST' 9 = ' 9 SEPTEMBER' 10 = '10 OCTOBER' 11 = '11 NOVEMBER' 12 = '12 DECEMBER'; VALUE BOX6DD -9 = '-9 NOT ASCERTAIN' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 1-31 = ' 1-31'; VALUE BOX6YY -9 = '-9 NOT ASCERTAIN' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 87 = ' 87'; VALUE YESNO -1 = '-1 INAPPLICABLE' -7 = '-7 REFUSED' -8 = '-8 DK' -9 = '-9 NOT ASCERTAIN' 1 = ' 1 YES' 2 = ' 2 NO'; VALUE NUMVAL -1 = '-1 INAPPLICABLE' -9 = '-9 NOT ASCERTAIN' -8 = '-8 DK' -7 = '-7 REFUSED' 0 = '0' 1 = '1' 2 = '2' 3 = '3' 4 = '4' 5 = '5' 6 = '6' 7 = '7' 8 = '8' 9 = '9' 10 = '10' 11 = '11' 12 = '12' 13 = '13' 14 = '14' 15 = '15' 16 = '16' 17 = '17' 18 = '18' 19 = '19' 20 = '20' 21 = '21' 22 = '22' 23 = '23' 24 = '24' 25 = '25' 26 = '26' 27 = '27'; VALUE NUMWKNUR -1 = '-1 INAPPLICABLE' -9 = '-9 NOT ASCERTAIN' -8 = '-8 DK' -7 = '-7 REFUSED' 0 = ' 0' 1 = ' 1' 2 = ' 2' 3 = ' 3' 4 = ' 4' 5 = ' 5' 6 = ' 6' 7 = ' 7' 8 = ' 8' 9 = ' 9' 10 = '10' 11-20 = '11-20' 21-41 = '21-41'; VALUE NUMVST -9 = '-9 NOT ASCERTAIN' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 0 = ' 0' 1 = ' 1' 2 = ' 2' 3 = ' 3' 4 = ' 4' 5 = ' 5' 6 = ' 6' 7 = ' 7' 8 = ' 8' 9 = ' 9' 10 = '10' 11-25 = '11-25' 26-50 = '26-50' 51-75 = '51-75' 76-100 = '76-100' 101-125 = '101-125' 126-150 = '126-150' 151-175 = '151-175' 175-200 = '175-200' 200<-HIGH = 'GT 200'; VALUE OUTDEPNM -9 = '-9 NOT ASCERTAIN' -8 = '-8 DK' -7 = '-7 REFUSED' -1 = '-1 INAPPLICABLE' 0 = ' 0' 1 = ' 1' 2 = ' 2' 3 = ' 3' 4 = ' 4' 5 = ' 5' 6 = ' 6' 7 = ' 7' 8 = ' 8' 9 = ' 9' 10 = '10' 11-25 = '11-25' 25<-HIGH = 'GT 25'; VALUE WIUEQEXP -7 = '-7 REFUSED' -8 = '-8 DK' -9 = '-9 NOT ASCERTAIN' -1 = '-1 INAPPLICABLE' 0 = '0' 1.98-2005.67 = '1.98-2005.67'; VALUE STAIUEQ -7 = '-7 REFUSED' -8 = '-8 DK' -9 = '-9 NOT ASCERTAIN' -1 = '-1 INAPPLICABLE' 1-40 = '1-40'; VALUE PSUIUEQ -7 = '-7 REFUSED' -8 = '-8 DK' -9 = '-9 NOT ASCERTAIN' -1 = '-1 INAPPLICABLE' 1-392 = '1-392'; VALUE $IQCCODE '-1' = '-1 INAPPLICABLE' '-9' = '-9 NOT ASCERTAIN' '-8' = '-8 DK' '-7' = '-7 REFUSED' 'C1a ' = ' C1A DENTAL' 'C1b ' = ' C1B MENTAL HLTH' 'C10a' = ' C10A MED DOCTOR' 'C10b' = ' C10B OPTOMETRIST' 'C10c' = ' C10C PODIATRIST' 'C10d' = ' C10D CHIROPRACTR' 'C15a' = ' C15A PHYSIC THER' 'C15b' = ' C15B OCCUPA THER' 'C15c' = ' C15C SP/HEA THER' 'C15d' = ' C15D RESPIR THER' 'C15e' = ' C15E I.V. THER' 'C15f' = ' C15F OTHER THER'; VALUE $THEROS '-1' = '-1 INAPPLICABLE' '-7' = '-7 REFUSED' '-8' = '-8 DK' '-9' = '-9 NOT ASCERTAIN' 'A' - 'ZZZZ' = 'A - Z'; THE FOLLOWING SAS FORMAT STATEMENT IS FOR USE WITH DATA FILE # 1 FORMAT OFIDX OFIDX. PN PN. SPERIDX SPERIDX. NEWFTYPE NEWFTYPE. FILE2SP NUMVAL. FILE3SP NUMVAL. PPSAMP $PPSAMP. RESTYPE RESTYPE. DEC31AGE DEC31AGE. BSRACEX BSRACEX. SPSEX SPSEX. USER $USER. WIUEQEXP WIUEQEXP. STAIUEQ1 STAIUEQ. PSUIUEQ1 PSUIUEQ. THE FOLLOWING SAS FORMAT STATEMENT IS FOR USE WITH DATA FILE # 2 FORMAT IUEQIDX $POSVAL. OFIDX OFIDX. PN PN. SPERIDX SPERIDX. RN RN. IUEQFIDX IUEQFIDX. NEWFTYPE NEWFTYPE. FILE3IU NUMVAL. BBOX6DD BOX6DD. BBOX6MM BOX6MM. BBOX6YY BOX6YY. EBOX6DD BOX6DD. EBOX6MM BOX6MM. EBOX6YY BOX6YY. EMERRMYN YESNO. EMERRMNM NUMVAL. OUTDEPYN YESNO. OUTDEPNM OUTDEPNM. ISPSEE01 YESNO. ISPSEE02 YESNO. ISPSEE03 YESNO. ISPSEE04 YESNO. ISPSEE05 YESNO. ISPSEE06 YESNO. ISPSEE07 YESNO. ISPSEE08 YESNO. ISPSEE09 YESNO. ISPSEE10 YESNO. ISPSEE11 YESNO. PRVDNURS YESNO. NUMWKNUR NUMWKNUR. NUMDAWK NUMVAL. NURSPDFC YESNO. IUCAREMP YESNO. IUCARCON YESNO. IUCARELS YESNO. THE FOLLOWING SAS FORMAT STATEMENT IS FOR USE WITH DATA FILE # 1 FORMAT IMEDIDX $POSVAL. OFIDX OFIDX. PN PN. SPERIDX SPERIDX. RN RN. IUEQFIDX IUEQFIDX. IUEQIDX $POSVAL. NEWFTYPE NEWFTYPE. IMEDNX NUMVAL. IQCCODE $IQCCODE. NUMVST NUMVST. NUMVSTFC NUMVST. NUMBYFC NUMVST. ICAREEMP YESNO. ICARECON YESNO. ICAREELS YESNO. THEROS1 $THEROS. THEROS2 $THEROS.
