SAS BASE Q13. read data & dlm [수정]
QUESTION NO: 13
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?
A. data family (dIm = ','); infile 'tile specification'; input relation $ firstname $; run;
B. options dIm = ','; data family; infile 'file specification'; input relation $ firstname $; run;
C. data family; infile 'file specification' dIm = ','; input relation $ firstname $; run;
D. data family; infile 'file specification'; input relation $ firstname $ / dlm = ','; run;
Answer: C
# 문제 해석
- son Travis, -> son , Travis
# 문제 풀이
- dlm : 구분자
- 파일을 불러오는 단계(infile)에서 dlm을 적용시켜야 한다.
- 만약 raw data가 son/Travis라면 dlm='/'로 해야한다.