Question

Which of the following FORMAT statements was used to create this output?

Obs---Order_ID----Order_Date----Delivery_Date
1------1230058123----11JAN07----------01/11/07
2------1230080101----15JAN07---------01/19/07
3------1230106883---20JAN07---------01/22/07
4------1230147441----28JAN07---------01/28/07
5------1230315085----27FEB07---------02/27/07

a. format Order_Date date9. Delivery_Date mmddyy8.;
b. format Order_Date date7. Delivery_Date mmddyy8.;
c. format Order_Date ddmmmyy. Delivery_Date mmddyy8.;
d. format Order_Date monyy7. Delivery_Date mmddyy8.;

Answer 1

The FORMAT statement used to create the output with 'Order_Date' as '11JAN07' and 'Delivery_Date' as '01/11/07' is 'format Order_Date date9. Delivery_Date mmddyy8.'.

Step-by-step explanation:

The student has asked which FORMAT statement was used to create a specified output of dates with specific date formats for Order_Date and Delivery_Date.

Looking at the output provided:

• Order_Date format is showing as '11JAN07' which matches the date9. format as it displays dates with a two-digit day, a three-letter abbreviation for the month, and the last two digits of the year.
• Delivery_Date format is showing as '01/11/07' which matches the mmddyy8. format as it displays dates with two digits for the month, two digits for the day, and the last two digits of the year, separated by slashes.

Therefore, the correct answer is:

a. format Order_Date date9. Delivery_Date mmddyy8.