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: 53

Re: Aggregated measure SAS VA

[ Edited ]

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: 53

Re: Aggregated measure SAS VA

[ Edited ]

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

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
  • 597 views
  • 0 likes
  • 2 in conversation