topic Re: Time in SAS Programming

Reading Time variable from Excel

Phamhhm — Tue, 16 Jan 2018 16:50:45 GMT

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 — Tue, 16 Jan 2018 16:20:40 GMT

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 — Tue, 16 Jan 2018 16:21:30 GMT

Time

Phamhhm — Tue, 16 Jan 2018 16:22:32 GMT

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

Reeza — Tue, 16 Jan 2018 16:27:01 GMT

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 — Tue, 16 Jan 2018 17:00:17 GMT

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

DBMS=xlsx REPLACE OUT=NT;

SHEET='NT';

GETNAMES=YES;

FORMAT Time time5.;

RUN;

Ok now...

Phamhhm — Tue, 16 Jan 2018 17:01:13 GMT

Thanks for your help.

problem is solved

PeterClemmensen — Tue, 16 Jan 2018 17:20:57 GMT

Check out this article