topic Re: how to export time to excel with mm:ss format in ODS and Base Reporting

how to export time to excel with mm:ss format

daisy6 — Fri, 09 Feb 2018 17:25:26 GMT

Hi SAS helpers,

I need to output some data storing in SAS as seconds to excel file by using ODS excel proc report.

If the data in sas are numbers and when I output to excel, I need the data format like MM:SS.

my SAS data output to excel

22 0:22 or 00:22

35 0:35 or 00:35

216 3:36 or 03:36

21 0:21 or 00:21

How do I format the data?

I used

proc report data=outtable nowd;

column ("time" meant stdt);

define meant/center display "Mean of Time" format=time. (or time8.);

define stdt/center display "SD of Time" format=time. (or time8.);

run;

Then I got the excel output results like:

my SAS data output to excel

22 00 :00:22

35 00:00:35

216 00:03:36

21 00:00:21

But that is not what I want. Could anybody help me out? Thanks for any suggestion.

Re: how to export time to excel with mm:ss format

Reeza — Fri, 09 Feb 2018 17:47:14 GMT

Look up TAGATTR to see how to set the time in the Excel format required.

@daisy6 wrote:

Hi SAS helpers,

I need to output some data storing in SAS as seconds to excel file by using ODS excel proc report.

If the data in sas are numbers and when I output to excel, I need the data format like MM:SS.

my SAS data output to excel

22 0:22 or 00:22

35 0:35 or 00:35

216 3:36 or 03:36

21 0:21 or 00:21

How do I format the data?

I used

proc report data=outtable nowd;

column ("time" meant stdt);

define meant/center display "Mean of Time" format=time. (or time8.);

define stdt/center display "SD of Time" format=time. (or time8.);

run;

Then I got the excel output results like:

my SAS data output to excel

22 00 :00:22

35 00:00:35

216 00:03:36

21 00:00:21

But that is not what I want. Could anybody help me out? Thanks for any suggestion.

Re: how to export time to excel with mm:ss format

daisy6 — Fri, 09 Feb 2018 19:29:51 GMT

Hello, I already solved that problem by using format=mmss. instead of format=time8..

Thank you for the reply, Reeza