1. The SAS System Log
2. The SAS System List
Page 1 The SAS System Log 14:00 Tuesday, December 16, 2008
NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS1M0)
Licensed to SOCIAL & SCIENTIFIC SYSTEMS INC/AHRQ/NIH/HRSA, Site 0070021279.
NOTE: This session is executing on the XP_PRO platform.
NOTE: SAS initialization used:
real time 0:01.59
user cpu time 0:00.10
system cpu time 0:00.70
Memory 2554k
OS Memory 3292k
Timestamp 12/16/2008 2:00:29 PM
NOTE: AUTOEXEC processing beginning; file is C:\PROGRA~1\SAS92\SASFOU~1\9.2\autoexec.sas.
NOTE: AUTOEXEC processing completed.
1 /**********************************************************************\
2
3 PROGRAM: C:\MEPS\PROG\M3.SAS
4
5 DESCRIPTION: THIS EXAMPLE SHOWS THE USE OF ID VARIABLES ON DIFFERENT
6 MEPS PUBLIC-USE FILES (PUFs) AND HOW TO USE THESE ID
7 VARIABLES TO MERGE MEPS FILES.
8
9 THIS EXAMPLE SHOWS PRINTS OF PERSON-LEVEL AND CONDITION-
10 LEVEL FILES TO SHOW THE USE OF THE ID VARIABLES.
11
12 DUPERSID (HC-097) IS A PERSON-LEVEL IDENTIFIER.
13 CONDIDX (HC-096) IS A PERSON-CONDITION-LEVEL IDENTIFIER.
14
15 NOTE THAT THE MERGES USING DUPERSID ALSO USE PANEL, THAT IS,
16 MERGE BY DUPERSID PANEL. WHILE NOT NECESSARY WHEN PROCESSING
17 ONLY ONE YEAR OF MEPS DATA, AS IN THIS EXAMPLE, IT IS GOOD
18 PROGRAMMING PRACTICE TO ADD PANEL TO MERGES BECAUSE
19 WHEN PROCESSING DATA ACROSS SEVERAL MEPS YEARS, DUPERSID (AND
20 OTHER IDS) MAY NOT BE UNIQUE. SPECIFICALLY, STARTING WITH MEPS 2004,
21 PANEL 9, IDS DUPLICATE EARLIER YEARS.
22
23 INPUT FILE: (1) C:\MEPS\DATA\H97.SAS7BDAT (2005 FULL-YEAR DATA FILE)
24 (2) C:\MEPS\DATA\H96.SAS7BDAT (2005 CONDITIONS FILE)
25
26 \**********************************************************************/
27
28 FOOTNOTE 'PROGRAM: C:\MEPS\PROG\M3.SAS';
29
30 LIBNAME CDATA 'C:\MEPS\DATA';
NOTE: Libref CDATA was successfully assigned as follows:
Engine: V9
Physical Name: C:\MEPS\DATA
31
32 TITLE1 'AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008';
33 TITLE2 'ILLUSTRATING THE USE OF ID VARIABLES (DUPERSID, CONDIDX)';
34
35 PROC FORMAT;
36 VALUE YESNO
37 -9 = '-9 NOT ASCERTAINED'
38 -1 = '-1 INAPPLICABLE'
39 1 = '1 YES'
40 2 = '2 NO';
NOTE: Format YESNO has been output.
41 VALUE SEXF
42 1 = '1 MALE'
43 2 = '2 FEMALE';
NOTE: Format SEXF has been output.
44 RUN;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0:00.11
user cpu time 0:00.00
system cpu time 0:00.06
Memory 145k
OS Memory 3548k
Page 2 The SAS System 14:00 Tuesday, December 16, 2008
Timestamp 12/16/2008 2:00:30 PM
45
46 /***** GET DUPERSID AND OTHER VARIABLES FROM HC-097 *****/
47
48 * READ 2005 CONSOLIDATED FULL YEAR FILE;
49 PROC SORT DATA= CDATA.H97 (KEEP= DUID PID DUPERSID PANEL AGE05X SEX
PERWT05F
50 VARSTR VARPSU)
51 OUT= FY2005;
52 BY DUPERSID PANEL;
53 RUN;
NOTE: There were 33961 observations read from the data set CDATA.H97.
NOTE: The data set WORK.FY2005 has 33961 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0:01.91
user cpu time 0:00.01
system cpu time 0:00.21
Memory 3065k
OS Memory 7132k
Timestamp 12/16/2008 2:00:32 PM
54
55 TITLE3 'PRINT OF SELECTED HC-097 (2005 FULL-YEAR FILE) RECORDS TO SHOW
DUPERSID';
56
57 PROC PRINT DATA= FY2005 (FIRSTOBS=40 OBS= 90);
58 VAR DUID PID DUPERSID PANEL AGE05X SEX ;
59 FORMAT SEX SEXF. ;
60 RUN;
NOTE: There were 51 observations read from the data set WORK.FY2005.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0:00.07
user cpu time 0:00.01
system cpu time 0:00.04
Memory 1061k
OS Memory 6364k
Timestamp 12/16/2008 2:00:32 PM
61
62 /***** GET DUPERSID, CONDIDX AND OTHER VARIABLES FROM HC-096 *****/
63
64 *READ 2005 CONDITIONS FILE;
65 PROC SORT DATA= CDATA.H96 (KEEP= DUPERSID PANEL CONDN CONDIDX INJURY
ICD9CODX)
66 OUT= COND2005;
67 BY DUPERSID PANEL CONDIDX;
68 RUN;
NOTE: There were 104855 observations read from the data set CDATA.H96.
NOTE: The data set WORK.COND2005 has 104855 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0:00.60
user cpu time 0:00.01
system cpu time 0:00.12
Memory 12325k
OS Memory 18704k
Timestamp 12/16/2008 2:00:32 PM
69
70 TITLE3 'PRINT OF SELECTED HC-096 (2005 CONDITIONS FILE) RECORDS TO SHOW';
71 TITLE4 'DUPERSID AND CONDIDX';
72
73 PROC PRINT DATA= COND2005 (FIRSTOBS=140 OBS=190);
74 VAR DUPERSID PANEL CONDN CONDIDX INJURY ICD9CODX;
75 FORMAT INJURY YESNO. ;
76 RUN;
NOTE: There were 51 observations read from the data set WORK.COND2005.
NOTE: The PROCEDURE PRINT printed page 2.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0:00.00
user cpu time 0:00.00
Page 3 The SAS System 14:00 Tuesday, December 16, 2008
system cpu time 0:00.00
Memory 162k
OS Memory 7132k
Timestamp 12/16/2008 2:00:32 PM
77
78 /***** MERGE FILES TO CONNECT PERSON INFO WITH CONDITION INFO. *****/
79 /***** THE MERGE MATCHES RECORDS USING THE DUPERSID VARIABLE *****/
80
81 DATA CONDINFO;
82 MERGE FY2005 COND2005;
83 BY DUPERSID PANEL;
84 RUN;
NOTE: There were 33961 observations read from the data set WORK.FY2005.
NOTE: There were 104855 observations read from the data set WORK.COND2005.
NOTE: The data set WORK.CONDINFO has 111962 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 0:00.11
user cpu time 0:00.06
system cpu time 0:00.03
Memory 386k
OS Memory 7132k
Timestamp 12/16/2008 2:00:32 PM
85
86 TITLE3 'PRINT OF SELECTED RECORDS FROM MERGED, CONDITION-LEVEL, FILE';
87
88 PROC PRINT DATA= CONDINFO (FIRSTOBS=140 OBS=190);
89 VAR DUPERSID PANEL CONDIDX AGE05X SEX INJURY ICD9CODX;
90 FORMAT SEX SEXF. INJURY YESNO. ;
91 RUN;
NOTE: There were 51 observations read from the data set WORK.CONDINFO.
NOTE: The PROCEDURE PRINT printed page 3.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0:00.00
user cpu time 0:00.00
system cpu time 0:00.00
Memory 222k
OS Memory 7132k
Timestamp 12/16/2008 2:00:32 PM
92
93 /***** MERGE FILES BUT NOW ONLY KEEP MATCHING RECORDS *****/
94
95 DATA CONDINFO_B;
96 MERGE FY2005 (IN= A) COND2005 (IN= B);
97 BY DUPERSID PANEL;
98 IF A AND B;
99 RUN;
NOTE: There were 33961 observations read from the data set WORK.FY2005.
NOTE: There were 104855 observations read from the data set WORK.COND2005.
NOTE: The data set WORK.CONDINFO_B has 104855 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 0:00.07
user cpu time 0:00.04
system cpu time 0:00.03
Memory 367k
OS Memory 7132k
Timestamp 12/16/2008 2:00:33 PM
100
101 TITLE3 'PRINT OF SELECTED RECORDS FROM MERGED, CONDITION-LEVEL, FILE';
102 TITLE4 'WHERE ONLY MATCHED RECORDS WERE KEPT';
103
104 PROC PRINT DATA= CONDINFO_B (FIRSTOBS=140 OBS=190);
105 VAR DUPERSID PANEL CONDIDX AGE05X SEX INJURY ICD9CODX;
106 FORMAT SEX SEXF. INJURY YESNO. ;
107 RUN;
NOTE: There were 51 observations read from the data set WORK.CONDINFO_B.
Page 4 The SAS System 14:00 Tuesday, December 16, 2008
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0:00.01
user cpu time 0:00.00
system cpu time 0:00.01
Memory 222k
OS Memory 7132k
Timestamp 12/16/2008 2:00:33 PM
108
109
110
111
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 0:04.95
user cpu time 0:00.29
system cpu time 0:01.37
Memory 16136k
OS Memory 18704k
Timestamp 12/16/2008 2:00:33 PM
AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008 14:00 Tuesday, December 16, 2008 Page 1
ILLUSTRATING THE USE OF ID VARIABLES (DUPERSID, CONDIDX)
Obs | DUID | PID | DUPERSID | PANEL | AGE05X | SEX |
---|---|---|---|---|---|---|
40 | 30021 | 18 | 30021018 | 10 | 61 | 2 FEMALE |
41 | 30022 | 19 | 30022019 | 71 | 2 FEMALE | |
42 | 30023 | 16 | 30023016 | 10 | 84 | 1 MALE |
43 | 30023 | 23 | 30023023 | 10 | 22 | 1 MALE |
44 | 30023 | 30 | 30023030 | 10 | 21 | 2 FEMALE |
45 | 30023 | 41 | 30023041 | 10 | 56 | 2 FEMALE |
46 | 30023 | 58 | 30023058 | 10 | 0 | 2 FEMALE |
47 | 30024 | 13 | 30024013 | 10 | 35 | 2 FEMALE |
48 | 30024 | 20 | 30024020 | 10 | 55 | 1 MALE |
49 | 30024 | 37 | 30024037 | 10 | 56 | 2 FEMALE |
50 | 30024 | 44 | 30024044 | 10 | 35 | 1 MALE |
51 | 30024 | 50 | 30024050 | 10 | 32 | 1 MALE |
52 | 30025 | 11 | 30025011 | 10 | 0 | 1 MALE |
53 | 30025 | 14 | 30025014 | 10 | 57 | 1 MALE |
54 | 30025 | 21 | 30025021 | 10 | 40 | 2 FEMALE |
55 | 30025 | 38 | 30025038 | 10 | 22 | 2 FEMALE |
56 | 30025 | 45 | 30025045 | 10 | 16 | 1 MALE |
57 | 30025 | 51 | 30025051 | 10 | 24 | 1 MALE |
58 | 30026 | 11 | 30026011 | 10 | 37 | 1 MALE |
59 | 30026 | 21 | 30026021 | 10 | 0 | 1 MALE |
60 | 30026 | 26 | 30026026 | 10 | 32 | 2 FEMALE |
61 | 30026 | 34 | 30026034 | 10 | 12 | 1 MALE |
62 | 30026 | 42 | 30026042 | 10 | 5 | 2 FEMALE |
63 | 30027 | 13 | 30027013 | 10 | 25 | 2 FEMALE |
64 | 30027 | 20 | 30027020 | 10 | 25 | 1 MALE |
65 | 30027 | 37 | 30027037 | 10 | 2 | 1 MALE |
66 | 30028 | 15 | 30028015 | 10 | 60 | 2 FEMALE |
67 | 30028 | 22 | 30028022 | 10 | 62 | 1 MALE |
68 | 30028 | 39 | 30028039 | 10 | 28 | 1 MALE |
69 | 30028 | 46 | 30028046 | 10 | 24 | 1 MALE |
70 | 30030 | 19 | 30030019 | 10 | 35 | 2 FEMALE |
71 | 30031 | 11 | 30031011 | 10 | 52 | 1 MALE |
72 | 30031 | 12 | 30031012 | 10 | 52 | 2 FEMALE |
73 | 30032 | 17 | 30032017 | 10 | 48 | 1 MALE |
74 | 30032 | 24 | 30032024 | 10 | 19 | 1 MALE |
75 | 30032 | 31 | 30032031 | 10 | 17 | 2 FEMALE |
76 | 30034 | 11 | 30034011 | 10 | 28 | 1 MALE |
77 | 30034 | 19 | 30034019 | 10 | 34 | 1 MALE |
78 | 30034 | 21 | 30034021 | 10 | 23 | 1 MALE |
79 | 30034 | 26 | 30034026 | 10 | 25 | 2 FEMALE |
80 | 30034 | 34 | 30034034 | 10 | 1 | 2 FEMALE |
81 | 30036 | 18 | 30036018 | 10 | -1 | 2 FEMALE |
82 | 30036 | 25 | 30036025 | 10 | 66 | 1 MALE |
83 | 30037 | 17 | 30037017 | 10 | 60 | 1 MALE |
84 | 30037 | 24 | 30037024 | 10 | 55 | 2 FEMALE |
85 | 30038 | 10 | 30038010 | 10 | 70 | 1 MALE |
86 | 30038 | 27 | 30038027 | 10 | 82 | 2 FEMALE |
87 | 30039 | 13 | 30039013 | 10 | 36 | 2 FEMALE |
88 | 30039 | 20 | 30039020 | 10 | 20 | 2 FEMALE |
89 | 30039 | 37 | 30039037 | 10 | 18 | 1 MALE |
90 | 30039 | 44 | 30039044 | 10 | 14 | 1 MALE |
PROGRAM: C:\MEPS\PROG\M3.SAS
AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008 14:00 Tuesday, December 16, 2008 Page 2
ILLUSTRATING THE USE OF ID VARIABLES (DUPERSID, CONDIDX)
Obs | DUPERSID | PANEL | CONDN | CONDIDX | INJURY | ICD9CODX |
---|---|---|---|---|---|---|
140 | 30021018 | 10 | 84 | 300210180084 | 2 NO | 473 |
141 | 30022019 | 10 | 16 | 300220190016 | 2 NO | 401 |
142 | 30022019 | 10 | 22 | 300220190022 | 2 NO | 780 |
143 | 30022019 | 10 | 38 | 300220190038 | 2 NO | 787 |
144 | 30022019 | 10 | 44 | 300220190044 | 1 YES | 719 |
145 | 30022019 | 10 | 50 | 300220190050 | 2 NO | 304 |
146 | 30022019 | 10 | 66 | 300220190066 | 2 NO | 530 |
147 | 30022019 | 10 | 72 | 300220190072 | 1 YES | 920 |
148 | 30022019 | 10 | 88 | 300220190088 | 2 NO | 300 |
149 | 30022019 | 10 | 94 | 300220190094 | 1 YES | 827 |
150 | 30022019 | 10 | 107 | 300220190107 | 1 YES | 920 |
151 | 30023023 | 10 | 18 | 300230230018 | 2 NO | 462 |
152 | 30023030 | 10 | 17 | 300230300017 | 2 NO | V22 |
153 | 30023041 | 10 | 12 | 300230410012 | 2 NO | 436 |
154 | 30023041 | 10 | 28 | 300230410028 | 2 NO | 272 |
155 | 30023041 | 10 | 34 | 300230410034 | 2 NO | 401 |
156 | 30023041 | 10 | 40 | 300230410040 | 2 NO | 250 |
157 | 30023058 | 10 | 11 | 300230580011 | 2 NO | 382 |
158 | 30023058 | 10 | 27 | 300230580027 | 2 NO | 691 |
159 | 30023058 | 10 | 33 | 300230580033 | 2 NO | 79 |
160 | 30024020 | 10 | 16 | 300240200016 | 2 NO | 724 |
161 | 30025038 | 10 | 10 | 300250380010 | 2 NO | V22 |
162 | 30026011 | 10 | 13 | 300260110013 | 2 NO | 487 |
163 | 30026026 | 10 | 14 | 300260260014 | 2 NO | V22 |
164 | 30026034 | 10 | 12 | 300260340012 | 2 NO | 487 |
165 | 30026042 | 10 | 10 | 300260420010 | 2 NO | 460 |
166 | 30027013 | 10 | 10 | 300270130010 | 2 NO | V22 |
167 | 30027037 | 10 | 18 | 300270370018 | 2 NO | 478 |
168 | 30028015 | 10 | 14 | 300280150014 | 2 NO | 401 |
169 | 30028015 | 10 | 20 | 300280150020 | 2 NO | -1 |
170 | 30028015 | 10 | 36 | 300280150036 | 2 NO | 413 |
171 | 30028015 | 10 | 42 | 300280150042 | 2 NO | 358 |
172 | 30028015 | 10 | 58 | 300280150058 | 2 NO | 300 |
173 | 30028015 | 10 | 64 | 300280150064 | 2 NO | 246 |
174 | 30028015 | 10 | 70 | 300280150070 | 2 NO | 79 |
175 | 30028015 | 10 | 86 | 300280150086 | 2 NO | 79 |
176 | 30028015 | 10 | 92 | 300280150092 | 2 NO | 521 |
177 | 30028015 | 10 | 105 | 300280150105 | 2 NO | 355 |
178 | 30028015 | 10 | 111 | 300280150111 | 2 NO | 599 |
179 | 30028015 | 10 | 127 | 300280150127 | 2 NO | 473 |
180 | 30028015 | 10 | 133 | 300280150133 | 2 NO | 536 |
181 | 30028015 | 10 | 149 | 300280150149 | 2 NO | V68 |
182 | 30028015 | 10 | 155 | 300280150155 | 2 NO | 272 |
183 | 30028015 | 10 | 161 | 300280150161 | 2 NO | 522 |
184 | 30028015 | 10 | 177 | 300280150177 | 2 NO | 530 |
185 | 30028015 | 10 | 183 | 300280150183 | 2 NO | V41 |
186 | 30028015 | 10 | 199 | 300280150199 | 2 NO | 8 |
187 | 30028022 | 10 | 13 | 300280220013 | 2 NO | 311 |
188 | 30028022 | 10 | 29 | 300280220029 | 2 NO | 401 |
189 | 30028022 | 10 | 35 | 300280220035 | 2 NO | 724 |
190 | 30028022 | 10 | 41 | 300280220041 | 2 NO | 272 |
PROGRAM: C:\MEPS\PROG\M3.SAS
AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008 14:00 Tuesday, December 16, 2008 Page 3
ILLUSTRATING THE USE OF ID VARIABLES (DUPERSID, CONDIDX)
Obs | DUPERSID | PANEL | CONDIDX | AGE05X | SEX | INJURY | ICD9CODX |
---|---|---|---|---|---|---|---|
140 | 30021018 | 10 | 300210180012 | 61 | 2 FEMALE | 2 NO | 719 |
141 | 30021018 | 10 | 300210180028 | 61 | 2 FEMALE | 2 NO | 477 |
142 | 30021018 | 10 | 300210180034 | 61 | 2 FEMALE | 2 NO | 401 |
143 | 30021018 | 10 | 300210180040 | 61 | 2 FEMALE | 2 NO | 715 |
144 | 30021018 | 10 | 300210180056 | 61 | 2 FEMALE | 2 NO | 272 |
145 | 30021018 | 10 | 300210180062 | 61 | 2 FEMALE | 2 NO | 728 |
146 | 30021018 | 10 | 300210180078 | 61 | 2 FEMALE | 2 NO | 695 |
147 | 30021018 | 10 | 300210180084 | 61 | 2 FEMALE | 2 NO | 473 |
148 | 30022019 | 10 | 300220190016 | 71 | 2 FEMALE | 2 NO | 401 |
149 | 30022019 | 10 | 300220190022 | 71 | 2 FEMALE | 2 NO | 780 |
150 | 30022019 | 10 | 300220190038 | 71 | 2 FEMALE | 2 NO | 787 |
151 | 30022019 | 10 | 300220190044 | 71 | 2 FEMALE | 1 YES | 719 |
152 | 30022019 | 10 | 300220190050 | 71 | 2 FEMALE | 2 NO | 304 |
153 | 30022019 | 10 | 300220190066 | 71 | 2 FEMALE | 2 NO | 530 |
154 | 30022019 | 10 | 300220190072 | 71 | 2 FEMALE | 1 YES | 920 |
155 | 30022019 | 10 | 300220190088 | 71 | 2 FEMALE | 2 NO | 300 |
156 | 30022019 | 10 | 300220190094 | 71 | 2 FEMALE | 1 YES | 827 |
157 | 30022019 | 10 | 300220190107 | 71 | 2 FEMALE | 1 YES | 920 |
158 | 30023016 | 10 | 84 | 1 MALE | |||
159 | 30023023 | 10 | 300230230018 | 22 | 1 MALE | 2 NO | 462 |
160 | 30023030 | 10 | 300230300017 | 21 | 2 FEMALE | 2 NO | V22 |
161 | 30023041 | 10 | 300230410012 | 56 | 2 FEMALE | 2 NO | 436 |
162 | 30023041 | 10 | 300230410028 | 56 | 2 FEMALE | 2 NO | 272 |
163 | 30023041 | 10 | 300230410034 | 56 | 2 FEMALE | 2 NO | 401 |
164 | 30023041 | 10 | 300230410040 | 56 | 2 FEMALE | 2 NO | 250 |
165 | 30023058 | 10 | 300230580011 | 0 | 2 FEMALE | 2 NO | 382 |
166 | 30023058 | 10 | 300230580027 | 0 | 2 FEMALE | 2 NO | 691 |
167 | 30023058 | 10 | 300230580033 | 0 | 2 FEMALE | 2 NO | 79 |
168 | 30024013 | 10 | 35 | 2 FEMALE | |||
169 | 30024020 | 10 | 300240200016 | 55 | 1 MALE | 2 NO | 724 |
170 | 30024037 | 10 | 56 | 2 FEMALE | |||
171 | 30024044 | 10 | 35 | 1 MALE | |||
172 | 30024050 | 10 | 32 | 1 MALE | |||
173 | 30025011 | 10 | 0 | 1 MALE | |||
174 | 30025014 | 10 | 57 | 1 MALE | |||
175 | 30025021 | 10 | 40 | 2 FEMALE | |||
176 | 30025038 | 10 | 300250380010 | 22 | 2 FEMALE | 2 NO | V22 |
177 | 30025045 | 10 | 16 | 1 MALE | |||
178 | 30025051 | 10 | 24 | 1 MALE | |||
179 | 30026011 | 10 | 300260110013 | 37 | 1 MALE | 2 NO | 487 |
180 | 30026021 | 10 | 0 | 1 MALE | |||
181 | 30026026 | 10 | 300260260014 | 32 | 2 FEMALE | 2 NO | V22 |
182 | 30026034 | 10 | 300260340012 | 12 | 1 MALE | 2 NO | 487 |
183 | 30026042 | 10 | 300260420010 | 5 | 2 FEMALE | 2 NO | 460 |
184 | 30027013 | 10 | 300270130010 | 25 | 2 FEMALE | 2 NO | V22 |
185 | 30027020 | 10 | 25 | 1 MALE | |||
186 | 30027037 | 10 | 300270370018 | 2 | 1 MALE | 2 NO | 478 |
187 | 30028015 | 10 | 300280150014 | 60 | 2 FEMALE | 2 NO | 401 |
188 | 30028015 | 10 | 300280150020 | 60 | 2 FEMALE | 2 NO | -1 |
189 | 30028015 | 10 | 300280150036 | 60 | 2 FEMALE | 2 NO | 413 |
190 | 30028015 | 10 | 300280150042 | 60 | 2 FEMALE | 2 NO | 358 |
PROGRAM: C:\MEPS\PROG\M3.SAS
AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008 14:00 Tuesday, December 16, 2008 Page 4
ILLUSTRATING THE USE OF ID VARIABLES (DUPERSID, CONDIDX)
Obs | DUPERSI | PANEL | CONDIDX | AGE05X | SEX | INJURY | ICD9CODX |
---|---|---|---|---|---|---|---|
140 | 30021018 | 10 | 300210180084 | 61 | 2 FEMALE | 2 NO | 473 |
141 | 30022019 | 10 | 300220190016 | 71 | 2 FEMALE | 2 NO | 401 |
142 | 30022019 | 10 | 300220190022 | 71 | 2 FEMALE | 2 NO | 780 |
143 | 30022019 | 10 | 300220190038 | 71 | 2 FEMALE | 2 NO | 787 |
144 | 30022019 | 10 | 300220190044 | 71 | 2 FEMALE | 1 YES | 719 |
145 | 30022019 | 10 | 300220190050 | 71 | 2 FEMALE | 2 NO | 304 |
146 | 30022019 | 10 | 300220190066 | 71 | 2 FEMALE | 2 NO | 530 |
147 | 30022019 | 10 | 300220190072 | 71 | 2 FEMALE | 1 YES | 920 |
148 | 30022019 | 10 | 300220190088 | 71 | 2 FEMALE | 2 NO | 300 |
149 | 30022019 | 10 | 300220190094 | 71 | 2 FEMALE | 1 YES | 827 |
150 | 30022019 | 10 | 300220190107 | 71 | 2 FEMALE | 1 YES | 920 |
151 | 30023023 | 10 | 300230230018 | 22 | 1 MALE | 2 NO | 462 |
152 | 30023030 | 10 | 300230300017 | 21 | 2 FEMALE | 2 NO | V22 |
153 | 30023041 | 10 | 300230410012 | 56 | 2 FEMALE | 2 NO | 436 |
154 | 30023041 | 10 | 300230410028 | 56 | 2 FEMALE | 2 NO | 272 |
155 | 30023041 | 10 | 300230410034 | 56 | 2 FEMALE | 2 NO | 401 |
156 | 30023041 | 10 | 300230410040 | 56 | 2 FEMALE | 2 NO | 250 |
157 | 30023058 | 10 | 300230580011 | 0 | 2 FEMALE | 2 NO | 382 |
158 | 30023058 | 10 | 300230580027 | 0 | 2 FEMALE | 2 NO | 691 |
159 | 30023058 | 10 | 300230580033 | 0 | 2 FEMALE | 2 NO | 79 |
160 | 30024020 | 10 | 300240200016 | 55 | 1 MALE | 2 NO | 724 |
161 | 30025038 | 10 | 300250380010 | 22 | 2 FEMALE | 2 NO | V22 |
162 | 30026011 | 10 | 300260110013 | 37 | 1 MALE | 2 NO | 487 |
163 | 30026026 | 10 | 300260260014 | 32 | 2 FEMALE | 2 NO | V22 |
164 | 30026034 | 10 | 300260340012 | 12 | 1 MALE | 2 NO | 487 |
165 | 30026042 | 10 | 300260420010 | 5 | 2 FEMALE | 2 NO | 460 |
166 | 30027013 | 10 | 300270130010 | 25 | 2 FEMALE | 2 NO | V22 |
167 | 30027037 | 10 | 300270370018 | 2 | 1 MALE | 2 NO | 478 |
168 | 30028015 | 10 | 300280150014 | 60 | 2 FEMALE | 2 NO | 401 |
169 | 30028015 | 10 | 300280150020 | 60 | 2 FEMALE | 2 NO | -1 |
170 | 30028015 | 10 | 300280150036 | 60 | 2 FEMALE | 2 NO | 413 |
171 | 30028015 | 10 | 300280150042 | 60 | 2 FEMALE | 2 NO | 358 |
172 | 30028015 | 10 | 300280150058 | 60 | 2 FEMALE | 2 NO | 300 |
173 | 30028015 | 10 | 300280150064 | 60 | 2 FEMALE | 2 NO | 246 |
174 | 30028015 | 10 | 300280150070 | 60 | 2 FEMALE | 2 NO | 79 |
175 | 30028015 | 10 | 300280150086 | 60 | 2 FEMALE | 2 NO | 79 |
176 | 30028015 | 10 | 300280150092 | 60 | 2 FEMALE | 2 NO | 521 |
177 | 30028015 | 10 | 300280150105 | 60 | 2 FEMALE | 2 NO | 355 |
178 | 30028015 | 10 | 300280150111 | 60 | 2 FEMALE | 2 NO | 599 |
179 | 30028015 | 10 | 300280150127 | 60 | 2 FEMALE | 2 NO | 473 |
180 | 30028015 | 10 | 300280150133 | 60 | 2 FEMALE | 2 NO | 536 |
181 | 30028015 | 10 | 300280150149 | 60 | 2 FEMALE | 2 NO | V68 |
182 | 30028015 | 10 | 300280150155 | 60 | 2 FEMALE | 2 NO | 272 |
183 | 30028015 | 10 | 300280150161 | 60 | 2 FEMALE | 2 NO | 522 |
184 | 30028015 | 10 | 300280150177 | 60 | 2 FEMALE | 2 NO | 530 |
185 | 30028015 | 10 | 300280150183 | 60 | 2 FEMALE | 2 NO | V41 |
186 | 30028015 | 10 | 300280150199 | 60 | 2 FEMALE | 2 NO | 8 |
187 | 30028022 | 10 | 300280220013 | 62 | 1 MALE | 2 NO | 311 |
188 | 30028022 | 10 | 300280220029 | 62 | 1 MALE | 2 NO | 401 |
189 | 30028022 | 10 | 300280220035 | 62 | 1 MALE | 2 NO | 724 |
190 | 30028022 | 10 | 300280220041 | 62 | 1 MALE | 2 NO | 272 |
PROGRAM: C:\MEPS\PROG\M3.SAS