topic Re: Hour Function from datetime not working in SAS Programming

Hour Function from datetime not working

programeerSAS — Fri, 29 Apr 2022 10:08:23 GMT

Running this code :

data electric.blt_hours;
set electric.blt;

Hours = hour(TransDateTime) ;
run;

Here is the property of the datetime field that was read in using proc import with guessing rows option.

Log states:

NOTE: Missing values were generated as a result of performing an operation on missing values.

Each place is given by: (Number of times) at (Line):(Column).

1 at 72:9

NOTE: There were 1 observations read from the data set ELECTRIC.BLT.

NOTE: The data set ELECTRIC.BLT_HOURS has 1 observations and 4 variables.

Not sure why the hour cannot be read if it is a numeric SAS date value it is reading from....

Re: Hour Function from datetime not working

Kurt_Bremser — Fri, 29 Apr 2022 10:17:11 GMT

Your dataset has only one observation, and in this one observation the variable in question contains a missing value. From a missing value, only a missing value can result.

@programeerSAS wrote:

Running this code :

data electric.blt_hours;
set electric.blt;

Hours = hour(TransDateTime) ;
run;

Here is the property of the datetime field that was read in using proc import with guessing rows option.

Log states:

NOTE: Missing values were generated as a result of performing an operation on missing values.

Each place is given by: (Number of times) at (Line):(Column).

1 at 72:9

NOTE: There were 1 observations read from the data set ELECTRIC.BLT.

NOTE: The data set ELECTRIC.BLT_HOURS has 1 observations and 4 variables.

Not sure why the hour cannot be read if it is a numeric SAS date value it is reading from....

Re: Hour Function from datetime not working

Kurt_Bremser — Fri, 29 Apr 2022 10:19:46 GMT

PS from a valid datetime value, the HOUR function returns the hour as documented:

data _null_;
now = datetime();
hours = hour(now);
format now e8601dt19.;
put now= hours=;
run;

Log:

 69         data _null_;
 70         now = datetime();
 71         hours = hour(now);
 72         format now e8601dt19.;
 73         put now= hours=;
 74         run;
 
 now=2022-04-29T12:18:40 hours=12

Re: Hour Function from datetime not working

programeerSAS — Fri, 29 Apr 2022 11:12:28 GMT

Hi Kurt

My blt dataset has many rows of data in it.

This dataset also has just one month of data in it so ultimately I am trying to see when sales are made on each day broken down per hour, hence the first bit of code to extract the hour from the SAS datetime variable.

Re: Hour Function from datetime not working

Kurt_Bremser — Fri, 29 Apr 2022 11:25:05 GMT

@programeerSAS wrote:
Hi Kurt

My blt dataset has many rows of data in it.

Your log says something completely different. I believe SAS in this.

Re: Hour Function from datetime not working

Sajid01 — Fri, 29 Apr 2022 11:58:04 GMT

Can you provide few rows of your data?

Re: Hour Function from datetime not working

PaigeMiller — Fri, 29 Apr 2022 12:02:46 GMT

@programeerSAS

Please provide the ENTIRE log for this DATA step, instead of what you did was just show us pieces of the log. Please copy the log as text and then click on the </> and paste the log into the window that appears.

Re: Hour Function from datetime not working

programeerSAS — Sat, 30 Apr 2022 07:31:11 GMT

Hi Kurt - you were spot on!

I had the table open but a piece of my code messed up the dataset. I re-imported, ran the code as is and voila!

Thank you!