Medical Expenditure Panel Survey HC-100: Appendix 1

Font Size:

MEPS HC-100: Appendix 1
<< previous page

Table of Contents

1. The SAS System Log
2. The SAS System List

Page 2. The SAS System 13:55 Thursday, March 6, 2008
cpu time 0.09 seconds
38
39
40 /* Select newly reported Panel 10 Current Main JOBS records from */
41 /* the FY 2005 JOBS file and print selected variables from the */
42 /* first 20 observations. */
43
44 data j0512;
45 set jobs05.jobs05;
46 if subtype=1
47 and stillat=-1
48 and panel=10
49 and rn in (1,2);
50 run;

NOTE: There were 56865 observations read from the data set JOBS05.JOBS05.
NOTE: The data set WORK.J0512 has 8416 observations and 87 variables.
NOTE: DATA statement used (Total process time):

real time 2.53 seconds
cpu time 0.25 seconds

51
52 proc print data=j0512 (obs=20);
53 title 'Print Sample of Newly Reported Round 1 and Round 2 Records';
54 var dupersid panel rn jobsn subtype stillat sickpay;
55 run;

NOTE: There were 20 observations read from the data set WORK.J0512.
NOTE: The PROCEDURE PRINT printed page 2.
NOTE: PROCEDURE PRINT used (Total process time):

real time 0.01 seconds
cpu time 0.00 seconds

56
57 proc freq data=j0512;
58 tables sickpay/list missing;
59 title 'Sickpay Value of FY2005 Round 1 and Round 2 Newly Reported CMJs';
60 run;

NOTE: There were 8416 observations read from the data set WORK.J0512.
NOTE: The PROCEDURE FREQ printed page 3.
NOTE: PROCEDURE FREQ used (Total process time):

real time 0.17 seconds
cpu time 0.04 seconds

61
62
63 /* Prepare FY05 and FY06 data for merge */
64
65 proc sort data=j06r3;
66 by dupersid jobsn;
67 run;

NOTE: There were 5758 observations read from the data set WORK.J06R3.
NOTE: The data set WORK.J06R3 has 5758 observations and 87 variables.
NOTE: PROCEDURE SORT used (Total process time):

real time 0.20 seconds
cpu time 0.12 seconds

68
69 proc sort data=j0512;
70 by dupersid jobsn;
71 run;

NOTE: There were 8416 observations read from the data set WORK.J0512.
NOTE: The data set WORK.J0512 has 8416 observations and 87 variables.
NOTE: PROCEDURE SORT used (Total process time):

real time 0.18 seconds
cpu time 0.17 seconds

Page 3 The SAS System 13:55 Thursday, March 6, 2008
72
73
74 /* Create a dataset (J06R3F) that includes all variables */
75 /* for the continuation Round 3 Current Main JOBS and create */
76 /* the new variable SICKPAYX by copying SICKPAY from the */
77 /* corresponding Round 1 or Round 2 newly reported job record. */
78
79 data j06r3f;
80 merge j06r3 (in=a) j0512 (in=b keep = dupersid jobsn sickpay
81 rename=(sickpay=SICKPAYX));
82 by dupersid jobsn;
83 if a and b;
84 run;

NOTE: There were 5758 observations read from the data set WORK.J06R3.
NOTE: There were 8416 observations read from the data set WORK.J0512.
NOTE: The data set WORK.J06R3F has 5755 observations and 88 variables.
NOTE: DATA statement used (Total process time):

real time 0.20 seconds
cpu time 0.18 seconds

85
86 proc freq data=j06r3f;
87 tables sickpay*sickpayx/list missing;
88 title1 'Diagnostic Post-Merge - Sickpay * Sickpayx';
89 title2 'Round 3 Continuation Current Main Jobs Only';
90 run;

NOTE: There were 5755 observations read from the data set WORK.J06R3F.
NOTE: The PROCEDURE FREQ printed page 4.
NOTE: PROCEDURE FREQ used (Total process time):

real time 0.06 seconds
cpu time 0.03 seconds

91
92 OPTIONS LS=132 PS=79;
93
94
95

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:

real time 12.75 seconds
cpu time 2.06 seconds

Print Sample of Continuation Round 3 Records
13:55 Thursday, March 6, 2008
Page 1

Obs	DUPERSID	PANEL	RN	JOBSN	SUBTYPE	STILLAT	SICKPAY
1	30002019	10	3	1	1	1	-1
2	30004010	10	3	1	1	1	-1
3	30004027	10	3	1	1	1	-1
4	30006012	10	3	2	1	1	-1
5	30006029	10	3	1	1	1	-1
6	30006036	10	3	1	1	1	-1
7	30010010	10	3	1	1	1	-1
8	30012016	10	3	1	1	1	-1
9	30013012	10	3	1	1	1	-1
10	30014012	10	3	1	1	1	-1
11	30014029	10	3	1	1	1	-1
12	30015017	10	3	1	1	1	-1
13	30015024	10	3	1	1	1	-1
14	30016011	10	3	1	1	1	-1
15	30016027	10	3	1	1	1	-1
16	30017016	10	3	1	1	1	-1
17	30018018	10	3	1	1	1	-1
18	30018025	10	3	1	1	1	-1
19	30019011	10	3	1	1	1	-1
20	30021018	10	3	1	1	1	-1

Print Sample of Newly Reported Round 1 and Round 2 Records 13:55 Thursday, March 6, 2008 Page 2

Obs	DUPERSI	PANEL	RN	JOBSN	SUBTYPE	STILLAT	SICKPAY
1	30002019	10	1	1	1	-1	2
2	30004010	10	1	1	1	-1	1
3	30004027	10	1	1	1	-1	1
4	30005015	10	2	1	1	-1	2
5	30006012	10	1	1	1	-1	1
6	30006012	10	2	2	1	-1	1
7	30006029	10	1	1	1	-1	1
8	30006036	10	1	1	1	-1	1
9	30008012	10	1	1	1	-1	2
10	30010010	10	1	1	1	-1	2
11	30012016	10	1	1	1	-1	1
12	30013012	10	1	1	1	-1	1
13	30014012	10	1	1	1	-1	2
14	30014029	10	1	1	1	-1	2
15	30015017	10	1	1	1	-1	1
16	30015024	10	1	1	1	-1	2
17	30016011	10	1	1	1	-1	-1
18	30016027	10	1	1	1	-1	-1
19	30017016	10	1	1	1	-1	-1
20	30018018	10	1	1	1	-1	1

Sickpay Value of FY2005 Round 1 and Round 2 Newly Reported CMJs Page 3
13:55 Thursday, March 6, 2008

The FREQ Procedure

DOES PERSON HAVE PAID SICK LEAVE

SICKPAY	Frequency	Percent	Cumulative Frequency	Cumulative Percent
-9	15	0.18	15	0.18
-8	247	2.93	262	3.11
-7	9	0.11	271	3.22
-1	958	11.38	1229	14.6
1	3750	44.56	4979	59.16
2	3437	40.84	8416	100

Diagnostic Post-Merge - Sickpay * Sickpayx 13:55 Thursday, March 6, 2008 Page 4

Round 3 Continuation Current Main Jobs Only

The FREQ Procedure

SICKPAY	Frequency	Percent	Cumulative Frequency	Cumulative Percent
-9	15	0.18	15	0.18
-8	247	2.93	262	3.11
-7	9	0.11	271	3.22
-1	958	11.38	1229	14.6
1	3750	44.56	4979	59.16
2	3437	40.84	8416	100

<< previous page