Sentry Page Protection

Please Wait...

Variable Attributes [12-17]

---

Date & Time Format

In the last session, we introduce you the (YYMMDD10.) format. 

In fact, there are some other date formats that are commonly used in SAS:

• YYMMDD10.
• Date9.
• Date7.
• MMDDYY10.

Example

Data DFmt; Input Date1 Date2 Date3 Date4; Datalines; 12001 12001 12001 12001 12002 12002 12002 12002 12003 12003 12003 12003 12004 12004 12004 12004 12005 12005 12005 12005 12006 12006 12006 12006 12007 12007 12007 12007 12008 12008 12008 12008 12009 12009 12009 12009 12010 12010 12010 12010 ; Run;

The DFMT data set above contains Date1, Date2, Date3 and Date4. 

Each date contains an identical set of data.

Now, I'm going to assign the following formats to each of the date variables:

• Date1: YYMMDD10.
• Date2: Date9.
• Date3: Date7.
• Date4: MMDDYY10.

Example

Data DFmt2;
Set DFmt;
Format Date1 YYMMDD10.
       Date2 Date9.
       Date3 Date7.
       Date4 MMDDYY10.;
Run;

(YYMMDD10.) = 1992-11-09
(Date9.)    = 09NOV1992
(Date7.)    = 09NOV92
(MMDDYY10.) = 11/09/1992


Time Format

The two common time formats are:

• Time5. (00:00)
  
• Time8. (00:00:00)

Example

Data TFmt; Input Time1 Time2; Datalines; 36001 36001 39001 39001 42001 42001 45001 45001 48001 48001 51001 51001 54001 54001 57001 57001 60001 60001 63001 63001 ; Run;

In the TFMT data set, the two time variables contain a set of identical time values.

Now, let's apply the two time formats to Time1 and Time2. 

Example

Data TFmt2;
Set TFmt;
Format Time1 Time5.
       Time2 Time8.;
Run;

---

Exercise

Data Attendance; Input EmpID $ Date In Out; Datalines; ID501 20010 28800 61200 ID502 20010 30400 63200 ID503 20010 29800 61800 ID504 20010 33600 61700 ID505 20010 27800 60200 ID506 20010 29400 61900 ID507 20010 29300 61850 ID508 20010 31600 62930 ID509 20010 32400 62300 ID510 20010 31200 61590 ; Run;

The ATTENDANCE data set contains 4 variables:

• EmpID: Employee ID
  
• Date: Date of Attendance
  
• In: Time arriving the office
  
• Out: Time departing the office
  

The date and time variables are not formatted properly.

Tasks
1. Format the Date and Time variables with the proper formats. 
2. An employee is considered late if they arrive after 9 a.m. Find out which employee is late.

Next

---

Need some help? 

---

Fill out my online form.

---