topic Re: Can we do the same in SAS in SAS Procedures

Can we do the same in SAS

sravanpathu — Tue, 22 Jan 2013 15:42:55 GMT

Dear ALL,

value	time
0.00036548	0:00:32
0.0022222	0:03:12
0.0005	0:00:43

In the above table i got value column after so many calculations.

In time column i just applied time format in excel can we do the same in sas.

Used excel format 37:30:55.

Please help me its urgent for me.

Regards,

Sravan

Re: Can we do the same in SAS

Florent — Tue, 22 Jan 2013 15:55:16 GMT

Hi Sravan,

Is this what you want to achieve ?

data want;

set have;

format time tod8.;

time = value * 86400;

run;

Kr,

Florent

Re: Can we do the same in SAS

Tom — Tue, 22 Jan 2013 15:58:23 GMT

SAS stores time as the number of seconds since midnight. Excel is storing it as a fraction of a day. So to convert your variable VALUE to a variable that you could treat as time in SAS you need to mulitply by 24 hours.

66 data want ;

67 input value time time. ;

68 time2 = value*'24:00:00't ;

69 format time time2 time.;

70 put (_all_) (=);

71 cards;

value=0.00036548 time=0:00:32 time2=0:00:32

value=0.0022222 time=0:03:12 time2=0:03:12

value=0.0005 time=0:00:43 time2=0:00:43

Re: Can we do the same in SAS

Jagadishkatam — Tue, 22 Jan 2013 16:03:18 GMT

Just another way

data want;

input value time time8.;

format time time8.;

cards;

0.00036548 0:00:32

0.0022222 0:03:12

0.0005 0:00:43

;

proc print;

run;

Thanks,

Jagadish

Re: Can we do the same in SAS

Florent — Tue, 22 Jan 2013 16:07:22 GMT

I think he wanted to know how to create the 'time' variable from the 'value' variable instead of reading both. Your example is just reading values, there is no calculation.

Regards,

Florent

Re: Can we do the same in SAS

sravanpathu — Wed, 23 Jan 2013 16:39:05 GMT

Thank every one i got my answer.

Once again thanks a lot.

Regards,

Shraz's