QUESTION NO: 24

QUESTION NO: 24  

Given the SAS data set ONE: ONE Obs Dte  

1 09JAN2005 

2 12JAN2005 

 

The following SAS program is submitted: data two; 

set one; 

day = <insert expression here>; 

format dte date9.; 

run; 

The data set TWO is created: 

TWO Obs Dte Day 

1 09JAN2005 1 

12 JAN2005 4 

Which expression successfully completed the program and created the variable DAY? 

 

A. day(dte)  

B. weekday(dte)  

C. dayofweek(dte)  

D. datdif(dte,'01jan2005'd,'act/act')  

Answer: B 

---

Solution : 1 = Sunday , 2 = Monday , ..... 7 = Saturday 

Day = weekday()