CustNo t1 t2 t3 t4 t_date t_time

35995 0 0 0 300 2008152 4159
35995 0 0 0 303 2008152 4159
35995 20 0 120 226 2008152 8849
35995 0 0 0 0 2008152 9080
35995 1 0 2 5 2008152 9075
35995 0 0 0 0 2008152 9081
35995 0 0 0 232 2008152 8849

These are transactions from transaction log generated by the
application. The t_date is in "julian date" format and i would like to
convert into "MM/DD/YY format" and combine t_date & t_time into one
col.

Also, t1,t2,t3,t4 col are filled in a 24 hr frame so would like these
to be sum per date. How do I do all these in one macro.