SAS Certified Base Programmer 50 Questions (2)
A raw data file is listed below.
1---+----10---+----20---+ Jose,47,210 Sue,,108
The following program is submitted using the raw data file above as input:
data employeestats;
<insert INFILE statement here>
input name $ age weight;
run;
The following output is desired:
name age weight Jose 47 210 Sue . 108
Which of the following INFILE statement 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;
Topics:
SAS Base Questions |
3 Comments »
B
None of the option is correct.
However option C will display the result if and only if there is a space between two comma in the second row. This needs to be “Sue, ,108”.
Answer is C since the Data is Comma seperated file.