How to do the format Time value

[ursula]

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.

[AncaTilea]

Try this:

   format Elapstime time5.;

Good luck.

Anca.

[ursula]

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

[ursula]

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,

[Linlin]

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

[ursula]

thank you very much.

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

thank you.

[Linlin]

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

[ursula]

Thank you again, Have a great weekend!