Exam A00-211 All QuestionsBrowse all questions from this exam
Question 32

Given the following raw data records:

The following output is desired:

Which SAS program correctly reads in the raw data?

    Correct Answer: D

    To achieve the desired output in SAS, the raw data needs to be read in correctly using the appropriate options in the INFILE statement. The 'dlm' option with '*' is necessary to specify that the delimiter between fields is an asterisk (*). The 'dsd' option is essential to handle the missing values correctly by treating consecutive delimiters as missing values rather than using the default behavior. The ':' symbol in the INPUT statement is important for SAS to understand that the variable should be read in with an informat, which is necessary for handling the date format (mmddyy10.) used in the bdate field. Therefore, the correct program is option D, which incorporates all these necessary components.

Discussion
Misty2287

I do not understand the use of a ":" symbol in the input statement. Do you know?