Proc Sql - get current hour.

[Samuel_Rocha]

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!!!!!!!!!!

[art297]

Will something like the following suffice?:

data have;

  thedate=datetime();

run;

proc sql;

  select hour(timepart(thedate))

    from have

  ;

quit;