Can I get HHMM. formatted output in T test of a time variable?

[strufan]

I am performing a t-test on two time intervals. The variables are formatted HHMM.
The output displays as the unformatted SAS time:

time Mean
No 14859.2 
Yes 28801.9

is there a way to get SAS to display the output in HHMM. format, so that the output would look like (and read as time, as in "4 hours and 7 minutes"):

time Mean
No 4:07 
Yes 8:00

I'd rather not have to redo it by hand every time if possible. I have tried the FORMAT option on t-test but it had no effect.

Thank you for any ideas.

[PaigeMiller]

Assign the format in the data step before PROC TTEST. Or use a format statement in PROC TTEST (note: I have not tried this)

[strufan]

The time variables are formatted in the data step. The FORMAT statement in PROC TTEST has no effect, unfortunately.

[Reeza]

I think you are stuck reformatting at the end or modifying the template but then it's modified for all t-tests.

[ballardw · Accepted solution]

---

@strufan wrote:
The time variables are formatted in the data step. The FORMAT statement in PROC TTEST has no effect, unfortunately.

---

Send output from Proc Ttest into dataset(s). Then use one of the report procedures, Proc Print, Report or Tabulate to display the result where you have more control.

[strufan]

Thanks. I was hoping to avoid that, but it actually was not too difficult with ODS OUTPUT.