BookmarkSubscribeRSS Feed

SAS Ceritified Advanced Programmer 덤프 풀이 31-32

Started ‎06-15-2020 by
Modified ‎06-15-2020 by
Views 96

31. The following are values of the variable STYLE from the SAS data set

SASUSERS.HOUSES

OBS STYLE

--------------------

1 RANCH

2 SPLIT

3 CONDO

4 TWOSTORY

5 RANCH

6 SPLIT

7 SPLIT

The following SAS program is submitted:

proc sql noprint;

select distinct style

into :styles separated by ' '

from sasuser.houses

order by style;

quit;

Which one of the following is the value of the resulting macro variable?

A. CONDO RANCH SPLIT TWOSTORY

B. RANCH SPLIT CONDO TWOSTORY

C. CONDO RANCH RANCH SPLIT SPLIT SPLIT TWOSTOR Y

D. RANCH SPLIT CONDO TWOSTORY RANCH SPLIT SPLIT

정답 : A

해설 : PROC SQL 결과물을 묻는 문제입니다. 자주 출제되는 유형입니다. 우선 DISTINCT는 SELECT와 함께 사용되는 중복제거 옵션입니다. 그리고 밑에 Order by로 오름차순 정렬해 준 것을 볼 수 있네요. 간단히 A라는 것을 알 수 있습니다. 

 

 

 

32. The following SAS program is submitted:

proc contents data = testdata.one;

run;

Which one of the following SQL statements produces similar information about the column attributes

as the above CONTENTS procedure?

A. proc sql;

show testdata.one;

quit;

B. proc sql;

describe testdata.one;

quit;

C. proc sql;

show table testdata.one;

quit;

D. proc sql;

describe table testdata.one;

quit;

정답 : D

해설 : PROC CONTENTS와, SQL의 비슷한 기능을 묻고 있습니다. PROC CONTENTS는

•general and summary information

•engine/host dependent information

•alphabetic list of variables and attributes

•alphabetic list of integrity constraints

•alphabetic list of indexes and attributes

다음과 같은 내용을 출력합니다 (교 재 455 참고)

PROC SQL에서 DECRIB TABLEE문은 테이블 구조와 정보를 출력합니다. (교재 173 참고) DESCRIBE TABLE이 같이 쓰여져야하므로 정답은 D입니다. 

Version history
Last update:
‎06-15-2020 04:07 AM
Updated by:
Contributors

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Article Labels
Article Tags