Reading Time variable from Excel

[Phamhhm]

Hi

I have a column in excel, variable : Time with HH:MM

I am trying to import in SAS, but my Time variable gives 0.333333....

I am trying to convert it :

DATA NT;

SET NT;

Time = input(Time, time5.);

FORMAT Time time5.;

RUN;

I have a new blank column Time in SAS.

Thanks for you answers !

[Reeza]

Don't use the same data set name in your DATA and SET statement, it makes it really hard to trace your errors. 

Can you show what your data looks like before you did your conversion?

[Phamhhm]

Time

[Phamhhm]

Time:  8:00 8:15 8:30 ... 18:00 in Excel

[Reeza]

What did it look like when you imported the data into SAS?

What was the type and format of the variable?

Did you try applying a format rather than doing a conversion?

[Phamhhm]

Thanks for your help.

problem is solved

[Phamhhm]

PROC IMPORT DATAFILE="\\........\Name.xlsx"

DBMS=xlsx REPLACE OUT=NT;

SHEET='NT';

GETNAMES=YES;

FORMAT Time time5.;

RUN;

Ok now...

[PeterClemmensen]

Check out this article

http://www2.sas.com/proceedings/sugi29/068-29.pdf