1 The SAS System 12:53 Wednesday, October 31, 2007 NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) 9.1 (TS1M3) Licensed to HARVARD UNIV - SCHOOL OF PUBLIC HEALTH - T&R, Site 0001177014. NOTE: This session is executing on the SunOS 5.9 platform. NOTE: SAS 9.1.3 Service Pack 3 ----------------------------------------------------------------------- NBER NOTE: sas now defaults to sas9. sas8 or sas6 will invoke sas version 8 or 6 respectively. - 2005/10/21 ----------------------------------------------------------------------- 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.33 seconds cpu time 0.13 seconds 1 *options obs=100 ; 2 options formdlim=" "; 3 options nocenter ; 4 5 /*------------------------------------------------ 6 by Jean Roth Thu Jan 18 14:40:29 EST 2007 7 This program reads the 1966 NCHS Multiple Cause of Death Data Data File 8 9 Report errors to jroth@nber.org 10 This program is distributed under the GNU GPL. 11 See end of this file and 12 http://www.gnu.org/licenses/ for details. 13 ----------------------------------------------- */ 14 15 * The following line should contain the directory 16 where the SAS file is to be stored ; 17 18 libname library "~/bulk"; NOTE: Libref LIBRARY was successfully assigned as follows: Engine: V9 Physical Name: /homes/nber/jroth/bulk 19 20 * The following line should contain 2 The SAS System 12:53 Wednesday, October 31, 2007 21 the complete path and name of the raw data file. 22 On a PC, use backslashes in paths as in C:\ ; 23 24 %macro loop; 25 %do year=1959 %to 1967; 26 27 FILENAME datafile pipe "unzip -p /homes/data/mortality/1959-1967/mort&year..zip "; 28 29 * The following line should contain the name of the SAS dataset ; 30 31 %let dataset =_&year.; 32 33 DATA &dataset ; 34 35 INFILE datafile LRECL = 20000 ; 36 attrib ucr60 length=3 label=""; 37 attrib ucr33 length=3 label=""; 38 39 INPUT 40 41 @94 ucr60 2. 42 @96 ucr33 2. 43 ; 44 45 proc freq data=&dataset.; 46 tables ucr60 ucr33; 47 title2 "&year."; 48 49 %end; 50 %mend; 51 %loop; NOTE: The infile DATAFILE is: Pipe command="unzip -p /homes/data/mortality/1959-1967/mort1959.zip " NOTE: 1660172 records were read from the infile DATAFILE. The minimum record length was 98. The maximum record length was 100. NOTE: The data set WORK._1959 has 1660172 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 23.77 seconds cpu time 19.39 seconds NOTE: There were 1660172 observations read from the data set WORK._1959. NOTE: The PROCEDURE FREQ printed pages 1-2. NOTE: PROCEDURE FREQ used (Total process time): real time 1.58 seconds cpu time 1.50 seconds NOTE: The infile DATAFILE is: Pipe command="unzip -p /homes/data/mortality/1959-1967/mort1960.zip " NOTE: 1711982 records were read from the infile DATAFILE. The minimum record length was 98. 3 The SAS System 12:53 Wednesday, October 31, 2007 The maximum record length was 100. NOTE: The data set WORK._1960 has 1711982 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 25.62 seconds cpu time 19.94 seconds NOTE: There were 1711982 observations read from the data set WORK._1960. NOTE: The PROCEDURE FREQ printed pages 3-4. NOTE: PROCEDURE FREQ used (Total process time): real time 1.54 seconds cpu time 1.51 seconds NOTE: The infile DATAFILE is: Pipe command="unzip -p /homes/data/mortality/1959-1967/mort1961.zip " NOTE: 1701522 records were read from the infile DATAFILE. The minimum record length was 98. The maximum record length was 100. NOTE: The data set WORK._1961 has 1701522 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 25.52 seconds cpu time 20.10 seconds NOTE: There were 1701522 observations read from the data set WORK._1961. NOTE: The PROCEDURE FREQ printed pages 5-6. NOTE: PROCEDURE FREQ used (Total process time): real time 1.53 seconds cpu time 1.49 seconds NOTE: The infile DATAFILE is: Pipe command="unzip -p /homes/data/mortality/1959-1967/mort1962.zip " NOTE: 1756720 records were read from the infile DATAFILE. The minimum record length was 107. The maximum record length was 107. NOTE: The data set WORK._1962 has 1756720 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 26.81 seconds cpu time 21.14 seconds NOTE: There were 1756720 observations read from the data set WORK._1962. NOTE: The PROCEDURE FREQ printed pages 7-8. NOTE: PROCEDURE FREQ used (Total process time): real time 1.53 seconds cpu time 1.51 seconds 4 The SAS System 12:53 Wednesday, October 31, 2007 NOTE: The infile DATAFILE is: Pipe command="unzip -p /homes/data/mortality/1959-1967/mort1963.zip " NOTE: 1813549 records were read from the infile DATAFILE. The minimum record length was 107. The maximum record length was 107. NOTE: The data set WORK._1963 has 1813549 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 28.26 seconds cpu time 21.80 seconds NOTE: There were 1813549 observations read from the data set WORK._1963. NOTE: The PROCEDURE FREQ printed pages 9-10. NOTE: PROCEDURE FREQ used (Total process time): real time 2.02 seconds cpu time 1.61 seconds NOTE: The infile DATAFILE is: Pipe command="unzip -p /homes/data/mortality/1959-1967/mort1964.zip " NOTE: 1798051 records were read from the infile DATAFILE. The minimum record length was 107. The maximum record length was 107. NOTE: The data set WORK._1964 has 1798051 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 27.46 seconds cpu time 21.27 seconds NOTE: There were 1798051 observations read from the data set WORK._1964. NOTE: The PROCEDURE FREQ printed pages 11-12. NOTE: PROCEDURE FREQ used (Total process time): real time 1.53 seconds cpu time 1.54 seconds NOTE: The infile DATAFILE is: Pipe command="unzip -p /homes/data/mortality/1959-1967/mort1965.zip " NOTE: 1828136 records were read from the infile DATAFILE. The minimum record length was 107. The maximum record length was 107. NOTE: The data set WORK._1965 has 1828136 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 27.33 seconds cpu time 21.50 seconds NOTE: There were 1828136 observations read from the data set WORK._1965. NOTE: The PROCEDURE FREQ printed pages 13-14. NOTE: PROCEDURE FREQ used (Total process time): 5 The SAS System 12:53 Wednesday, October 31, 2007 real time 1.62 seconds cpu time 1.58 seconds NOTE: The infile DATAFILE is: Pipe command="unzip -p /homes/data/mortality/1959-1967/mort1966.zip " NOTE: 1863149 records were read from the infile DATAFILE. The minimum record length was 107. The maximum record length was 107. NOTE: The data set WORK._1966 has 1863149 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 27.26 seconds cpu time 21.94 seconds NOTE: There were 1863149 observations read from the data set WORK._1966. NOTE: The PROCEDURE FREQ printed pages 15-16. NOTE: PROCEDURE FREQ used (Total process time): real time 1.63 seconds cpu time 1.60 seconds NOTE: The infile DATAFILE is: Pipe command="unzip -p /homes/data/mortality/1959-1967/mort1967.zip " NOTE: Invalid data for ucr60 in line 41945 1-2. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 41946 72 11330290090123103180311110610818 151--056 1207 20 1 33029\. 70 ZONE 3322222233333333333333333333333333333333223332233323333233232223333350 NUMR 720000001133029009012310318031111061081800151DD056012070200100033029CD NOTE: Invalid data errors for file DATAFILE occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. ucr60=. ucr33=72 _ERROR_=1 _N_=13982 NOTE: Invalid data for ucr33 in line 354063 1-2. 354063 7S 11330290090123101210111120801022 260--106 2251 2 33029\. 70 ZONE 3522222233333333333333333333333333333333223332233323333222232223333350 NUMR 730000001133029009012310121011112080102200260DD106022510000200033029CD ucr60=72 ucr33=. _ERROR_=1 _N_=118021 NOTE: Invalid data for ucr60 in line 592772 1-2. 592773 72 11330290090123101070111110030205 34033127 2410 09 1 33029\. 70 ZONE 3322222233333333333333333333333333333333223333333323333233232223333350 NUMR 72000000113302900901231010701111100302050034033127024100090100033029CD NOTE: Invalid data errors for file DATAFILE occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. ucr60=. ucr33=72 _ERROR_=1 _N_=197591 NOTE: Invalid data for ucr60 in line 605177 1-2. 605178 70 110105599990002099909111121001022135622136 5511 1 01055\. 70 ZONE 3322222233333333333333333333333333333333333333333323333222232223333350 NUMR 70000000110105599990002099909111121001022135622136055110000100001055CD NOTE: Invalid data errors for file DATAFILE occurred outside the printed range. 6 The SAS System 12:53 Wednesday, October 31, 2007 NOTE: Increase available buffer lines with the INFILE n= option. ucr60=. ucr33=70 _ERROR_=1 _N_=201726 NOTE: Invalid data for ucr33 in line 731169 1-2. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 731169 7S 11330290090123105230511110720920 42000142 2751 1 33029\. 70 ZONE 3522222233333333333333333333333333333333223333333323333222232223333350 NUMR 73000000113302900901231052305111107209200042000142027510000100033029CD ucr60=72 ucr33=. _ERROR_=1 _N_=243723 NOTE: Invalid data for ucr33 in line 1043751 1-2. 1043751 7S 11330290090123106090611110660919 42011143 2751 1 33029\. 70 ZONE 3522222233333333333333333333333333333333223333333323333222232223333350 NUMR 73000000113302900901231060906111106609190042011143027510000100033029CD ucr60=72 ucr33=. _ERROR_=1 _N_=347917 NOTE: Invalid data for ucr33 in line 1043844 1-2. 1043844 7S 11330290090123101180111120640818 42011143 2751 2 33029\. 70 ZONE 3522222233333333333333333333333333333333223333333323333222232223333350 NUMR 73000000113302900901231011801111206408180042011143027510000200033029CD ucr60=72 ucr33=. _ERROR_=1 _N_=347948 NOTE: Invalid data for ucr60 in line 1413620 1-2. 1413621 72 11330290090123101040111110670919 490--165 3614223 1 33029\. 70 ZONE 3322222233333333333333333333333333333333223332233323333333232223333350 NUMR 720000001133029009012310104011111067091900490DD165036142230100033029CD NOTE: Invalid data errors for file DATAFILE occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. ucr60=. ucr33=72 _ERROR_=1 _N_=471207 NOTE: Invalid data for ucr60 in line 1492943 1-2. 1492944 72 11330290090123101030111110660919 52711176 3820 1 33029\. 70 ZONE 3322222233333333333333333333333333333333223333333323333222232223333350 NUMR 72000000113302900901231010301111106609190052711176038200000100033029CD NOTE: Invalid data errors for file DATAFILE occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. ucr60=. ucr33=72 _ERROR_=1 _N_=497648 NOTE: Invalid data for ucr60 in line 1789301 1-2. 1789302 70 11390510900133103100322210230410 9143-240 57544 11 39051\. 70 ZONE 3322222233333333333333333333333333333333223333233323333322332223333350 NUMR 7000000011390510900133103100322210230410009143D240057544001100039051CD NOTE: Invalid data errors for file DATAFILE occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. ucr60=. ucr33=70 _ERROR_=1 _N_=596434 NOTE: Invalid data for ucr60 in line 1846295 1-2. 1846296 70 22150619999000206170611120040206 982--254 5955 22 15082\. 70 ZONE 3322222233333333333333333333333333333333223332233323333222332223333350 NUMR 700000002215061999900020617061112004020600982DD254059550002200015082CD NOTE: Invalid data errors for file DATAFILE occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. ucr60=. ucr33=70 _ERROR_=1 _N_=615432 NOTE: LOST CARD. ucr60=70 ucr33=. _ERROR_=1 _N_=617108 NOTE: 1851323 records were read from the infile DATAFILE. The minimum record length was 70. The maximum record length was 70. 7 The SAS System 12:53 Wednesday, October 31, 2007 NOTE: SAS went to a new line when INPUT statement reached past the end of a line. NOTE: The data set WORK._1967 has 617107 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 25.09 seconds cpu time 19.82 seconds 52 53 /* 54 Copyright 2007 shared by the National Bureau of Economic Research and Jean Roth 55 56 National Bureau of Economic Research. 57 1050 Massachusetts Avenue 58 Cambridge, MA 02138 59 jroth@nber.org 60 61 This program and all programs referenced in it are free software. You 62 can redistribute the program or modify it under the terms of the GNU 63 General Public License as published by the Free Software Foundation; 64 either version 2 of the License, or (at your option) any later version. 65 66 This program is distributed in the hope that it will be useful, 67 but WITHOUT ANY WARRANTY; without even the implied warranty of 68 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 69 GNU General Public License for more details. 70 71 You should have received a copy of the GNU General Public License 72 along with this program; if not, write to the Free Software 73 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 74 USA. 75 */ 76 NOTE: There were 617107 observations read from the data set WORK._1967. NOTE: The PROCEDURE FREQ printed page 17. NOTE: PROCEDURE FREQ used (Total process time): real time 0.62 seconds cpu time 0.59 seconds NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 4:11.23 cpu time 3:20.00