SAS User File for H56 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 (H56.SSP) or the ASCII data file (H56.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\H56.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.H56;
TITLE 'List of Variables in MEPS H56 SAS Dataset';
RUN;
PROC PRINT DATA=PUFLIB.H56 (OBS=20);
TITLE 'First 20 Observations in MEPS H56 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) H56 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
H56.SAS7BDAT will be created under the C:\MEPS directory when PROC
XCOPY runs successfully.
4) The SAS transport file H56.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 H56.DAT to a SAS data
set as described in Section B.
ADDITIONAL 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\H56.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 H56.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\H56.DAT';
DATA PUFLIB.H56;
INFILE IN1 LRECL=247;
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
assigning an internal SAS dataset name (H56). In the example, after the
successful completion of the DATA step, a PC file named H56.SAS7BDAT 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 (247
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 H56.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., 247 for H56.DAT). If RECFM=F is used, then the
LRECL value must be specified as the logical record length plus 2 (247 for
H56.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 (247 for H56.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 (H56.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.
ADDITIONAL 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 SAS Transport file - e.g.,
LIBNAME PUFLIB 'C:\MEPS';
FILENAME IN1 'C:\DOWNLOAD\H56.SSP';
PROC XCOPY IN=IN1 OUT=PUFLIB IMPORT
RUN;
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.H56;
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 'SAS7BDAT')
and format libraries (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 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 H56.DAT file into a SAS data set, and for creating
SAS formats.
* INPUT STATEMENTS;
INFILE IN LRECL=247;
INPUT @1 JOBSIDX $11.0
@12 DUPERSID $8.0
@20 DUID 5.0
@25 PID 3.0
@28 RN 1.0
@29 JOBSN 1.0
@30 PANEL 1.0
@31 JOBTYPE 2.0
@33 JSTRTM 2.0
@35 JSTRTD 2.0
@37 JSTRTY 4.0
@41 JSTOPM 2.0
@43 JSTOPD 2.0
@45 JSTOPY 4.0
@49 RETIRJOB 1.0
@50 SUBTYPE 1.0
@51 MAIN_JOB 2.0
@53 DIFFWAGE 2.0
@55 WHY_DIFF 2.0
@57 WORKSTAT 2.0
@59 Y_CHANGE 2.0
@61 STILLWRK 2.0
@63 OFFTAKEI 2.0
@65 NOWTAKEI 2.0
@67 WHY_LEFT 2.0
@69 NUMEMPS 5.0
@74 ESTMATE1 2.0
@76 MORELOC 2.0
@78 BUSINC 2.0
@80 PROPRIET 2.0
@82 TYPEEMPL 2.0
@84 YLEFT 2.0
@86 YNOBUSN 2.0
@88 RECALL 2.0
@90 HRSPRWK 3.0
@93 HRS35WK 2.0
@95 APXHRDAY 2.0
@97 SICKPAY 2.0
@99 PAYDRVST 2.0
@101 PAYVACTN 2.0
@103 RETIRPLN 2.0
@105 WKLYAMT 7.2
@112 EMPLINS 2.0
@114 OFFRDINS 2.0
@116 DIFFPLNS 2.0
@118 INUNION 2.0
@120 PROVDINS 2.0
@122 HHMEMBER 2.0
@124 NUMFMEMB 2.0
@126 TOTLEMP 5.0
@131 SALARIED 2.0
@133 HOWPAID 2.0
@135 DAYWAGE 6.2
@141 HRSPRDY 2.0
@143 MAKEAMT 9.2
@152 PERUNIT 2.0
@154 MORE10 2.0
@156 MORE15 2.0
@158 MOREMINM 2.0
@160 OVRTIMHR 6.2
@166 GROSSPAY 9.2
@175 GROSSPER 2.0
@177 SALRYWKS 2.0
@179 OTHRTYPE 2.0
@181 EARNTIPS 2.0
@183 EARNBONS 2.0
@185 EARNCOMM 2.0
@187 OTHRWAGE 6.2
@193 TIPSUNIT 2.0
@195 TIPSAMT 8.2
@203 BONSUNIT 2.0
@205 BONSAMT 9.2
@214 COMMUNIT 2.0
@216 COMMAMT 9.2
@225 HRLYWAGE 6.2
@231 JOBHASHI 2.0
@233 STILLAT 2.0
@235 SHFTCHNG 2.0
@237 SESNLJOB 2.0
@239 TEMPJOB 2.0
@241 HRSALBAS 3.0
@244 INDTCODX 2.0
@246 OCCPCODX 2.0
;
* FORMAT STATEMENTS;
FORMAT JOBSIDX $JOBSIDX.
DUPERSID $DUPERSI.
DUID DUID.
PID PID.
RN RN.
JOBSN JOBSN.
PANEL PANEL.
JOBTYPE JOBTYPE.
JSTRTM JSTRTM.
JSTRTD JSTRTD.
JSTRTY JSTRTY.
JSTOPM JSTOPM.
JSTOPD JSTOPD.
JSTOPY JSTOPY.
RETIRJOB RETIRJOB.
SUBTYPE SUBTYPE.
MAIN_JOB MAIN_JOB.
DIFFWAGE DIFFWAGE.
WHY_DIFF WHY_DIFF.
WORKSTAT WORKSTAT.
Y_CHANGE Y_CHANGE.
STILLWRK STILLWRK.
OFFTAKEI OFFTAKEI.
NOWTAKEI NOWTAKEI.
WHY_LEFT WHY_LEFT.
NUMEMPS NUMEMPS.
ESTMATE1 ESTMAT1F.
MORELOC MORELOC.
BUSINC BUSINC.
PROPRIET PROPRIET.
TYPEEMPL TYPEEMPL.
YLEFT YLEFT.
YNOBUSN YNOBUSN.
RECALL RECALL.
HRSPRWK HRSPRWK.
HRS35WK HRS35WK.
APXHRDAY APXHRDAY.
SICKPAY SICKPAY.
PAYDRVST PAYDRVST.
PAYVACTN PAYVACTN.
RETIRPLN RETIRPLN.
WKLYAMT WKLYAMT.
EMPLINS EMPLINS.
OFFRDINS OFFRDINS.
DIFFPLNS DIFFPLNS.
INUNION INUNION.
PROVDINS PROVDINS.
HHMEMBER HHMEMBER.
NUMFMEMB NUMFMEMB.
TOTLEMP TOTLEMP.
SALARIED SALARIED.
HOWPAID HOWPAID.
DAYWAGE DAYWAGE.
HRSPRDY HRSPRDY.
MAKEAMT MAKEAMT.
PERUNIT PERUNIT.
MORE10 MORE10F.
MORE15 MORE15F.
MOREMINM MOREMINM.
OVRTIMHR OVRTIMHR.
GROSSPAY GROSSPAY.
GROSSPER GROSSPER.
SALRYWKS SALRYWKS.
OTHRTYPE OTHRTYPE.
EARNTIPS EARNTIPS.
EARNBONS EARNBONS.
EARNCOMM EARNCOMM.
OTHRWAGE OTHRWAGE.
TIPSUNIT TIPSUNIT.
TIPSAMT TIPSAMT.
BONSUNIT BONSUNIT.
BONSAMT BONSAMT.
COMMUNIT COMMUNIT.
COMMAMT COMMAMT.
HRLYWAGE HRLYWAGE.
JOBHASHI JOBHASHI.
STILLAT STILLAT.
SHFTCHNG SHFTCHNG.
SESNLJOB SESNLJOB.
TEMPJOB TEMPJOB.
HRSALBAS HRSALBAS.
INDTCODX INDTCODX.
OCCPCODX OCCPCODX.
;
* LABEL STATEMENTS;
LABEL JOBSIDX ='JOB ID NUMBER'
DUPERSID='SAMPLE PERSON ID (DUID+PID)'
DUID ='DWELLING UNIT ID'
PID ='PERSON NUMBER'
RN ='ROUND'
JOBSN ='JOB NUMBER'
PANEL ='PANEL'
JOBTYPE ='SELF-EMPLOYED OR WORK FOR SOMEONE ELSE'
JSTRTM ='JOB START DATE - MONTH'
JSTRTD ='JOB START DATE - DAY'
JSTRTY ='JOB START DATE - YEAR'
JSTOPM ='JOB STOP DATE - MONTH'
JSTOPD ='JOB STOP DATE - DAY'
JSTOPY ='JOB STOP DATE - YEAR'
RETIRJOB='PERSON RETIRED FROM THIS JOB'
SUBTYPE ='JOB SUB-TYPE'
MAIN_JOB='STILL MAIN JOB OR BUSINESS'
DIFFWAGE='ANY CHANGE IN WAGE AMOUNT'
WHY_DIFF='WHY WAGES CHANGED'
WORKSTAT='FULL OR PART TIME'
Y_CHANGE='WHY CHANGE IN FULL/PART TIME STATUS'
STILLWRK='STILL WORK AT ESTABLISHMENT'
OFFTAKEI='OFFERED INSURANCE AND NOW TAKE'
NOWTAKEI='NOW OFFERED AND TAKE INSURANCE'
WHY_LEFT='REASON WHY NOT AT JOB NOW'
NUMEMPS ='ESTABLISHMENT SIZE-NONSELF-EMP'
ESTMATE1='CATEGORICAL APPROX. ESTAB SIZE'
MORELOC ='MORE THAN ONE LOCATION'
BUSINC ='BUSINESS INCORPORATED'
PROPRIET='PROPRIETORSHIP OR PARTNERSHIP'
TYPEEMPL='EMPLOYEE TYPE'
YLEFT ='NO JOB REASON'
YNOBUSN ='WHY NO BUSINESS'
RECALL ='RECALL WITHIN 30 DAYS'
HRSPRWK ='NUMBER OF HOURS PER WEEK'
HRS35WK ='WORK AT LEAST 35 HOURS'
APXHRDAY='APPROXIMATE # OF HOURS WORKED PER DAY'
SICKPAY ='DOES PERSON HAVE PAID SICK LEAVE'
PAYDRVST='IS THERE PAID SICK LEAVE FOR DR S VISITS'
PAYVACTN='DOES PERSON GET PAID VACATION'
RETIRPLN='DOES PERSON HAVE PENSION/RETIREMENT PLAN'
WKLYAMT ='USUAL WEEKLY GROSS INCOME'
EMPLINS ='HAVE HEALTH INSURANCE THRU THIS JOB'
OFFRDINS='OFFERED INSURANCE BUT CHOSE NOT TO TAKE'
DIFFPLNS='CHOICE OF DIFFERENT HEALTH INS PLANS'
INUNION ='BELONG TO LABOR UNION'
PROVDINS='WHO PROVIDES HEALTH INSURANCE'
HHMEMBER='ANY OTHER HH MEMBER WRK AT THIS BUSINESS'
NUMFMEMB='HOW MANY HH MEMBERS WORK THERE'
TOTLEMP ='ESTABLISHMENT SIZE-SELF-EMP'
SALARIED='IS PERSON SALARIED, PAID BY THE HR, ETC.'
HOWPAID ='HOW IS PERSON PAID'
DAYWAGE ='PERSON S DAILY WAGE RATE'
HRSPRDY ='NUMBER OF HOURS PERSON WORKED IN ONE DAY'
MAKEAMT ='HOW MUCH MONEY DOES PERSON MAKE'
PERUNIT ='PERIOD FOR WHICH PERSON IS PAID'
MORE10 ='PERSON MAKES MORE OR LESS THAN $10/HOUR'
MORE15 ='PERSON MAKES MORE OR LESS THAN $15/HOUR'
MOREMINM='PERSON MAKES MORE OR LESS THAN MIN. WAGE'
OVRTIMHR='OVERTIME PAY RATE PER HOUR'
GROSSPAY='PERSON S SALARY BEFORE TAXES (GROSS)'
GROSSPER='PERIOD IN WHICH GROSS SALARY WAS EARNED'
SALRYWKS='WEEKS PER YEAR SALARY IS BASED ON'
OTHRTYPE='TYPE OF OVERTIME PAY'
EARNTIPS='DOES PERSON EARN TIPS'
EARNBONS='DOES PERSON EARN BONUSES'
EARNCOMM='DOES PERSON EARN COMMISSION'
OTHRWAGE='OVERTIME PAY RATE PER HOUR'
TIPSUNIT='PERIOD WHICH TIP EARNINGS ARE BASED ON'
TIPSAMT ='HOW MUCH ARE PERSON S TIPS'
BONSUNIT='PERIOD WHICH BONUSES ARE BASED ON'
BONSAMT ='HOW MUCH ARE PERSON S BONUSES'
COMMUNIT='PERIOD WHICH COMMISSIONS ARE BASED ON'
COMMAMT ='HOW MUCH ARE PERSON S COMMISSIONS'
HRLYWAGE='HOW MUCH PERSON MAKES/HR'
JOBHASHI='DOES PERSON HAVE HEALTH INS AT THIS JOB'
STILLAT ='STILL WORK AT ESTABLISHMENT'
SHFTCHNG='HAS A CHANGE IN SHIFT OCCURRED'
SESNLJOB='IS CURRENT MAIN JOB A SEASONAL JOB'
TEMPJOB ='IS CURRENT MAIN JOB A TEMPORARY JOB'
HRSALBAS='HOURS SALARY BASED ON'
INDTCODX='CONDENSED INDUSTRY CODE'
OCCPCODX='CONDENSED OCCUPATION CODE'
;
* VALUE STATEMENTS;
VALUE APXHRDAY
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
2 - 20 = '2 - 20 HRS/DAY'
;
VALUE BONSAMT
-10 = '-10 HOURLY WAGE >= $100.96'
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
0.02 - 135000 = '0.02 - 135,000.00'
;
VALUE BONSUNIT
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 PER HOUR'
2 = '2 PER DAY'
3 = '3 PER WEEK'
4 = '4 PER TWO WKS'
5 = '5 PER MONTH'
6 = '6 PER YEAR'
91 = '91 OTHER'
;
VALUE BUSINC
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE COMMAMT
-10 = '-10 HOURLY WAGE >= $100.96'
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
0.05 - 200000 = '0.05 - 200,000.00'
;
VALUE COMMUNIT
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 PER HOUR'
2 = '2 PER DAY'
3 = '3 PER WEEK'
4 = '4 PER TWO WKS'
5 = '5 PER MONTH'
6 = '6 PER YEAR'
91 = '91 OTHER'
;
VALUE DAYWAGE
-10 = '-10 HOURLY WAGE >= $100.96'
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
1.25 - 600 = '1.25 - 600.00'
;
VALUE DIFFPLNS
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES, GT ONE'
2 = '2 NO, ONLY ONE'
;
VALUE DIFFWAGE
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE DUID
40001 - 85356 = 'VALID ID'
;
VALUE $DUPERSI
'40001020' - '85356028' = 'VALID ID'
;
VALUE EARNBONS
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE EARNCOMM
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE EARNTIPS
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE EMPLINS
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE ESTMAT1F
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 1 - 9'
2 = '2 10 - 25'
3 = '3 26 - 49'
4 = '4 50 - 100'
5 = '5 101 - 500'
6 = '6 501 - 1000'
7 = '7 1001 - 5000'
8 = '8 5001 OR MORE'
;
VALUE GROSSPAY
-10 = '-10 HOURLY WAGE >= $100.96'
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
1.12 - 200000 = '1.12 - 200,000.00'
;
VALUE GROSSPER
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 PER YEAR'
2 = '2 PER MONTH'
3 = '3 PER TWO WKS'
4 = '4 PER WEEK'
91 = '91 OTHER'
;
VALUE HHMEMBER
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE HOWPAID
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 BY THE DAY'
2 = '2 PIECEWORK'
3 = '3 COMMISSION'
4 = '4 BONUS'
5 = '5 BY JOB/MILE'
91 = '91 OTHER'
;
VALUE HRLYWAGE
-10 = '-10 HOURLY WAGE >= $100.96'
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
0.03 - 100 = '0.03 - 100.00'
;
VALUE HRS35WK
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE HRSALBAS
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 - 20 = '1 - 20'
21 - 30 = '21 - 30'
31 - 40 = '31 - 40'
41 - 60 = '41 - 60'
61 - 80 = '61 - 80'
81 - 84 = '81 - 84'
85 - 168 = '85 - 168'
;
VALUE HRSPRDY
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
1 - 4 = '1 - 4'
5 - 8 = '5 - 8'
9 - 15 = '9 - 15'
16 - 24 = '16 - 24'
;
VALUE HRSPRWK
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
1 - 20 = '1 - 20'
21 - 30 = '21 - 30'
31 - 40 = '31 - 40'
41 - 60 = '41 - 60'
61 - 80 = '61 - 80'
81 - 120 = '81 - 120'
121 - 168 = '121 - 168'
;
VALUE INDTCODX
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 AGRICULTURE, FORESTRY, FISHERIES'
2 = '2 MINING'
3 = '3 CONSTRUCTION'
4 = '4 MANUFACTURING'
5 = '5 TRANSPORTATION, COMMUNICATION, UTILITIES'
6 = '6 SALES'
7 = '7 FINANCE, INSURANCE, REAL ESTATE'
8 = '8 REPAIR SERVICES'
9 = '9 PERSONAL SERVICES'
10 = '10 ENTERTAINMENT AND RECREATION'
11 = '11 PROFESSIONAL SERVICES'
12 = '12 PUBLIC ADMINISTRATION'
13 = '13 UNCLASSIFIABLE INDUSTRY'
14 = '14 ACTIVE MILITARY'
;
VALUE INUNION
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE JOBHASHI
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE $JOBSIDX
'40001020101' - '85356028405' = 'VALID ID'
;
VALUE JOBSN
1 - 7 = '1 - 7'
;
VALUE JOBTYPE
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 SELF-EMPLOYED'
2 = '2 FOR SOMEONE ELSE'
;
VALUE JSTOPD
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 - 31 = '1 - 31'
;
VALUE JSTOPM
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 - 12 = '1 - 12'
;
VALUE JSTOPY
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0 STILL AT JOB'
1930 - 2000 = '1930 - 2000'
2001 = '2001'
2002 = '2002'
;
VALUE JSTRTD
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 - 31 = '1 - 31'
;
VALUE JSTRTM
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 - 12 = '1 - 12'
;
VALUE JSTRTY
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1939 - 1994 = '1939 - 1994'
1995 = '1995'
1996 = '1996'
1997 = '1997'
1998 = '1998'
1999 = '1999'
2000 = '2000'
2001 = '2001'
;
VALUE MAIN_JOB
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE MAKEAMT
-10 = '-10 HOURLY WAGE >= $100.96'
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
0.06 - 200000 = '0.06 - 200,000.00'
;
VALUE MORE10F
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 GE $10'
2 = '2 LT $10'
;
VALUE MORE15F
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 GE $15'
2 = '2 LT $15'
;
VALUE MORELOC
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE MOREMINM
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 GE MINIMUM WAGE'
2 = '2 LT MINIMUM WAGE'
;
VALUE NOWTAKEI
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE NUMEMPS
-10 = '-10 # OF EMP >= 12,000'
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
1 - 9 = '1 - 9'
10 - 25 = '10 - 25'
26 - 49 = '26 - 49'
50 - 100 = '50 - 100'
101 - 500 = '101 - 500'
501 - 11000 = '501 - 11,000'
;
VALUE NUMFMEMB
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
1 - 10 = '1 - 10'
;
VALUE OCCPCODX
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 PROFESSIONAL, TECHNICAL, AND KINDRED'
2 = '2 MANAGERIAL AND ADMINISTRATIVE'
3 = '3 SALES WORKERS'
4 = '4 CLERICAL AND KINDRED WORKERS'
5 = '5 CRAFTSMEN AND FOREMEN'
6 = '6 OPERATIVES'
7 = '7 TRANSPORT OPERATIVES'
8 = '8 SERVICE WORKERS'
9 = '9 LABORERS, NOT FARMING'
10 = '10 FARM OWNERS AND MANAGERS'
11 = '11 FARM LABORERS AND FOREMEN'
12 = '12 UNCLASSIFIABLE OCCUPATION'
13 = '13 ACTIVE MILITARY'
14 = '14 LAST WORKED PRIOR TO 1984'
;
VALUE OFFRDINS
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE OFFTAKEI
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE OTHRTYPE
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 DOES NOT WORK OVERTIME'
2 = '2 STRAIGHT TIME'
3 = '3 TIME AND A HALF'
4 = '4 COMP TIME'
5 = '5 EXACT AMOUNT'
91 = '91 OTHER'
;
VALUE OTHRWAGE
-10 = '-10 HOURLY WAGE >= $100.96'
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
0.12 - 100 = '0.12 - 100.00'
;
VALUE OVRTIMHR
-10 = '-10 HOURLY WAGE >= $100.96'
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
0.02 - 178 = '0.02 - 178.00'
;
VALUE PANEL
5 = '5'
6 = '6'
;
VALUE PAYDRVST
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE PAYVACTN
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE PERUNIT
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 PER HOUR'
2 = '2 PER DAY'
3 = '3 PER WEEK'
4 = '4 PER TWO WKS'
5 = '5 PER MONTH'
6 = '6 PER YEAR'
91 = '91 OTHER'
;
VALUE PID
10 - 167 = '010 - 167'
;
VALUE PROPRIET
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE PROVDINS
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 EMPLOYER'
2 = '2 UNION'
3 = '3 BOTH'
;
VALUE RECALL
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE RETIRJOB
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE RETIRPLN
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE RN
1 = '1'
2 = '2'
3 = '3'
4 = '4'
5 = '5'
;
VALUE SALARIED
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 SALARIED'
2 = '2 PAID BY HOUR'
3 = '3 OTHER'
;
VALUE SALRYWKS
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
1 - 52 = '1 - 52 WKS'
;
VALUE SESNLJOB
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YEAR ROUND'
2 = '2 NOT YEAR ROUND'
;
VALUE SHFTCHNG
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE SICKPAY
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE STILLAT
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE STILLWRK
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE SUBTYPE
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 CUR MAIN JOB IN REF PD'
2 = '2 CUR MISC JOB IN REF PD'
3 = '3 FMR MAIN JOB IN REF PD'
4 = '4 FMR MISC JOB IN REF PD'
5 = '5 LAST JOB OUTSD REF PD'
6 = '6 RETIREMENT JOB'
;
VALUE TEMPJOB
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 YES'
2 = '2 NO'
;
VALUE TIPSAMT
-10 = '-10 HOURLY WAGE >= $100.96'
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
0.02 - 40000 = '0.02 - 40,000.00'
;
VALUE TIPSUNIT
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 PER HOUR'
2 = '2 PER DAY'
3 = '3 PER WEEK'
4 = '4 PER TWO WKS'
5 = '5 PER MONTH'
6 = '6 PER YEAR'
91 = '91 OTHER'
;
VALUE TOTLEMP
-10 = '-10 # OF EMP >= 12,000'
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
1 - 10000 = '1 - 10,000'
;
VALUE TYPEEMPL
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 PRIVATE'
2 = '2 FEDERAL'
3 = '3 STATE'
4 = '4 LOCAL'
5 = '5 ARMED FORCES'
6 = '6 FOREIGN NON US GOV'
;
VALUE WHY_DIFF
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 PROMOTION OR DEMOTION'
2 = '2 CHANGE IN RESP'
3 = '3 PAY RAISE/DECREASE'
4 = '4 ANUL COST OF LIVING INCR'
5 = '5 NEW CONTRACT'
6 = '6 CHANGE IN # HRS WRKD'
7 = '7 CHANGE IN SHIFT TIME'
8 = '8 RECEIVED EDU DEGREE'
9 = '9 TOOK SPECIAL CLASSES'
91 = '91 OTHER'
;
VALUE WHY_LEFT
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 JOB ENDED'
2 = '2 BUSINESS DISSOLVED OR SOLD'
3 = '3 RETIRED'
4 = '4 ILLNESS OR INJURY'
5 = '5 LAID OFF'
6 = '6 QUIT TO HAVE A BABY'
7 = '7 QUIT TO GO TO SCHOOL'
8 = '8 QUIT TO TAKE CARE OF HOME/FAM'
9 = '9 QUIT BECAUSE WANTED TIME OFF'
10 = '10 QUIT TO TAKE OTHER JOB'
11 = '11 UNPAID LEAVE'
91 = '91 OTHER'
;
VALUE WKLYAMT
-10 = '-10 HOURLY WAGE >= $100.96'
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
0 = '0'
0.02 - 4000 = '0.02 - 4,000.00'
;
VALUE WORKSTAT
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 GE 35 HRS'
2 = '2 LT 35 HRS'
;
VALUE YLEFT
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 JOB ENDED'
2 = '2 RETIRED'
3 = '3 ILLNESS OR INJURY'
4 = '4 LAID OFF'
5 = '5 HAVE BABY'
6 = '6 SCHOOL'
7 = '7 HOME CARE'
8 = '8 TIME OFF'
9 = '9 OTHER JOB'
91 = '91 OTHER REASON'
;
VALUE YNOBUSN
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 BUSINESS SOLD'
2 = '2 RETIRED'
3 = '3 ILLNESS OR INJURY'
4 = '4 HAVE BABY'
5 = '5 SCHOOL'
6 = '6 HOME CARE'
7 = '7 TIME OFF'
8 = '8 OTHER JOB'
91 = '91 OTHER REASON'
;
VALUE Y_CHANGE
-9 = '-9 NOT ASCERTAINED'
-8 = '-8 DK'
-7 = '-7 REFUSED'
-1 = '-1 INAPPLICABLE'
1 = '1 PROMOTION OR DEMOTION'
2 = '2 CHANGE IN RESPONSIBILITIES'
3 = '3 CHANGE IN AMT OF WRK BUS BRINGS'
4 = '4 CHANGE IN SHIFT TIME'
5 = '5 CHANGE IN # OF EMPLOYEE AVAIL'
6 = '6 ILLNESS/DISABILITY'
7 = '7 TEMPORARY LEAVE'
8 = '8 MATERNITY/PATERNITY LEAVE'
9 = '9 GOING TO SCHL/FINISHED SCHL'
10 = '10 CHANGE IN HOME/FAM SITUATION'
11 = '11 NEED TIME OFF/WANT WRK MORE'
91 = '91 OTHER'
;