1 The SAS System 16:08 Sunday, November 21, 2004
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
Licensed to AGENCY FOR HEALTHCARE RESEARCH & QUALITY, Site 0040776001.
NOTE: This session is executing on the WIN_PRO platform.
1 options ls=120 ps=79 nodate;
2 ods noproctitle;
3
4 /************************************************************************************\
5 Program: c:\meps\prog\Example_L1A.sas
6
7 Description: This example shows how to:
8 (1) Identify 2001 jobs in that began in 2000
9 (2) Identify first-reported 2000 jobs
10 (3) Update missing 2001 values with 2000 values
11
12 Input Files: c:\meps\data\h40.sas7bdat (2000 Jobs)
13 c:\meps\data\h56.sas7bdat (2001 Jobs)
14 \************************************************************************************/
15
16 libname hc 'c:\meps\data';
NOTE: Libref HC was successfully assigned as follows:
Engine: V8
Physical Name: c:\meps\data
17
18 title 'AHRQ MEPS DATA USERS WORKSHOP (LINKING) -- NOV/DEC 2004';
19 title2 'Link 2000 and 2001 JOBS Files';
20
21 proc format;
22 value yn
23 -9='-9 Not Asc'
24 -8='-8 DK'
25 -7='-7 Refised'
26 -1='-1 Inappl'
27 1=' 1 Yes'
28 2=' 2 No';
NOTE: Format YN has been output.
29 run;
30
31 *---------------------------------------------------------------------------------------;
32
33 title3 'Sample Listing, All Job Records for Persons Who Have the Same Job in 2000 and 2001';
34 title4 'Variables of Interest Are SICKPAY, PAYDRVST, & PAYVACTN';
35
36 data s00; set hc.h40(where=(dupersid in('80001021','80005018','80005025','80006012',
37 '80006029') & rn in(1,2))); YEAR=2000;
38 run;
NOTE: There were 10 observations read from the data set HC.H40.
WHERE dupersid in ('80001021', '80005018', '80005025', '80006012', '80006029') and rn in (1, 2);
NOTE: The data set WORK.S00 has 10 observations and 89 variables.
39 proc sort; by dupersid jobsn rn; run;
NOTE: There were 10 observations read from the data set WORK.S00.
NOTE: The data set WORK.S00 has 10 observations and 89 variables.
40
41 data s01; set hc.h56(where=(dupersid in('80001021','80005018','80005025','80006012',
42 '80006029'))); YEAR=2001;
43 run;
NOTE: There were 15 observations read from the data set HC.H56.
WHERE dupersid in ('80001021', '80005018', '80005025', '80006012', '80006029');
NOTE: The data set WORK.S01 has 15 observations and 84 variables.
44 proc sort; by dupersid jobsn rn; run;
NOTE: There were 15 observations read from the data set WORK.S01.
NOTE: The data set WORK.S01 has 15 observations and 84 variables.
45
46 data; set
2 The SAS System
47 s00
48 s01; by dupersid jobsn;
49 label dupersid=' '; /* drop label for print output */
50
NOTE: There were 10 observations read from the data set WORK.S00.
NOTE: There were 15 observations read from the data set WORK.S01.
NOTE: The data set WORK.DATA1 has 25 observations and 91 variables.
51 proc print; by dupersid;
52 var year rn jobsn subtype stillat sickpay--payvactn;
53 run;
NOTE: There were 25 observations read from the data set WORK.DATA1.
NOTE: The PROCEDURE PRINT printed page 1.
54
55 *---------------------------------------------------------------------------------------;
56
57 title3 '2001 Current Main Jobs that Began in 2000';
58
59 /* Identify 2001 CMJs (panel 5, rn 3) that began in 2000 */
60 data cmj01; set hc.h56(keep=dupersid panel rn jobsn subtype stillat sickpay--payvactn);
61 if panel=5 & rn=3 & subtype=1 & stillat=1;
62 run;
NOTE: There were 61265 observations read from the data set HC.H56.
NOTE: The data set WORK.CMJ01 has 4162 observations and 9 variables.
63 proc sort; by dupersid jobsn rn; run;
NOTE: There were 4162 observations read from the data set WORK.CMJ01.
NOTE: The data set WORK.CMJ01 has 4162 observations and 9 variables.
64
65 title4 '2001 (Panel 5 Round 3) Records';
66 proc freq; tables
67 sickpay--payvactn/missing;
68 format sickpay--payvactn yn.;
69 run;
NOTE: There were 4162 observations read from the data set WORK.CMJ01.
NOTE: The PROCEDURE FREQ printed page 2.
70 proc print data=cmj01(obs=60);
71 var dupersid panel rn jobsn subtype stillat sickpay--payvactn;
72 run;
NOTE: There were 60 observations read from the data set WORK.CMJ01.
NOTE: The PROCEDURE PRINT printed page 3.
73
74 /* Identify newly-reported 2000 CMJs (panel 5, rn 1,2) */
75 data cmj00; set hc.h40(keep=dupersid panel rn jobsn subtype stillat sickpay--payvactn);
76 if panel=5 & rn in(1,2) & subtype=1 & stillat=-1;
77 run;
NOTE: There were 44935 observations read from the data set HC.H40.
NOTE: The data set WORK.CMJ00 has 5962 observations and 9 variables.
78 proc sort; by dupersid jobsn rn; run;
NOTE: There were 5962 observations read from the data set WORK.CMJ00.
NOTE: The data set WORK.CMJ00 has 5962 observations and 9 variables.
79
80 title4 '2000 (Panel 5 Round 1,2) Records';
81 proc freq; tables
82 sickpay--payvactn/missing;
83 format sickpay--payvactn yn.;
84 run;
NOTE: There were 5962 observations read from the data set WORK.CMJ00.
NOTE: The PROCEDURE FREQ printed page 4.
85 proc print data=cmj00(obs=60);
86 var dupersid panel rn jobsn subtype stillat sickpay--payvactn;
3 The SAS System
87 run;
NOTE: There were 60 observations read from the data set WORK.CMJ00.
NOTE: The PROCEDURE PRINT printed page 5.
88
89 /* Concatenate records from both years */
90 data; set
91 cmj00(in=a)
92 cmj01(in=b); by dupersid jobsn;
93 run;
NOTE: There were 5962 observations read from the data set WORK.CMJ00.
NOTE: There were 4162 observations read from the data set WORK.CMJ01.
NOTE: The data set WORK.DATA2 has 10124 observations and 9 variables.
94
95 title4 'Records from Both Years';
96 proc print data=_last_(obs=60);
97 var dupersid panel rn jobsn subtype stillat sickpay--payvactn;
98 run;
NOTE: There were 60 observations read from the data set WORK.DATA2.
NOTE: The PROCEDURE PRINT printed page 6.
99
100 /* Merge records from both years, rename 2000 variables*/
101 data new; merge
102 cmj01(in=a)
103 cmj00(in=b rename=(sickpay=SICKPAYX paydrvst=PAYDRVSTX payvactn=PAYVACTNX)
104 drop=stillat); /* drop STILLAT here so it doesn't overwrite 2001 value */
105 by dupersid jobsn; if a & b;
106 drop rn;
107 label
108 SICKPAYX ='SICKPAY from First-Reported Round'
109 PAYDRVSTX='PAYDRVST from First-Reported Round'
110 PAYVACTNX='PAYVACTN from First-Reported Round';
111 run;
NOTE: There were 4162 observations read from the data set WORK.CMJ01.
NOTE: There were 5962 observations read from the data set WORK.CMJ00.
NOTE: The data set WORK.NEW has 4161 observations and 11 variables.
112
113 title4 'New Variables';
114 proc print data=_last_(obs=60);
115 var dupersid panel jobsn subtype stillat sickpayx paydrvstx payvactnx;
116 run;
NOTE: There were 60 observations read from the data set WORK.NEW.
NOTE: The PROCEDURE PRINT printed page 7.
117
118 proc freq; tables
119 sickpayx *sickpay
120 paydrvstx*paydrvst
121 payvactnx*payvactn/list missing;
122 format _numeric_ yn.;
123 run;
NOTE: There were 4161 observations read from the data set WORK.NEW.
NOTE: The PROCEDURE FREQ printed page 8.
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
AHRQ MEPS DATA USERS WORKSHOP (LINKING) -- NOV/DEC 2004 1
Link 2000 and 2001 JOBS Files
Sample Listing, All Job Records for Persons Who Have the Same Job in 2000 and 2001
Variables of Interest Are SICKPAY, PAYDRVST, & PAYVACTN
-------------------------------------------------- DUPERSID=80001021 ---------------------------------------------------
Obs YEAR RN JOBSN SUBTYPE STILLAT SICKPAY PAYDRVST PAYVACTN
1 2000 1 1 5 -1 -1 -1 -1
2 2000 2 1 1 -1 2 -1 1
3 2001 3 1 1 1 -1 -1 -1
4 2001 4 1 1 1 -1 -1 -1
5 2001 5 1 1 1 -1 -1 -1
-------------------------------------------------- DUPERSID=80005018 ---------------------------------------------------
Obs YEAR RN JOBSN SUBTYPE STILLAT SICKPAY PAYDRVST PAYVACTN
6 2000 1 1 1 -1 1 1 1
7 2000 2 1 1 1 -1 -1 -1
8 2001 3 1 1 1 -1 -1 -1
9 2001 4 1 1 1 -1 -1 -1
10 2001 5 1 3 2 -1 -1 -1
-------------------------------------------------- DUPERSID=80005025 ---------------------------------------------------
Obs YEAR RN JOBSN SUBTYPE STILLAT SICKPAY PAYDRVST PAYVACTN
11 2000 1 1 1 -1 1 1 1
12 2000 2 1 1 1 -1 -1 -1
13 2001 3 1 1 1 -1 -1 -1
14 2001 4 1 1 1 -1 -1 -1
15 2001 5 1 1 1 -1 -1 -1
-------------------------------------------------- DUPERSID=80006012 ---------------------------------------------------
Obs YEAR RN JOBSN SUBTYPE STILLAT SICKPAY PAYDRVST PAYVACTN
16 2000 1 1 1 -1 1 2 1
17 2000 2 1 1 1 -1 -1 -1
18 2001 3 1 1 1 -1 -1 -1
19 2001 4 1 1 1 -1 -1 -1
20 2001 5 1 1 1 -1 -1 -1
-------------------------------------------------- DUPERSID=80006029 ---------------------------------------------------
Obs YEAR RN JOBSN SUBTYPE STILLAT SICKPAY PAYDRVST PAYVACTN
21 2000 1 1 1 -1 -1 -1 -1
22 2000 2 1 1 1 -1 -1 -1
23 2001 3 1 1 1 -1 -1 -1
24 2001 4 1 1 1 -1 -1 -1
25 2001 5 1 1 1 -1 -1 -1
AHRQ MEPS DATA USERS WORKSHOP (LINKING) -- NOV/DEC 2004 2
Link 2000 and 2001 JOBS Files
2001 Current Main Jobs that Began in 2000
2001 (Panel 5 Round 3) Records
DOES PERSON HAVE PAID SICK LEAVE
Cumulative Cumulative
SICKPAY Frequency Percent Frequency Percent
---------------------------------------------------------------
-1 Inappl 4162 100.00 4162 100.00
IS THERE PAID SICK LEAVE FOR DR'S VISITS
Cumulative Cumulative
PAYDRVST Frequency Percent Frequency Percent
---------------------------------------------------------------
-1 Inappl 4162 100.00 4162 100.00
DOES PERSON GET PAID VACATION
Cumulative Cumulative
PAYVACTN Frequency Percent Frequency Percent
---------------------------------------------------------------
-1 Inappl 4162 100.00 4162 100.00
AHRQ MEPS DATA USERS WORKSHOP (LINKING) -- NOV/DEC 2004 3
Link 2000 and 2001 JOBS Files
2001 Current Main Jobs that Began in 2000
2001 (Panel 5 Round 3) Records
Obs DUPERSID PANEL RN JOBSN SUBTYPE STILLAT SICKPAY PAYDRVST PAYVACTN
1 80001021 5 3 1 1 1 -1 -1 -1
2 80005018 5 3 1 1 1 -1 -1 -1
3 80005025 5 3 1 1 1 -1 -1 -1
4 80006012 5 3 1 1 1 -1 -1 -1
5 80006029 5 3 1 1 1 -1 -1 -1
6 80007015 5 3 1 1 1 -1 -1 -1
7 80009012 5 3 1 1 1 -1 -1 -1
8 80009029 5 3 1 1 1 -1 -1 -1
9 80010013 5 3 1 1 1 -1 -1 -1
10 80010020 5 3 2 1 1 -1 -1 -1
11 80011014 5 3 1 1 1 -1 -1 -1
12 80012024 5 3 1 1 1 -1 -1 -1
13 80013014 5 3 1 1 1 -1 -1 -1
14 80016014 5 3 1 1 1 -1 -1 -1
15 80016021 5 3 1 1 1 -1 -1 -1
16 80016038 5 3 1 1 1 -1 -1 -1
17 80017015 5 3 1 1 1 -1 -1 -1
18 80017022 5 3 1 1 1 -1 -1 -1
19 80018021 5 3 1 1 1 -1 -1 -1
20 80020016 5 3 1 1 1 -1 -1 -1
21 80021014 5 3 1 1 1 -1 -1 -1
22 80021021 5 3 1 1 1 -1 -1 -1
23 80022010 5 3 1 1 1 -1 -1 -1
24 80022027 5 3 1 1 1 -1 -1 -1
25 80024012 5 3 1 1 1 -1 -1 -1
26 80024029 5 3 1 1 1 -1 -1 -1
27 80026018 5 3 1 1 1 -1 -1 -1
28 80026025 5 3 1 1 1 -1 -1 -1
29 80027011 5 3 1 1 1 -1 -1 -1
30 80027028 5 3 1 1 1 -1 -1 -1
31 80028025 5 3 1 1 1 -1 -1 -1
32 80031017 5 3 1 1 1 -1 -1 -1
33 80031024 5 3 1 1 1 -1 -1 -1
34 80031039 5 3 1 1 1 -1 -1 -1
35 80032015 5 3 1 1 1 -1 -1 -1
36 80032022 5 3 2 1 1 -1 -1 -1
37 80034015 5 3 1 1 1 -1 -1 -1
38 80034039 5 3 1 1 1 -1 -1 -1
39 80035028 5 3 2 1 1 -1 -1 -1
40 80036018 5 3 1 1 1 -1 -1 -1
41 80036025 5 3 1 1 1 -1 -1 -1
42 80037031 5 3 1 1 1 -1 -1 -1
43 80038019 5 3 1 1 1 -1 -1 -1
44 80038026 5 3 1 1 1 -1 -1 -1
45 80040017 5 3 1 1 1 -1 -1 -1
46 80041010 5 3 1 1 1 -1 -1 -1
47 80042011 5 3 1 1 1 -1 -1 -1
48 80043014 5 3 1 1 1 -1 -1 -1
49 80043021 5 3 1 1 1 -1 -1 -1
50 80048016 5 3 2 1 1 -1 -1 -1
51 80049025 5 3 1 1 1 -1 -1 -1
52 80055018 5 3 1 1 1 -1 -1 -1
53 80057011 5 3 1 1 1 -1 -1 -1
54 80061037 5 3 1 1 1 -1 -1 -1
55 80062024 5 3 1 1 1 -1 -1 -1
56 80064011 5 3 1 1 1 -1 -1 -1
57 80064028 5 3 1 1 1 -1 -1 -1
58 80064035 5 3 1 1 1 -1 -1 -1
59 80064065 5 3 2 1 1 -1 -1 -1
60 80064078 5 3 1 1 1 -1 -1 -1
AHRQ MEPS DATA USERS WORKSHOP (LINKING) -- NOV/DEC 2004 4
Link 2000 and 2001 JOBS Files
2001 Current Main Jobs that Began in 2000
2000 (Panel 5 Round 1,2) Records
DOES PERSON HAVE PAID SICK LEAVE
Cumulative Cumulative
SICKPAY Frequency Percent Frequency Percent
---------------------------------------------------------------
-9 Not Asc 13 0.22 13 0.22
-8 DK 145 2.43 158 2.65
-7 Refised 16 0.27 174 2.92
-1 Inappl 660 11.07 834 13.99
1 Yes 2880 48.31 3714 62.29
2 No 2248 37.71 5962 100.00
IS THERE PAID SICK LEAVE FOR DR'S VISITS
Cumulative Cumulative
PAYDRVST Frequency Percent Frequency Percent
---------------------------------------------------------------
-9 Not Asc 1 0.02 1 0.02
-8 DK 80 1.34 81 1.36
-1 Inappl 3082 51.69 3163 53.05
1 Yes 2471 41.45 5634 94.50
2 No 328 5.50 5962 100.00
DOES PERSON GET PAID VACATION
Cumulative Cumulative
PAYVACTN Frequency Percent Frequency Percent
---------------------------------------------------------------
-9 Not Asc 13 0.22 13 0.22
-8 DK 118 1.98 131 2.20
-7 Refised 17 0.29 148 2.48
-1 Inappl 660 11.07 808 13.55
1 Yes 3400 57.03 4208 70.58
2 No 1754 29.42 5962 100.00
AHRQ MEPS DATA USERS WORKSHOP (LINKING) -- NOV/DEC 2004 5
Link 2000 and 2001 JOBS Files
2001 Current Main Jobs that Began in 2000
2000 (Panel 5 Round 1,2) Records
Obs DUPERSID PANEL RN JOBSN SUBTYPE STILLAT SICKPAY PAYDRVST PAYVACTN
1 80001021 5 2 1 1 -1 2 -1 1
2 80005018 5 1 1 1 -1 1 1 1
3 80005025 5 1 1 1 -1 1 1 1
4 80005032 5 2 1 1 -1 2 -1 2
5 80006012 5 1 1 1 -1 1 2 1
6 80006029 5 1 1 1 -1 -1 -1 -1
7 80007015 5 1 1 1 -1 1 1 1
8 80009012 5 1 1 1 -1 1 2 2
9 80009029 5 1 1 1 -1 2 -1 2
10 80010013 5 1 1 1