topic Re: how to show seconds format in SAS Programming

how to show seconds format

thanikondharish — Sun, 12 Aug 2018 06:59:34 GMT

data want ;

time='12:12:34't ;

format time time8. ;

run;

proc print data=want ;

format time second. ;

run;

If i run above program it doesn't show the value so what will we do?

Re: how to show seconds format

Kurt_Bremser — Sun, 12 Aug 2018 07:12:12 GMT

Maxim 1 & Maxim 2.

From where do you get the notion that a "second" format exists?

Re: how to show seconds format

Kurt_Bremser — Sun, 12 Aug 2018 07:16:47 GMT

What is a SAS time value?

See here: http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#p1wj0wt2ebe2a0n1lv4lem9hdc0v.htm

This will give you a clue.

Re: how to show seconds format

thanikondharish — Sun, 12 Aug 2018 07:52:35 GMT

i want to show only seconds on output by using proc pirnt

Re: how to show seconds format

Jagadishkatam — Sun, 12 Aug 2018 08:08:47 GMT

we could show the seconds in a new variable using the second function, not sure if we have a format for seconds only

please try the below code which will create a new variable with seconds.

data want ;
time='12:12:34't ;
second=second(time);
run;

Re: how to show seconds format

thanikondharish — Sun, 12 Aug 2018 08:10:22 GMT

i asked
is there any format for second

Re: how to show seconds format

Jagadishkatam — Sun, 12 Aug 2018 08:13:18 GMT

not, as of I remember
but definitely may be if others can help you.

Re: how to show seconds format

error_prone — Sun, 12 Aug 2018 10:01:54 GMT

Do you need the seconds-part from the time-value or the time-value in seconds?

If you need the later: Have you read the documents linked by @Kurt_Bremser?

Re: how to show seconds format

Kurt_Bremser — Sun, 12 Aug 2018 10:23:19 GMT

Once again: read the documentation. Time values ARE seconds, so no special format is needed. If you need to extract the seconds within a minute, use the second() function, or mod(time,60).

Re: how to show seconds format

Ksharp — Sun, 12 Aug 2018 10:59:26 GMT

proc format ;
picture fmt
 low-high='%0s' (datatype=time);
run;



data want ;
time='12:12:34't ;
format time time8. ;
run;
proc print data=want ;
format time fmt. ;
run;

Re: how to show seconds format

Ksharp — Sun, 12 Aug 2018 11:02:07 GMT

proc format ;
picture fmt
 low-high='%0s' (datatype=time);
run;



data want ;
time='12:12:34't ;
format time time8. ;
run;
proc print data=want ;
format time fmt. ;
run;

Re: how to show seconds format

Reeza — Sun, 12 Aug 2018 23:35:42 GMT

@thanikondharish wrote:
i asked
is there any format for second

Time values are stored as seconds, so not having any format will display it in seconds.

Any other format applies a style to it. Similarly, dates as stored as days.

data want;
    time='12:12:34't;
    seconds = 34 + 12*60 + 12*60*60; *to check;
    format time time8.;
run;

title 'With time8 format';

proc print data=want;
    format time time8.;
run;

title 'With no format';

proc print data=want;
    format time;
    ;
run;