1. A raw data file is listed below. 1---+----10---+----20---+--- son Frank 01/31/89 daughter June 12-25-87 brother Samuel 01/17/51 The following program is submitted using this file as input: data work.family; infile 'file-specification'; run; Which INPUT statement correctly reads the values for the variable Birthdate as SAS date values? a. input relation $ first_name $ birthdate date9.; b. input relation $ first_name $ birthdate mmddyy8.; c. input relation $ first_name $ birthdate : date9.; d. input relation $ first_name $ birthdate : mmddyy8.; Correct answ er: d An informat is used to translate the calendar date to a SAS date value. The date values are in the form of two-digit values for month-day-year, so the MMDDYY8. informat must be used. When using an informat with list input, the colon-format modifier is required to correctly associate the informat with the variable name. You can learn about • informats in Reading Date and Time Values • the colon-format modifier in Reading Free-Format Data. 2. A raw data file is listed below. 1---+----10---+----20---+--- Jose,47,210 Sue,,108 The following SAS program is submitted using the raw data file above as input: data employeestats; input name $ age weight; run; The following output is desired: name age w eight Jose 47 210 Sue . 108 Which of the following INFILE statements completes the program and accesses the data correctly? a. infile 'file-specification' pad; b. infile 'file-specification' dsd; c. infile 'file-specification' dlm=','; d. infile 'file-specification' missover; Correct answ er: b The PAD option specifies that SAS pad variable length records with blanks. The MISSOVER option preven...
VIP
