1 The SAS System 11:34 Tuesday, November 25, 2014 NOTE: Copyright (c) 2002-2010 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.3 (TS1M0) Licensed to NATIONAL BUREAU OF ECONOMIC RESEARCH, Site 70111351. NOTE: This session is executing on the Linux 2.6.32-431.29.2.el6.x86_64 (LIN X64) platform. You are running SAS 9. Some SAS 8 files will be automatically converted by the V9 engine; others are incompatible. Please see http://support.sas.com/rnd/migration/planning/platform/64bit.html PROC MIGRATE will preserve current SAS file attributes and is recommended for converting all your SAS libraries from any SAS 8 release to SAS 9. For details and examples, please see http://support.sas.com/rnd/migration/index.html This message is contained in the SAS news file, and is presented upon initialization. Edit the file "news" in the "misc/base" directory to display site-specific news and information in the program log. The command line option "-nonews" will prevent this display. NOTE: SAS initialization used: real time 0.93 seconds cpu time 0.01 seconds 1 *options obs=100 ; 2 options nocenter ; 3 4 **------------------------------------------------ ; 5 ** by Jean Roth Mon Jul 14 16:53:25 EDT 2014 6 ** This program reads the 2002 NCHS Multiple Cause of Death Data Data File ; 7 ** Report errors to jroth@nber.org ; 8 ** This program is distributed under the GNU GPL. ; 9 ** See end of this file and 10 ** http://www.gnu.org/licenses/ for details. ; 11 ** ----------------------------------------------- ; 12 13 * The following line should contain the directory 14 where the SAS file is to be stored ; 15 16 libname library "/homes/data/mortality/2002/"; NOTE: Libref LIBRARY was successfully assigned as follows: Engine: V9 Physical Name: /homes/data/mortality/2002 17 18 * The following line should contain 19 the complete path and name of the raw data file. 20 On a PC, use backslashes in paths as in C:\ ; 21 22 FILENAME datafile pipe "unzip -p /homes/data/mortality/2002/mort2002us.zip "; 23 24 * The following line should contain the name of the SAS dataset ; 25 26 %let dataset = library.mort2002; 2 The SAS System 11:34 Tuesday, November 25, 2014 27 28 DATA &dataset ; 29 30 INFILE datafile LRECL = 20000 ; 31 attrib rectype length=3 label="Record Type"; 32 attrib restatus length=3 label="Resident Status"; 33 attrib stateoc length=$2 label="State of Occurrence"; 34 attrib countyoc length=$5 label="County of Occurrence"; 35 attrib region length=3 label="Region"; 36 attrib divstoc length=3 label="Division and State Subcode of Occurrence"; 37 attrib exstatoc length=$2 label="Expanded State of Occurrence Code"; 38 attrib staters length=$2 label="State of Residence"; 39 attrib countyrs length=$5 label="County of Residence"; 40 attrib cityrs length=$3 label="City of Residence"; 41 attrib popsize length=$1 label="Population Size of City of Residence"; 42 attrib metro length=$1 label="Metropolitan - Nonmetropolitan County of Residence"; 43 attrib regnres length=3 label="Region"; 44 attrib divstres length=3 label="Division and State Subcode of Residence"; 45 attrib exstares length=$2 label="Expanded State of Residence Code"; 46 attrib pmsares length=$3 label="NCHS PMSA/MSA of Residence"; 47 attrib popsizoc length=3 label="Population Size of County of Occurrence"; 48 attrib popsizrs length=$1 label="Population Size of County of Residence"; 49 attrib popmsa length=$1 label="PMSA/MSA Population Size"; 50 attrib educ length=3 label="Education"; 51 attrib educr length=3 label="Education recode"; 52 attrib monthdth length=3 label="Month of Death"; 53 attrib sex length=3 label="Sex"; 54 attrib race length=3 label="Detail Race"; 55 attrib racer3 length=3 label="Race Recode 3"; 56 attrib racer2 length=3 label="Race Recode 2"; 57 attrib age length=3 label="Detail Age"; 58 attrib ager52 length=3 label="Age Recode 52"; 59 attrib ager27 length=3 label="Age Recode 27"; 60 attrib ager12 length=3 label="Age Recode 12"; 61 attrib ager22 length=3 label="Infant Age Recode 22"; 62 attrib placdth length=3 label="Place of Death and Decedent's Status"; 63 attrib marstat length=3 label="Marital Status"; 64 attrib statbth length=3 label="State of Birth"; 65 attrib hispanic length=3 label="Hispanic Origin"; 66 attrib hspanicr length=3 label="Hispanic Origin/Race Recode"; 67 attrib weekday length=3 label="Day of Week of Death"; 68 attrib fipscity length=$5 label="Place (city) of Residence (FIPS)"; 69 attrib year length=4 label="Current Data Year"; 70 attrib fipssto length=$2 label="State of Occurrence (FIPS)"; 71 attrib fipsctyo length=$5 label="County of Occurrence (FIPS)"; 72 attrib fipsstr length=$2 label="State of Residence (FIPS)"; 73 attrib fipsctyr length=$5 label="County of Residence (FIPS)"; 74 attrib fipspmsa length=$4 label="PMSA/MSA of Residence (FIPS)"; 75 attrib fipscmsa length=$2 label="CMSA of Residence (FIPS)"; 76 attrib injwork length=3 label="Injury at Work"; 77 attrib raceimp length=3 label="Race Imputation Flag"; 78 attrib ageflag length=3 label="Age Substitution Flag"; 79 attrib mandeath length=3 label="Manner of death"; 80 attrib activity length=3 label="Activity code"; 81 attrib injury length=3 label="Place of Injury for Causes W00-Y34 - except Y06.- and Y07.-"; 82 attrib ucod length=$4 label="ICD Code (9th Revision)"; 83 attrib ucr358 length=3 label="358 Cause Recode"; 84 attrib ucr113 length=3 label="113 Cause Recode"; 3 The SAS System 11:34 Tuesday, November 25, 2014 85 attrib ucr130 length=3 label="130 Cause Recode"; 86 attrib ucr39 length=3 label="39 Cause Recode"; 87 attrib eanum length=3 label="Number of Entity-Axis Conditions"; 88 attrib econdp_1 length=3 label=""; 89 attrib econds_1 length=$1 label=""; 90 attrib enicon_1 length=$4 label=""; 91 attrib econdp_2 length=3 label=""; 92 attrib econds_2 length=$1 label=""; 93 attrib enicon_2 length=$4 label=""; 94 attrib econdp_3 length=3 label=""; 95 attrib econds_3 length=$1 label=""; 96 attrib enicon_3 length=$4 label=""; 97 attrib econdp_4 length=3 label=""; 98 attrib econds_4 length=$1 label=""; 99 attrib enicon_4 length=$4 label=""; 100 attrib econdp_5 length=3 label=""; 101 attrib econds_5 length=$1 label=""; 102 attrib enicon_5 length=$4 label=""; 103 attrib econdp_6 length=3 label=""; 104 attrib econds_6 length=$1 label=""; 105 attrib enicon_6 length=$4 label=""; 106 attrib econdp_7 length=3 label=""; 107 attrib econds_7 length=$1 label=""; 108 attrib enicon_7 length=$4 label=""; 109 attrib econdp_8 length=3 label=""; 110 attrib econds_8 length=$1 label=""; 111 attrib enicon_8 length=$4 label=""; 112 attrib econdp_9 length=3 label=""; 113 attrib econds_9 length=$1 label=""; 114 attrib enicon_9 length=$4 label=""; 115 attrib econdp_10 length=3 label=""; 116 attrib econds_10 length=$1 label=""; 117 attrib enicon_10 length=$4 label=""; 118 attrib econdp_11 length=3 label=""; 119 attrib econds_11 length=$1 label=""; 120 attrib enicon_11 length=$4 label=""; 121 attrib econdp_12 length=3 label=""; 122 attrib econds_12 length=$1 label=""; 123 attrib enicon_12 length=$4 label=""; 124 attrib econdp_13 length=3 label=""; 125 attrib econds_13 length=$1 label=""; 126 attrib enicon_13 length=$4 label=""; 127 attrib econdp_14 length=3 label=""; 128 attrib econds_14 length=$1 label=""; 129 attrib enicon_14 length=$4 label=""; 130 attrib econdp_15 length=3 label=""; 131 attrib econds_15 length=$1 label=""; 132 attrib enicon_15 length=$4 label=""; 133 attrib econdp_16 length=3 label=""; 134 attrib econds_16 length=$1 label=""; 135 attrib enicon_16 length=$4 label=""; 136 attrib econdp_17 length=3 label=""; 137 attrib econds_17 length=$1 label=""; 138 attrib enicon_17 length=$4 label=""; 139 attrib econdp_18 length=3 label=""; 140 attrib econds_18 length=$1 label=""; 141 attrib enicon_18 length=$4 label=""; 142 attrib econdp_19 length=3 label=""; 4 The SAS System 11:34 Tuesday, November 25, 2014 143 attrib econds_19 length=$1 label=""; 144 attrib enicon_19 length=$4 label=""; 145 attrib econdp_20 length=3 label=""; 146 attrib econds_20 length=$1 label=""; 147 attrib enicon_20 length=$4 label=""; 148 attrib ranum length=3 label="Number of Record-Axis Conditions"; 149 attrib record_1 length=$4 label="Condition"; 150 attrib record_2 length=$4 label="Condition"; 151 attrib record_3 length=$4 label="Condition"; 152 attrib record_4 length=$4 label="Condition"; 153 attrib record_5 length=$4 label="Condition"; 154 attrib record_6 length=$4 label="Condition"; 155 attrib record_7 length=$4 label="Condition"; 156 attrib record_8 length=$4 label="Condition"; 157 attrib record_9 length=$4 label="Condition"; 158 attrib record_10 length=$4 label="Condition"; 159 attrib record_11 length=$4 label="Condition"; 160 attrib record_12 length=$4 label="Condition"; 161 attrib record_13 length=$4 label="Condition"; 162 attrib record_14 length=$4 label="Condition"; 163 attrib record_15 length=$4 label="Condition"; 164 attrib record_16 length=$4 label="Condition"; 165 attrib record_17 length=$4 label="Condition"; 166 attrib record_18 length=$4 label="Condition"; 167 attrib record_19 length=$4 label="Condition"; 168 attrib record_20 length=$4 label="Condition"; 169 170 171 INPUT 172 173 @19 rectype 1. 174 @20 restatus 1. 175 @21 stateoc $2. 176 @21 countyoc $5. 177 @26 region 1. 178 @27 divstoc 2. 179 @29 exstatoc $2. 180 @31 staters $2. 181 @31 countyrs $5. 182 @36 cityrs $3. 183 @39 popsize $1. 184 @40 metro $1. 185 @41 regnres 1. 186 @42 divstres 2. 187 @44 exstares $2. 188 @46 pmsares $3. 189 @49 popsizoc 1. 190 @50 popsizrs $1. 191 @51 popmsa $1. 192 @52 educ 2. 193 @54 educr 1. 194 @55 monthdth 2. 195 @59 sex 1. 196 @60 race 2. 197 @62 racer3 1. 198 @63 racer2 1. 199 @64 age 3. 200 @67 ager52 2. 5 The SAS System 11:34 Tuesday, November 25, 2014 201 @69 ager27 2. 202 @71 ager12 2. 203 @73 ager22 2. 204 @75 placdth 1. 205 @77 marstat 1. 206 @78 statbth 2. 207 @80 hispanic 2. 208 @82 hspanicr 1. 209 @83 weekday 1. 210 @97 fipscity $5. 211 @115 year 4. 212 @119 fipssto $2. 213 @119 fipsctyo $5. 214 @124 fipsstr $2. 215 @124 fipsctyr $5. 216 @129 fipspmsa $4. 217 @134 fipscmsa $2. 218 @136 injwork 1. 219 @137 raceimp 1. 220 @138 ageflag 1. 221 @139 mandeath 1. 222 @140 activity 1. 223 @141 injury 1. 224 @142 ucod $4. 225 @146 ucr358 3. 226 @151 ucr113 3. 227 @154 ucr130 3. 228 @157 ucr39 2. 229 @160 eanum 2. 230 @162 econdp_1 1. 231 @163 econds_1 $1. 232 @164 enicon_1 $4. 233 @169 econdp_2 1. 234 @170 econds_2 $1. 235 @171 enicon_2 $4. 236 @176 econdp_3 1. 237 @177 econds_3 $1. 238 @178 enicon_3 $4. 239 @183 econdp_4 1. 240 @184 econds_4 $1. 241 @185 enicon_4 $4. 242 @190 econdp_5 1. 243 @191 econds_5 $1. 244 @192 enicon_5 $4. 245 @197 econdp_6 1. 246 @198 econds_6 $1. 247 @199 enicon_6 $4. 248 @204 econdp_7 1. 249 @205 econds_7 $1. 250 @206 enicon_7 $4. 251 @211 econdp_8 1. 252 @212 econds_8 $1. 253 @213 enicon_8 $4. 254 @218 econdp_9 1. 255 @219 econds_9 $1. 256 @220 enicon_9 $4. 257 @225 econdp_10 1. 258 @226 econds_10 $1. 6 The SAS System 11:34 Tuesday, November 25, 2014 259 @227 enicon_10 $4. 260 @232 econdp_11 1. 261 @233 econds_11 $1. 262 @234 enicon_11 $4. 263 @239 econdp_12 1. 264 @240 econds_12 $1. 265 @241 enicon_12 $4. 266 @246 econdp_13 1. 267 @247 econds_13 $1. 268 @248 enicon_13 $4. 269 @253 econdp_14 1. 270 @254 econds_14 $1. 271 @255 enicon_14 $4. 272 @260 econdp_15 1. 273 @261 econds_15 $1. 274 @262 enicon_15 $4. 275 @267 econdp_16 1. 276 @268 econds_16 $1. 277 @269 enicon_16 $4. 278 @274 econdp_17 1. 279 @275 econds_17 $1. 280 @276 enicon_17 $4. 281 @281 econdp_18 1. 282 @282 econds_18 $1. 283 @283 enicon_18 $4. 284 @288 econdp_19 1. 285 @289 econds_19 $1. 286 @290 enicon_19 $4. 287 @295 econdp_20 1. 288 @296 econds_20 $1. 289 @297 enicon_20 $4. 290 @338 ranum 2. 291 @341 record_1 $4. 292 @346 record_2 $4. 293 @351 record_3 $4. 294 @356 record_4 $4. 295 @361 record_5 $4. 296 @366 record_6 $4. 297 @371 record_7 $4. 298 @376 record_8 $4. 299 @381 record_9 $4. 300 @386 record_10 $4. 301 @391 record_11 $4. 302 @396 record_12 $4. 303 @401 record_13 $4. 304 @406 record_14 $4. 305 @411 record_15 $4. 306 @416 record_16 $4. 307 @421 record_17 $4. 308 @426 record_18 $4. 309 @431 record_19 $4. 310 @436 record_20 $4. 311 ; 312 NOTE: The infile DATAFILE is: Pipe command="unzip -p /homes/data/mortality/2002/mort2002us.zip " 7 The SAS System 11:34 Tuesday, November 25, 2014 NOTE: 2446796 records were read from the infile DATAFILE. The minimum record length was 441. The maximum record length was 441. NOTE: The data set LIBRARY.MORT2002 has 2446796 observations and 138 variables. NOTE: DATA statement used (Total process time): real time 32.07 seconds cpu time 14.61 seconds 313 proc print data=&dataset. (obs=6); 314 NOTE: There were 6 observations read from the data set LIBRARY.MORT2002. NOTE: The PROCEDURE PRINT printed page 1. NOTE: PROCEDURE PRINT used (Total process time): real time 0.12 seconds cpu time 0.00 seconds 315 proc contents data=&dataset.; 316 317 318 ** Copyright 2014 shared by the National Bureau of Economic Research and Jean Roth ; 319 ** 320 ** National Bureau of Economic Research. ; 321 ** 1050 Massachusetts Avenue ; 322 ** Cambridge, MA 02138 ; 323 ** jroth@nber.org ; 324 ** 325 ** This program and all programs referenced in it are free software. You ; 326 ** can redistribute the program or modify it under the terms of the GNU ; 327 ** General Public License as published by the Free Software Foundation; ; 328 ** either version 2 of the License, or (at your option) any later version. ; 329 ** 330 ** This program is distributed in the hope that it will be useful, ; 331 ** but WITHOUT ANY WARRANTY -- without even the implied warranty of ; 332 ** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the ; 333 ** GNU General Public License for more details. ; 334 ** 335 ** You should have received a copy of the GNU General Public License ; 336 ** along with this program -- if not, write to the Free Software ; 337 ** Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 ; 338 ** USA. ; 339 NOTE: The PROCEDURE CONTENTS printed pages 2-5. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.04 seconds cpu time 0.01 seconds NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 33.23 seconds cpu time 14.64 seconds