topic Proc Sql - get current hour. in Developers

Proc Sql - get current hour.

Samuel_Rocha — Fri, 30 Mar 2012 18:13:22 GMT

Hello!

I´m using a Customer Intelligence 5.4 and i have in a Process Node, into this node i have a "proc sql" i need to filter records per hour, and this hour is in a datetime field.

In SQL I would do as follows: "convert(varchar(2), FIELD, 114)" what would be the equivalent in SAS?

Thanks!!!!!!!!!!

Proc Sql - get current hour.

art297 — Fri, 30 Mar 2012 18:35:20 GMT

Will something like the following suffice?:

data have;

thedate=datetime();

run;

proc sql;

select hour(timepart(thedate))

from have

;

quit;