Example 9.11 Creating SAS Datetime Values and Computing the Difference between Two Datetime Values
Create a new variable that contains a SAS datetime value by combining SAS date values and SAS time values. Compute the difference in hours between two datetime values.
|Featured Step||DATA step|
|Featured Step Options and Statements||DHMS, INTCK, and MDY functions|
Input Data Set
Data set OCT2009_ORDERS contains order placement and shipment information about eight orders. The orders were placed in October 2009, and only the day of the month was recorded. The shipment date and shipment hour were recorded.
OCT2009_ORDERS order_ order_ ship_ Obs customerid orderid day time ship_date hour 1 XXV0NW C10761 22 23:04 10/24/2009 7 2 5MY0CJ ...