QUESTION NO: 25

QUESTION NO: 25  

Read the table:  

Given the SAS data set SASUSER.HOUSES: 

Obs style bedrooms baths price sqteet street 

1 CONDO 2 1.5 80050 1200 MAIN 

2 CONDO 3 2.5 79350 1300 ELM 

3 CONDO 4 2.5 127150 1400 OAK 

4 CONDO 2 2.0 110700 1100 FIFTH 

5 TWOSTORY 4 3.0 107250 2100 SECOND 

6 TWOSTORY 2 1.0 55650 1600 WEST 

7 TWOSTORY 2 1.0 69250 1450 NORTH 

6 TWOSTORY 4 2.5 102950 2000 SOUTH 

The following SAS program is submitted: proc report data = sasuser.houses nowd headline;

column style price;

 where price It 100000; 

<insert DEFINE statement here> define price / mean width = 9 format = dollar12.; 

title;

run; 

The following output is desired: 

 

style price  

CONDO $79,700 TWOSTORY $62550  

Which DEFINE statement completes the program and produces the desired output?  

A. define style / width = 9,  

B. define style /order width = 9;  

C. define style / group width = 9;  

D. define style / display width = 9;  

Answer: C

---

Solution :

A --> Style 에 대해서 width 만 주기 때문에 Condo 2개 / TWPSTORY 2개 

B --> Condo 요약 / TWOSTORY 요약 ( 각각 1개 ) 

C --> CONDO / TWOSTORY (각각1개씩 이 때 , 평균값이 도출 됨 ) 

D --> display 는 A의 결과값과 같다.