DM 'CLE LOG; CLE OUT'; ************************************************************************** April 30, 2007 THIS IS AN EXAMPLE OF A SAS PROGRAM THAT CREATES A SAS FILE FROM THE NHIS 1994 OUTCOMEP.DAT ASCII FILE. NOTE: THE FORMAT DEFINITIONS GIVEN BELOW WILL RESULT IN PROCEDURE OUTPUT SHOWING VALUES THAT HAVE BEEN GROUPED AS THEY ARE SHOWN IN THE FILE LAYOUT DOCUMENTATION. THIS IS STORED IN OUTCOMEP.SAS *************************************************************************; * USER NOTE: PLACE NEXT TWO STATEMENTS IN SUBSEQUENT PROGRAMS; LIBNAME NHIS 'C:\NHIS1994\'; LIBNAME LIBRARY 'C:\NHIS1994\'; FILENAME ASCIIDAT 'C:\NHIS1994\OUTCOMEP.DAT'; * DEFINE VARIABLE VALUES FOR REPORT; PROC FORMAT LIBRARY=LIBRARY; VALUE OCM001X 62 = "Polio Outcome" ; VALUE OCM002X 94 = "1994" 95 = "1995" ; VALUE $OCM003X ; VALUE $OCM004X ; VALUE OCM005X 01 = "Interview" 02 = "Never had polio" 03 = "SP deceased" 04 = "Ineligible other" 05 = "SP temporarily absent" 06 = "Unable to contact/locate" 07 = "SP moved - not located" 08 = "Institutionalized or incapable; no proxy available" 09 = "Refusal" 10 = "Unknown" . = "Not eligible for Polio" ; DATA NHIS.OUTCOMEP; * CREATE A SAS DATA SET STORED IN DIR 'C:\NHIS1994\'; INFILE ASCIIDAT MISSOVER TRUNCOVER LRECL=18; * DEFINE LENGTH OF NUMERIC VARIABLES; LENGTH RECTYPE 3 YEAR 3 OP_17 3 ; * INPUT ALL VARIABLES; INPUT RECTYPE 1 - 2 YEAR 3 - 4 HHID $ 5 - 14 PNUM $ 15 - 16 OP_17 17 - 18 ; * DEFINE VARIABLE LABELS; LABEL RECTYPE = "RECORD TYPE" YEAR = "PROCESSING YEAR" HHID = "HOUSEHOLD IDENTIFICATION NUMBER" PNUM = "PERSON NUMBER" OP_17 = "OUTCOME CODE" ; * ASSOCIATE VARIABLES WITH FORMAT VALUES; FORMAT RECTYPE OCM001X. YEAR OCM002X. HHID $OCM003X. PNUM $OCM004X. OP_17 OCM005X. ; PROC CONTENTS DATA=NHIS.OUTCOMEP; PROC FREQ DATA=NHIS.OUTCOMEP; TITLE1 'FREQUENCY REPORT FOR 1994 NHIS DISABILITY POLIO OUTCOME FILE'; TITLE2 '(UNWEIGHTED)'; TABLES RECTYPE/LIST MISSING; * USER NOTE: TO SEE UNFORMATTED VALUES IN PROCEDURES, ADD THE STATEMENT: FORMAT _ALL_; RUN;