topic Convert seconds in minutes in SAS Procedures

Convert seconds in minutes

11205213 — Sun, 30 Sep 2018 18:27:32 GMT

Hey,
I would like to convert seconds (as 1897 seconds) in a minutes format (not hours).

Can you help me please ?
Thank !!

Kurt_Bremser — Sun, 30 Sep 2018 18:43:19 GMT

Divide by 60.

If you want to display seconds as minutes, use the mmss. format.

PeterClemmensen — Sun, 30 Sep 2018 18:49:55 GMT

data _null_;
   sec=1897;
   format sec mmss.;
   put sec;
run;

11205213 — Sun, 30 Sep 2018 18:52:58 GMT

I just want to create a new variable (column) which will convert one existing variable in seconds in minutes

PeterClemmensen — Sun, 30 Sep 2018 18:54:34 GMT

In that case

data _null_;
   sec=1897;
   min=sec/60;
   put sec= min=;
run;

11205213 — Sun, 30 Sep 2018 18:56:24 GMT

But : 1789 seconds / 60 = 29.82 minutes which is not in a good format

Kurt_Bremser — Sun, 30 Sep 2018 19:33:47 GMT

@11205213 wrote:

But : 1789 seconds / 60 = 29.82 minutes which is not in a good format

If you want those .82 m displayed as seconds, use the mmss. format, as already advised.

11205213 — Sun, 30 Sep 2018 19:35:03 GMT

OK thank you very much !