topic Hour is next largest hour when extracting hour from datetime in SAS Procedures

Hour is next largest hour when extracting hour from datetime

deleted_user — Wed, 16 Feb 2011 17:28:02 GMT

I have a datetime from which I would like to extract hour in a new column in the data set. For datetime values greater than 30minutes past the hour, the hour is reported as the next largest hour. Why is this happening and how do I fix it? Below is my code and the resulting output. NOTE: I also used time=timepart(timestamp); format time hour.; with the same result.

Tiffanie

data hours;
set periods;
hour=timepart(timestamp);
format hour hour. ;
run;

timestamp, hour
01MAY2010:15:45:00, 16
01MAY2010:16:16:00, 16
01MAY2010:16:38:00, 17

Re: Hour is next largest hour when extracting hour from datetime

sbb — Wed, 16 Feb 2011 17:38:16 GMT

You have other options though you must consider the SAS DOC for HOUR format and the caveat note about "...rounding...".

If not suitable, consider using the HOUR function to extract the hour-portion and display it separately.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

hour format site:sas.com

DOC reference below:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000198051.htm

Excerpt below:
Details

SAS rounds hours based on the value of minutes in the SAS time value.

The HOUR format uses asterisks to format values that are outside the time range 0-24 hours, such as datetime values.

Re: Hour is next largest hour when extracting hour from datetime

Peter_C — Thu, 17 Feb 2011 16:40:06 GMT

since it rounding try
hour= floor( mod( datetime_value, 3600 ) /3600 ) ;
(datetime values are a number of seconds)

Re: Hour is next largest hour when extracting hour from datetime

deleted_user — Thu, 17 Feb 2011 21:05:23 GMT

Thank you, Scott. I failed to read the literature before posting. Here's how I fixed it:

data hours;
set periods;
hour=hour(timestamp);
run;