Medical Expenditure Panel Survey HC-100: Appendix 1

Font Size:

MEPS HC-108: Appendix 1
<< previous page

Table of Contents

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

The SAS System 16:40 Friday, March 6, 2009

NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) 9.1 (TS1M3)
NOTE: SAS 9.1.3 Service Pack 4
NOTE: SAS initialization used: real time 3.56 seconds cpu time 0.45 seconds
NOTE: AUTOEXEC processing beginning; file is C:\Program Files\SAS\SAS 9.1\autoexec.sas.
NOTE: AUTOEXEC processing completed.

1 APP07.sas
2
3 OPTIONS LS=132 PS=79;
4
5
6 Program Name: SAMPLE.SAS
7
8 Description: This job provides an example of how to get job info
9 from Round 1 or Round 2 in the FY2006 JOBS file when
10 a Round 3 current main job in the FY2007 JOBS file
11 is a continuation job.
12 13 This example creates a dataset of Round 3 continuation
14 JOBS records with a SICKPAYX variable copied from the
15 Round 1 or Round 2 newly reported job.
16
17
18 libname jobs06 "c:\mydata\jobs06";
NOTE: Libref JOBS06 was successfully assigned as follows:
Engine: V9
Physical Name: c:\mydata\jobs06
19 libname jobs07 " c:\mydata\jobs07";
NOTE: Libref JOBS07 was successfully assigned as follows:
Engine: V9
Physical Name: c:\mydata\jobs07
20
21 Select continuing Panel 11, Round 3 Current Main JOBS
22 (SUBTYPE=1, STILLAT=1) from the FY 2007 JOBS file and
23 print selected variables from the first 20 observations
24
25 data j07r3;
26 set jobs07.jobs07;
27 if panel=11
28 and rn=3
29 and subtype=1
30 and stillat=1
31 and sickpay=-1;
32 run;

NOTE: There were 52306 observations read from the data set JOBS07.JOBS07.
NOTE: The data set WORK.J07R3 has 6221 observations and 87 variables.
NOTE: DATA statement used (Total process time):
real time 3.17 seconds
cpu time 0.11 seconds

33
34 proc print data=j07r3 (obs=20);
35 title 'Print Sample of Continuation Round 3 Records';
36 var dupersid panel rn jobsn subtype stillat sickpay;
37 run;

NOTE: There were 20 observations read from the data set WORK.J07R3.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.35 seconds

2 The SAS System 16:40 Friday, March 6, 2009
cpu time 0.00 seconds

38
39
40 Select newly reported Panel 11 Current Main JOBS records from
41 the FY 2006 JOBS file and print selected variables from the
42 first 20 observations.
43
44 data j0612;
45 set jobs06.jobs06;
46 if subtype=1
47 and stillat=-1
48 and panel=11
49 and rn in (1,2);
50 run;

NOTE: There were 57379 observations read from the data set JOBS06.JOBS06.
NOTE: The data set WORK.J0612 has 8850 observations and 87 variables.
NOTE: DATA statement used (Total process time):
real time 3.39 seconds
cpu time 0.10 seconds

