73.EXTRACTION OF HOUR | MINUTE

Function: HOUR

Purpose: To extract the hour from a SAS datetime or time value.

Syntax: HOUR(time or dt)

Function: MINUTE

Purpose: To extract the minute value from a SAS datetime or time value.

Syntax: MINUTE(time or dt)

Function: SECOND

Purpose: To extract the second value from a SAS datetime or time value.

Syntax: SECOND(time or dt)

Syntax:

data time;

DT = '01jan1960:7:15:30'dt;

Hour_dt = hour(DT);

Minute_dt = minute(DT);

Second_dt = second(DT);

T = '12:05:23't;

Hour_time = hour(T);

Minute_time = minute(T);

Second_time = second(T);

*format DT datetime. T time.;

run;

title "Listing of Data Set TIME";

proc print data=time noobs heading=h;

run;

OUTPUT:

Without Format Output:

Listing of Data Set TIME

DT	Hour_dt	Minute_dt	Second_dt	T	Hour_time	Minute_time	Second_time
26130	7	15	30	43523	12	5	23

With Format Output:

Listing of Data Set TIME

DT	Hour_dt	Minute_dt	Second_dt	T	Hour_time	Minute_time	Second_time
01JAN60:07:15:30	7	15	30	12:05:23	12	5	23

TRY THIS AND COMMENT ...

-->PLEASE READ AND COMMENT THE BLOG...

--PLEASE FOLLOW THE BLOG FOR MORE UPDATES...

--FOLLOW US IN FACEBOOK SASALL4YOU AND JOIN ...

--JOIN US IN FACEBOOK AND TELEGRAM CHANNEL FOR MORE UPDATES

Sas All