SAS BASE Q78. infile

QUESTION NO: 78

Given the following raw data records in DATAFILE.TXT:

Kim,Basketball,Golf,Tennis

Bill,Football

Tracy,Soccer,Track

 

The following program is submitted:

data WORK.SPORTS_INFO;

length Fname Sport1-Sport3 $ 10;

infile 'DATAFILE.TXT' dlm=',';

input Fname $ Sport1 $ Sport2 $ Sport3 $;

run;

 

proc print data=WORK.SPORTS_INFO;

run;

 

Which output is correct based on the submitted program?

 

A. Obs Fname Sport1 Sport2 Sport3

1 Kim Basketball Golf Tennis

2 Bill Football

3 Tracy Soccer Track

 

B. Obs Fname Sport1 Sport2 Sport3

1 Kim Basketball Golf Tennis

2 Bill Football Football Football

3 Tracy Soccer Track Track

 

C. Obs Fname Sport1 Sport2 Sport3

1 Kim Basketball Golf Tennis

2 Bill Football Tracy Soccer

 

D. Obs Fname Sport1 Sport2 Sport3

1 Kim Basketball Golf Tennis

2 Bill Football

 

 

Answer: C

# 문제 풀이

 - Kim,Basketball,Golf,Tennis는 정상적으로 입력이 된다.

 - Bill,Football가 입력 된 후, 나머지 자리에 Tracy,Soccer가 입력된다. 

 - 남은 Track은 버려진다.