51
52 proc print data=j0612 (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.J0612.
NOTE: The PROCEDURE PRINT printed page 2.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

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

NOTE: There were 8850 observations read from the data set WORK.J0612.
NOTE: The PROCEDURE FREQ printed page 3.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.20 seconds
cpu time 0.00 seconds

61
62 63 Prepare FY06 and FY07 data for merge
64
65 proc sort data=j07r3;
66 by dupersid jobsn;
67 run;

NOTE: There were 6221 observations read from the data set WORK.J07R3.
NOTE: SAS sort was used.
NOTE: The data set WORK.J07R3 has 6221 observations and 87 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.09 seconds
cpu time 0.03 seconds

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

NOTE: There were 8850 observations read from the data set WORK.J0612.
NOTE: SAS sort was used.
NOTE: The data set WORK.J0612 has 8850 observations and 87 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.04 seconds
cpu time 0.03 seconds

3 The SAS System 16:40 Friday, March 6, 2009

72
73 74 Create a dataset (J07R3F) 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 j07r3f;
80 merge j07r3 (in=a) j0612 (in=b keep = dupersid jobsn sickpay
81 rename=(sickpay=SICKPAYX));
82 by dupersid jobsn;
83 if a and b;
84 run;

NOTE: There were 6221 observations read from the data set WORK.J07R3.
NOTE: There were 8850 observations read from the data set WORK.J0612.
NOTE: The data set WORK.J07R3F has 6218 observations and 88 variables.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.03 seconds

85
86 proc freq data=j07r3f;
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 6218 observations read from the data set WORK.J07R3F.
NOTE: The PROCEDURE FREQ printed page 4.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.04 seconds
cpu time 0.00 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 11.29 seconds
cpu time 0.78 seconds

Print Sample of Continuation Round 3 Records
16:40 Friday, March 6, 2009
Page 1

Obs	DUPERSID	PANEL	RN	JOBSN	SUBTYPE	STILLAT	SICKPAY
1	60001012	10	3	1	1	1	-1
2	60001029	10	3	1	1	1	-1
3	60007011	10	3	1	1	1	-1
4	60007035	10	3	1	1	1	-1
5	60008019	10	3	1	1	1	-1
6	60008026	10	3	1	1	1	-1
7	60008033	10	3	1	1	1	-1
8	60008040	10	3	1	1	1	-1
9	60011024	10	3	1	1	1	-1
10	60013021	10	3	1	1	1	-1
11	60014019	10	3	2	1	1	-1
12	60015014	10	3	1	1	1	-1
13	60015021	10	3	1	1	1	-1
14	60016013	10	3	1	1	1	-1
15	60021010	10	3	1	1	1	-1
16	60022016	10	3	1	1	1	-1
17	60027013	10	3	1	1	1	-1
18	60027020	10	3	1	1	1	-1
19	60028018	10	3	1	1	1	-1
20	60028025	10	3	1	1	1	-1

Print Sample of Newly Reported Round 1 and Round 2 Records 16:40 Friday, March 6, 2009 Page 2

Obs	DUPERSI	PANEL	RN	JOBSN	SUBTYPE	STILLAT	SICKPAY
1	60001012	11	1	1	1	-1	2
2	60001029	11	1	1	1	-1	2
3	60001034	11	1	1	1	-1	1
4	60001034	11	2	2	1	-1	2
5	60007011	11	1	1	1	-1	2
6	60007035	11	1	1	1	-1	1
7	60008019	11	1	1	1	-1	2
8	60008026	11	1	1	1	-1	-1
9	60008033	11	1	1	1	-1	2
10	60008040	11	1	1	1	-1	-1
11	60011024	11	1	1	1	-1	-1
12	60013014	11	1	1	1	-1	1
13	60013021	11	1	1	1	-1	1
14	60014019	11	1	1	1	-1	2
15	60014019	11	2	2	1	-1	1
16	60015014	11	1	1	1	-1	1
17	60015021	11	1	1	1	-1	2
18	60016013	11	1	1	1	-1	1
19	60021010	11	1	1	1	-1	1
20	60022016	11	1	1	1	-1	-1

Sickpay Value of FY2006 Round 1 and Round 2 Newly Reported CMJs
16:40 Friday, March 6, 2009 Page 3

The FREQ Procedure

DOES PERSON HAVE PAID SICK LEAVE

SICKPAY	Frequency	Percent	Cumulative Frequency	Cumulative Percent
-9	19	0.21	19	0.21
-8	246	2.78	265	2.99
-7	4	0.05	269	3.04
-1	1005	11.36	1274	14.40
1	4018	45.40	5292	59.80
2	3558	40.20	8850	100.00

Diagnostic Post-Merge - Sickpay * Sickpayx 16:40 Friday, March 6, 2009 Page 4

Round 3 Continuation Current Main Jobs Only

The FREQ Procedure

SICKPAY	SICKPAYX	Frequency	Percent	Cumulative Frequency	Cumulative Percent
-1	-9	11	0.18	11	0.18
-1	-8	151	2.43	162	2.61
-1	-7	4	0.06	166	2.67
-1	-1	799	12.85	965	15.52
-1	1	3159	50.80	4124	66.32
-1	2	2094	33.68	6218	100.00

<< previous page