Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Aggregated measure SAS VA

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Aggregated measure SAS VA

[ Edited ]

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


Accepted Solutions
Solution
‎11-23-2016 10:02 AM
Contributor
Posts: 55

Re: Aggregated measure SAS VA

[ Edited ]
Posted in reply to sara112233

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 .

 

 

View solution in original post


All Replies
Solution
‎11-23-2016 10:02 AM
Contributor
Posts: 55

Re: Aggregated measure SAS VA

[ Edited ]
Posted in reply to sara112233

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 .

 

 

New Contributor
Posts: 2

Re: Aggregated measure SAS VA

Posted in reply to Frank_Boekamp

Hi Frank,

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

Sara

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 880 views
  • 0 likes
  • 2 in conversation