I Need Average Value in SAS VA

[PavanKumar2]

I have 4 columns as Portfolio, ReleaseID, BudID ,Difference in days In List table.

example:

Sales  ,17.4, 132,13

sales ,17.4,  133.12

sales ,17.4,  134,12

average : (13+12+12)/3 --12.33

I need : Portfolio ,ReleaseID ,Average in days(Here I want summary based on Portfolio and ReleaseId) in List table.

Sales ,17.4, 12.33

Average  formulae Is in aggregated Measure here it is taking group by

avg (group by) (Measure)

when I am doing this Avg (Groupby) (Difference in days) here I am getting Problem.(13/1+(12+12)/2)

if difference in days are same  then I am getting problem.

It will take group  by on Difference in days but I  need group by (13+12+12)/3. But in aggregated Measure if we use average Formulae by default it asks for group by value.

Is there any way to calculate Avg

[Sam_SAS]

Hello Pavan,

Are you sure you want an aggregated measure here? If you just change the aggregation of the measure to Average, then that will evaluate the average values for your totals row in the list table.

That is to say, I don't think it should be necessary to create a new data item in this case.

Does that help?

Thanks,

Sam

[PavanKumar2]

Hi sam ,

Thanks for your  advise . I have duplicate values in Measure to avoid that  I have divided that measure with frequency and got Difference in days as Aggregated Measure (Frequency can only be used in Aggregated Measure).Here I need to get average number of days for that aggregated measure.

Is there any other alternative to find solution

I am attaching a screen shot FYI.

 

[Sam_SAS]

Hello Pavan,

What expression are you using to get the screenshot you posted?

Do you want to determine the average value for "Difference in days for DTAT with frequency"?

Thanks,

Sam

[PavanKumar2]

Hi sam ,

Yes. I want average value for "Difference in days for DTAT with frequency .

[Sam_SAS]

Can you share the aggregated expression you are using to calculate "Difference in days for DTAT with frequency"?

I am still not sure I understand why you do not simply assign the Average aggregation to the "Difference in Days" measure.