topic TimePart formula error in SAS Visual Analytics

TimePart formula error

DandarahZ — Wed, 23 Oct 2019 03:03:12 GMT

Hello,

I am working on a project that requires me to use a schedule chart. I have 2 variables in a similar format.

1) CLASS START DATE (data format: d/m/yyyy hh:mm)

2) CLASS END DATE ((data format: d/m/yyyy hh:mm)

Part of the project requires me to get the time portion of the data. So naturally, i used this formula below:

to which yielded the desired outcome of only the time portion of the data being displayed as shown below:

However, when trying to apply the same technique/formula to the second variable, Class End Date, the results yielded a different result as below

As shown in the picture below, the values are shown only as 0:00. I went back to the source data to recheck and reconfirm the data format/type but could not find any errors/irregularities.

Regards

Dan

Re: TimePart formula error

Reeza — Wed, 23 Oct 2019 02:31:33 GMT

What's the type/format on your original variable?

Re: TimePart formula error

DandarahZ — Wed, 23 Oct 2019 02:41:51 GMT

Hello,

i seem to have made a mistake while writing the question, I have re-edited the question and I hope you will take a look at it again.

As i described above, the format of the data is in the (dd/mm/yyyy hh:mm) format

Regards

Dan

Re: TimePart formula error

Reeza — Wed, 23 Oct 2019 04:16:04 GMT

That's what your data looks like, but it could be character variable or a numeric value with a format and those are different to deal with.

Re: TimePart formula error

DandarahZ — Wed, 23 Oct 2019 09:53:40 GMT

Found the error through this advice. Thank you!

Regards

Dan