*This is an example of a PC SAS program that creates a SAS data set from the ASCII 1968-78 population file; *THE OUTPUT DATA SET IS STORED IN /home/data/cmf_new AND IS NAMED POP7988; *********************************************************************; * PLACE NEXT TWO STATEMENTS IN SUBSEQUENT PROGRAMS; *options obs=20; LIBNAME CMF '/home/data/cmf_new/'; LIBNAME LIBRARY './'; PROC FORMAT library=library; ; VALUE FSTATE 1 = "Alabama" 2 = "Alaska" 4 = "Arizona" 5 = "Arkansas" 6 = "California" 8 = "Colorado" 9 = "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 RS 1 = "White male" 2 = "White female" 3 = "Black male" 4 = "Black female" 5 = "Other male" 6 = "Other female" ; ; VALUE MORTAGE 1 = "Under 1 day" 2 = "1-6 days" 3 = "7-27 days" 4 = "28-365 days" 5 = "1-4 years" 6 = "5-9 years" 7 = "10-14 years" 8 = "15-19 years" 9 = "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" ; *CREATE A SAS DATA SET NAMED POP7988 AND STORE IN DIR 'C:\CMF\'; filename piper pipe 'zcat /home/data/cmf_new/pop7988.Z'; DATA CMF.POP7988; *READ IN FILE FROM CD-ROM; INFILE piper 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" ; FORMAT STATE FSTATE. RACESEX RS. AGE MORTAGE. ; proc print data=cmf.pop7988 (obs=20); PROC CONTENTS DATA=CMF.POP7988; PROC FREQ DATA=CMF.POP7988; 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;