topic Re: Evolution in SAS Visual Analytics

Evolution

Fox01 — Mon, 13 Jun 2022 17:36:31 GMT

Hello,

I need to calcule the difference between 2 durations :

D1 = 02:26 ( hh:mm)

D2= 03:07 ( hh:mm)

I tried to created a calcuated item like this : D1- D2 but it doesn't return any value.

Do you have any idea please ?

Thank you in advance

Re: Evolution

ballardw — Mon, 13 Jun 2022 20:53:14 GMT

Show us the description of your data.

If you "time" values are character then subtraction will not work and you need to convert them to numeric time values.

Dare I ask what your LOG showed from attempting that subtraction?

Re: Evolution

Fox01 — Mon, 13 Jun 2022 18:02:35 GMT

The " time " values are not character

The 2 duractions are calculated items which the type is numeric and the format is hhmm5.

I don't have any error message just a . like this

I tried to change time to numeric but the problem is the same

Re: Evolution

MarkusWeick — Mon, 13 Jun 2022 18:29:55 GMT

Hi @Fox01,

in similar situation I applied the advanced numeric operator "treatAs" to treat the durations as numeric.

Maybe it helps.

Best

Markus

Re: Evolution

MarkusWeick — Mon, 13 Jun 2022 18:31:44 GMT

Hi @Fox01

and please have a look at the calculations with the durations in

Solved: Median duration with conditions - SAS Support Communities

Maybe it gives you some ideas to try.

Best Markus

Re: Evolution

Fox01 — Mon, 13 Jun 2022 18:51:58 GMT

Hi @MarkusWeick,

I tried treatas but the probleme is the same

Re: Evolution

MarkusWeick — Mon, 13 Jun 2022 19:44:23 GMT

Hi @Fox01,

sorry, but I don't have any ideas anymore.

Best Markus

Re: Evolution

BrunoMueller — Mon, 13 Jun 2022 20:10:28 GMT

Please show the expression you are using to calculate the difference. Also a screenshot from the two durations with the properties would help

Re: Evolution

Fox01 — Tue, 14 Jun 2022 07:04:29 GMT

Hi @BrunoMueller

Duration 1:

with aggregation as median

Duration 2 :

with aggregation as median.

The expression I am using to calculate the difference is :

duration 1 - duration 2

Thanks for your help.

Re: Evolution

BrunoMueller — Tue, 14 Jun 2022 07:59:33 GMT

I can see that if the condition is false you return missing, can you show what the preview button displays, when you do the calculation d1 - d2, maybe all the values are missing

Re: Evolution

MarkusWeick — Tue, 14 Jun 2022 08:09:30 GMT

Hi @Fox01,

remember you are not subtracting single values, but whole columns.

And the two columns (duration 1, duration 2) are defined in a way, that for each row one of the columns has the value "missing".

Best

Markus

Re: Evolution

Fox01 — Tue, 14 Jun 2022 08:20:31 GMT

Hi @MarkusWeick,

In this case, how can I calculate the difference between Duration 1 and Duration 2 ?

Thanks for your help

Re: Evolution

BrunoMueller — Tue, 14 Jun 2022 08:50:08 GMT

I suggest you show us what your data looks like and what you want to achieve.

Re: Evolution

MarkusWeick — Tue, 14 Jun 2022 08:50:58 GMT

Hi @Fox01,

you could define additiona calculated items for Duration1 and Duration2 each.

There you could use the "mean"-Operator (to be found under "aggregate simple") to define columns which contain the mean:

Re: Evolution

Fox01 — Tue, 14 Jun 2022 09:08:26 GMT

Thank you very much ! It's working