DHMS function returning 00:00 for hours and minutes. 

My date and time inputs are from an Oracle table and both are Number values. 
I’m trying to combine the two values to create a date time value. 
I can create an Auth\_DT (DDMONYYYY) and Auth\_Tm (HH:MM:SS). 
When I try to use DHMS to create an Auth Date Time the hours and minutes appear as 00:00,
but the seconds are correct.

I appreciate any help with the errors in my code.  

Thank you in advance for any help. 

```
data dates;
Auth_Date = 20120915; 
Auth_Time = 23324; 
run;

Proc SQL;
Create table mark as 
Select 
AUTH_DATE, 
input(put(AUTH_DATE,8.),yymmdd8.) as AUTH_DT format=Date9. ,
AUTH_TIME, 
input(put(AUTH_TIME,6.),hhmmss6.) as AUTH_TM format=TOD8. ,
Input(Substr( put(Auth_Time,z6.),1,2),2.) as HR ,
Input(Substr( put(Auth_Time,z6.),3,2),2.) as MIN , 
Input(Substr( put(Auth_Time,z6.),5,2),2.) as SEC ,
DHMS((input(put(AUTH_DATE,8.),yymmdd8.))  
,HOUR(Input(Substr( put(Auth_Time,z6.),1,2),2.)) 
,MINUTE(Input(Substr( put(Auth_Time,z6.),3,2),2.)) 
,SECOND(Input(Substr( put(Auth_Time,z6.),5,2),2.))) as Auth_DTTM Format = datetime20. 
From work.Dates;
Quit;

```

Auth\_Date AUTH\_DT Auth\_Time AUTH\_TM HR MIN SEC Auth\_DTTM
20120915 15SEP2012 23324 02:33:24 2 33 24 15SEP2012:00:00:24