Evolution

[Fox01]

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

[ballardw]

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?

[Fox01]

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 

[MarkusWeick]

Hi @Fox01,

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

Maybe it helps.

Best

Markus

[MarkusWeick]

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

[Fox01]

Hi @MarkusWeick,

I tried treatas but the probleme is the same 

[MarkusWeick]

Hi @Fox01,

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

Best Markus

[BrunoMueller]

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

[Fox01]

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.

[BrunoMueller]

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

[MarkusWeick]

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

[Fox01]

Hi @MarkusWeick,

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

Thanks for your help 

[BrunoMueller]

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

[MarkusWeick · Accepted solution]

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:

[Fox01]

Thank you very much ! It's working