This file contains three sample PC-SAS program: one that creates a FORMAT library for use with the mortality or population files, one that creates a SAS data set from the ASCII 1968-78 mortality file, and one that creates a SAS data set from the ASCII 1968-78 population file. Note that the format program must be run first, as the formats it creates are used in the second and third programs. Also, note that the latyouts of the mortality and population files are different, and these programs do not change their layouts. 1. This is an example of a PC-SAS program that creates a SAS FORMAT library for use with the mortality and population files. *THIS PROGRAM IS STORED IN c:\CMF\PROGRAMS; *THE FORMAT LIBRARY IS STORED IN THE FILE LIBRARY' IN C:\CMF; *********************************************************************; * PLACE NEXT STATEMENT IN SUBSEQUENT PROGRAMS; LIBNAME LIBRARY 'C:\CMF\'; /*THIS IS FOR THE FORMAT LIBRARY*/ * DEFINE FORMATS (VARIABLE VALUES) FOR REPORTS; PROC FORMAT LIBRARY=LIBRARY; VALUE FSTATE 01 = "Alabama" 02 = "Alaska" 04 = "Arizona" 05 = "Arkansas" 06 = "California" 08 = "Colorado" 09 = "Connecticut" 10 = " Delaware" 11 ="District of Columbia" 12 = "F lorida" 13 = "Georgia" 15 = "Hawaii" 16 = "Idaho" 17 = "Illinois" 18 = " Indiana" 19 = " Iowa" 20 = "Kansas" 21 = "Kentucky" 22 = "Louisiana" 23 = "Maine" 24 = "Maryland" 25 = "Massachusetts" 26 = "Michigan" 27 = "Minnesota" 28 = "Mississippi" 29 = "Missouri" 30 = "Montana" 31 = "Nebraska" 32 = "Nevada" 33 ="New Hampshire" 34 ="New Jersey" 35 = "New Mexico" 36 = "New York" 37 = "North Carolina" 38 = "North Dakota" 39 = "Ohio" 40 = "Oklahoma" 41 = "Oregon" 42 = "Pennsylvania" 44 = "Rhode Island" 45 = "South Carolina" 46 = "South Dakota" 47 = "Tennessee" 48 = "Texas" 49 ="Utah" 50 = "Vermont" 51 = "Virginia" 53 = "Washington" 54 = "West Virginia" 55 = "Wisconsin" 56 = "Wyoming" ; VALUE YR 1968 = "1968" 1969 = "1969" 1970 = "1970" 1971 = "1971" 1972 = "1972" 1973 = "1973" 1974 = "1974" 1975 = "1975" 1976 = "1976" 1977 = "1977" 1978 = "1978" 1979 = "1979" 1980 = "1980" 1981 = "1981" 1982 ="1982" 1983 = "1983" 1984 = "1984" 1985 = "1985" 1986 = "1986" 1987 = "1987" 1988 = "1988" ; VALUE RS 1 = "White male" 2 = "White female" 3 = "Black male" 4 = "Black female" 5 = "Other male" 6 = "Other female" ; VALUE MORTAGE 01 = "Under 1 day" 02 = "1-6 days" 03 = "7-27 days" 04 = "28-365 days" 05 = "1-4 years" 06 = "5-9 years" 07 = "10-14 years" 08 = "15-19 years" 09 = "20-24 years" 10 = "25-34 years" 11 = "35-44 years" 12 = "45-54 years" 13 = "55-64 years" 14 = "65-74 years" 15 = "75-84 years" 16 = "85+ years" 99 = "Unknown" ; VALUE RTYPE 1 ="National" 2 ="State" 3 ="County" ; 2. This is an example of a PC SAS program that creates a SAS data set from the ASCII 1968-78 mortality file.. *THIS PROGRAM IS STORED IN c:\CMF\PROGRAMS; *THE INPUT DATA SET IS STORED ON THE CD-ROM IN CMF.MORT6878; *THE OUTPUT DATA SET IS STORED IN C:\CMF AND IS NAMED MORT6878; *********************************************************************; * PLACE NEXT TWO STATEMENTS IN SUBSEQUENT PROGRAMS; LIBNAME CMF 'C:\CMF\'; LIBNAME LIBRARY 'C:\CMF\'; * CREATE A SAS DATA SET NAMED MORT6878 AND STORE IN DIR 'C:\CMF\'; DATA CMF.MORT6878; *READ IN FILE FROM CD-ROM; INFILE 'd:\MORT6878' MISSOVER LRECL=23; * DEFINE LENGTH OF NUMERIC VARIABLES; LENGTH STATE 3 COUNTY 3 YEAR 4 RACESEX 3 AGE 3 ICDCODE 4 IRECODE 3 NDEATHS 4; * INPUT ALL VARIABLES; INPUT STATE 1-2 COUNTY 3-5 YEAR 6-9 RACESEX 10 AGE 11-12 ICDCODE 13-16 IRECODE 17-19 NDEATHS 20-23; * DEFINE VARIABLE LABELS; LABEL STATE ="FIPS State Code" COUNTY ="FIPS County Code" YEAR ="Year of Death" RACESEX ="Race-sex" AGE ="Age at Death" ICDCODE ="ICD Code, underlying cause" IRECODE ="Cause of death recode" NDEATHS="Number of deaths" ; * ASSOCIATE VARIABLES WITH FORMAT VALUES; FORMAT STATE FSTATE. YEAR YR. RACESEX RS. AGE MORTAGE. ; *INSERT STATEMENTS TO SELECT RECORDS FOR OUTPUT MORTALITY FILE . . ; PROC CONTENTS DATA=CMF.MORT6878; PROC FREQ DATA=CMF.MORT6878; TITLE1 'FREQUENCY REPORT FOR CMF1968-78 MORTALITY FILE'; TABLES STATE YEAR RACESEX AGE; * NOTE: TO SEE UNFORMATTED VALUES IN PROC FREQ, ADD THE STATEMENT: FORMAT _ALL_; RUN; 3. This is an example of a PC SAS program that creates a SAS data set from the ASCII 1968-78 population file *THIS PROGRAM IS STORED IN c:\CMF\PROGRAMS; *THE INPUT DATA SET IS STORED ON THE CD-ROM IN CMF.POP6878; *THE OUTPUT DATA SET IS STORED IN C:\CMF AND IS NAMED POP6878; *********************************************************************; * PLACE NEXT TWO STATEMENTS IN SUBSEQUENT PROGRAMS; LIBNAME CMF 'C:\CMF\'; LIBNAME LIBRARY 'C:\CMF\'; *CREATE A SAS DATA SET NAMED POP6878 AND STORE IN DIR 'C:\CMF\'; DATA CMF.POP6878; *READ IN FILE FROM CD-ROM; INFILE 'd:\POP6878' MISSOVER LRECL=140; * DEFINE LENGTH OF NUMERIC VARIABLES; LENGTH STATE 3 COUNTY 3 YEAR 4 RACESEX 3 NBIRTHS 8 POP0104 8 POP0509 8 POP1014 8 POP1519 8 POP2024 8 POP2534 8 POP3544 8 POP4554 8 POP5564 8 POP6574 8 POP7584 8 POP85 8 CNTYNAME $25 RECTYPE 3 ; * INPUT ALL VARIABLES; INPUT STATE 1-2 COUNTY 3-5 YEAR 6-9 RACESEX 10 NBIRTHS 8. POP0104 8. POP0509 8. POP1014 8. POP1519 8. POP2024 8. POP2534 8. POP3544 8. POP4554 8. POP5564 8. POP6574 8. POP7584 8. POP85 8. CNTYNAME $ 115-139 RECTYPE 140; * DEFINE VARIABLE LABELS; LABEL STATE ="FIPS State Code" COUNTY ="FIPS County Code" YEAR ="Year of Death" RACESEX ="Race-sex" NBIRTHS = "Number of live births" POP0104 ="Population, ages 1-4" POP0509 ="Population, ages 5-9" POP1014 ="Population, ages 10-14" POP1519 ="Population, ages 15-19" POP2024 ="Population, ages 20-24" POP2534 ="Population, ages 25-34" POP3544 ="Population, ages 35-44" POP4554 ="Population, ages 45-54" POP5564 ="Population, ages 55-64" POP6574 ="Population, ages 65-74" POP7584 ="Population, ages 1-84" POP85 ="Population, ages 85+" CNTYNAME ="County name" RECTYPE ="Record type" ; * ASSOCIATE VARIABLES WITH FORMAT VALUES; FORMAT STATE FSTATE. YEAR YR. RACESEX RS. RECTYPE RTYPE. ; *INSERT STATEMENTS TO SELECT RECORDS FOR OUTPUT POPULATION FILE . . . ; PROC CONTENTS DATA=CMF.POP6878; PROC FREQ DATA=CMF.POP6878; TITLE1 'FREQUENCY REPORT FOR CMF 1968-78 POPULATION FILE'; TABLES STATE YEAR RACESEX RECTYPE; * NOTE: TO SEE UNFORMATTED VALUES IN PROC FREQ, ADD THE STATEMENT: FORMAT _ALL_; RUN;