Solved: Re: Median duration with conditions

Betty_sam · Posted 06-09-2022 05:45 AM

Hi,

I would like to calculate the median duration for d-1 excluding flag=0.

I don't want to use the filter in the menu for the date and the flag.

Any help please ?

Thanks in advance.

MarkusWeick · Posted 06-10-2022 03:19 AM

Hi @Betty_sam,

if you really just want to have the median for “today-1”, there is way:

You could create a calculated item, which contains values only for yesterdays durations with flag = 1:

(To get the "Missing" into the ELSE-cell you have to insert a dot ".")

For this column then you set the format to “elapsed time” and the aggregation to “median”:

With a list table with the new column as only column you get the following result:

Does this meet your requirements?

Best

Markus

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles

View solution in original post

MarkusWeick · Posted 06-09-2022 05:56 AM

Hi @Betty_sam,

could you please add some sample data and your VA version number?

Best

Markus

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles

Betty_sam · Posted 06-09-2022 08:34 AM

Hi @MarkusWeick,

I am using SAS VA 8.5.2 , SAS VIYA 03.05

Here is some simple data :

Thanks

MarkusWeick · Posted 06-09-2022 08:42 AM

Hi @Betty_sam,

another question: what do you mean with "d-1"?

Best

Markus

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles

Betty_sam · Posted 06-09-2022 08:48 AM

today-1 , in this example it will be 08/06/2022

MarkusWeick · Posted 06-09-2022 10:12 AM

Hi @Betty_sam,

I had been workung with the Aggregated Operators in Calculated Items lately (though in VA 7.5) and hoped to find a solution using these. But it didn't work. Sorry!

Best Markus

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles

MarkusWeick · Posted 06-10-2022 03:19 AM

Hi @Betty_sam,

if you really just want to have the median for “today-1”, there is way:

You could create a calculated item, which contains values only for yesterdays durations with flag = 1:

(To get the "Missing" into the ELSE-cell you have to insert a dot ".")

For this column then you set the format to “elapsed time” and the aggregation to “median”:

With a list table with the new column as only column you get the following result:

Does this meet your requirements?

Best

Markus

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles

Betty_sam · Posted 06-10-2022 03:58 AM

Hi @MarkusWeick,

Its working, thank you very much

Best regards