topic Re: How to do the format Time value in SAS Procedures

How to do the format Time value

ursula — Fri, 01 Feb 2013 18:32:54 GMT

I tried to do a math of the Elapstime, for example: Time_pickup =15:00 and Time_received=15:36, so the Elapstime will be Time_received - Time_pickup.

the result is not showing the time value, like 0:36 instead 2160.

does any one know what is the 'Time Format' is?

thank you.

Re: How to do the format Time value

AncaTilea — Fri, 01 Feb 2013 18:57:26 GMT

Try this:

format Elapstime time5.;

Good luck.

Anca.

Re: How to do the format Time value

ursula — Fri, 01 Feb 2013 19:01:33 GMT

thank you so much, Anca, it's very helpful.

Re: How to do the format Time value

ursula — Fri, 01 Feb 2013 22:01:22 GMT

Another problem is, when I got the Elapsed_time fixed, but, when I run it in proc means, it came back as a long number again instead of like 0:35.

Do you know how to fix it?

thanks,

Re: How to do the format Time value

Linlin — Fri, 01 Feb 2013 23:17:25 GMT

data have;

input time;

cards;

2160

2161

2162

2163

;

proc means data=have mean noprint;

var time;

format time time5.;

output out=temp(drop=_:) mean=mean;

run;

proc print data=temp;run;

Obs mean

1 0:36

Re: How to do the format Time value

ursula — Fri, 01 Feb 2013 23:42:03 GMT

thank you very much.

do you mind to explain to me what is the "output out=temp(drop=_:) mean= mean" means?

thank you.

Re: How to do the format Time value

Linlin — Sat, 02 Feb 2013 00:17:01 GMT

You are welcome!

"output out=" creates a dataset," (drop=_:)" drop all the variables begin with _. "mean=mean" names the calculated mean mean.

you may understand better by running the modified code below:

data have;

input time;

cards;

2160

2161

2162

3863

;

proc means data=have mean noprint;

var time;

format time time5.;

output out=new_dataset /* temp(drop=_:)*/ mean=aaa /*mean*/;

run;

proc print data=new_dataset;run;

Obs _TYPE_ _FREQ_ aaa

1 0 4 0:43

Re: How to do the format Time value

ursula — Sat, 02 Feb 2013 00:39:53 GMT

Thank you again, Have a great weekend!