Aggregated measure SAS VA

[sara112233]

Hello,

i need to create aggregates measure in SAS VA between values in different rows.

i attach an example file where you can find my desired result and formulas i need to create in VA.

Thank you!

Sara

[Frank_Boekamp · Accepted solution]

Hi Sara,

I'm not sure about which rows you would like to compare. If you would like to compare different machines with aggregated measures maybe you could try splitting up your measure: one measure for each machine. Splitting the measure you can do by creating a new calculated measure for each machine using an IF-THEN-ELSE construct like:

IF machine='k1'

then WGT_WASTE

else .

[sara112233]

Hi Frank,

thank you for your suggestion. it gives me thew idea to solve my problem.

Sara