topic Re: Can I get HHMM. formatted output in T test of a time variable? in SAS Procedures

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

strufan — Mon, 29 Oct 2018 18:10:04 GMT

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.

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

PaigeMiller — Mon, 29 Oct 2018 18:14:07 GMT

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

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

strufan — Mon, 29 Oct 2018 18:21:04 GMT

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

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

Reeza — Mon, 29 Oct 2018 18:30:27 GMT

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

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

ballardw — Mon, 29 Oct 2018 23:54:10 GMT

@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.

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

strufan — Fri, 02 Nov 2018 14:14:15 GMT

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