topic Re: Date Time format issues in SAS Programming

Date Time format issues

apxprdtr10 — Mon, 21 May 2018 15:20:22 GMT

Hi all,

I have time format as 00:01:00 to 24:00:00 in repetition. when i import the data set i gets automatically converted into some anonymous format. i have 20000 observations and i takes value as same as number of observations. Could anyone tell me why it is happening?

Re: Date Time format issues

art297 — Mon, 21 May 2018 15:56:39 GMT

We'd have to see examples of the data you imported, the code you used, and what you end up getting after importing the data. It's always possible that the import worked correctly and what you're getting are numbers that represent the number of seconds since midnight. If that is the case, you simply need to apply a time format, but your subject line mentions datetime.

Art, CEO, AnalystFinder.com

Re: Date Time format issues

apxprdtr10 — Tue, 22 May 2018 14:48:49 GMT

I really appreciate your reply and i think you didn't understand my question.

Here i once again trying to clear my question.

I am importing a dataset having 'time' variable and format as time.

time

515

620

710

825

1035

and now i want this time variable as

05:15

06:20

07:10

10:35

Thanks.

Re: Date Time format issues

ballardw — Tue, 22 May 2018 15:13:12 GMT

One way assuming the value time is currently numeric:

data want;
   input time  ;
   time = hms(floor(time/100),mod(time,100),0);
   format time tod5.;
datalines;
515
620
710
825
1035
;
run;