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

Given the following raw data record:

----I----10---I----20---I----30

son Travis,

The following output is desired:

Obs relation firstname -

1 son Travis

Which SAS program correctly reads in the raw data?

    Correct Answer: D

    To achieve the desired output, the correct SAS program needs to properly handle the input file and specify the delimiter for the fields. In this case, the delimiter is a comma. Also, the appropriate usage of the delimiter property within the 'infile' statement is crucial. Option D correctly places the delimiter property in the 'infile' statement, ensuring that the raw data is read properly into the variables 'relation' and 'firstname' as desired.

Discussion
Mouni_18Option: C

The correct Answer is data family; infile 'file specification' dlm=' ,'; input relation$ firstname$ ; run; Here we also add 'space' as delimiter with 'comma' then we get the output. So we choose Option C as correct. Because we can write this program similar to option C only.

Mouni_18Option: C

The correct answer is data family; infile 'file specification'; input relation$ firstname$ ; run; Here 'dlm' is not needed because ',' is given at the end not in between variables. I tried to Run this program with Option C output comes Error.

Anusha_91Option: B

If we mention dlm as ',' then son Travis will be taken under single variable. Can someone please make me understand the answer